Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.85 KB | None | 0 0
  1. // Import to Database
  2. using (pwpEntities dc = new pwpEntities())
  3. {
  4. foreach (DataRow dr in ds.Tables[0].Rows)
  5. {
  6. string FirstName = dr["First Name"].ToString();
  7. var v = dc.tblUserDetailsProp.Where(a => a.vchFirstName.Equals(FirstName)).FirstOrDefault();
  8. if (v != null)
  9. {
  10. // Update here
  11. v.CompanyName = dr["Company Name"].ToString();
  12. v.vchLocation = dr["Location"].ToString();
  13. v.vchFirstName = dr["First Name"].ToString();
  14. v.vchMobile1 = dr["Mobile 1"].ToString();
  15. v.vchMobile = dr["Mobile"].ToString();
  16. v.vchEmail = dr["Email"].ToString();
  17. v.vchUserName = dr["User Name"].ToString();
  18. v.ServiceId = Convert.ToInt32(dr["Service Id"]);
  19. v.vchPassword = dr["Password"].ToString();
  20. v.UserTypeFkId = Convert.ToInt32(dr["UserTypeFkId"]);
  21. }
  22. else
  23. {
  24. // Insert
  25. dc.tblUserDetailsProp.Add(new tblUserDetails
  26. {
  27. CompanyName = dr["Company Name"].ToString(),
  28. vchLocation = dr["Location"].ToString(),
  29. vchFirstName = dr["First Name"].ToString(),
  30. vchMobile1 = dr["Mobile 1"].ToString(),
  31. vchMobile = dr["Mobile"].ToString(),
  32. vchEmail = dr["Email"].ToString(),
  33. vchUserName = dr["User Name"].ToString(),
  34. ServiceId = Convert.ToInt32(dr["Service Id"]),
  35. vchPassword = dr["Password"].ToString(),
  36. UserTypeFkId = Convert.ToInt32(dr["UserTypeFkId"])
  37. });
  38. }
  39. }
  40.  
  41. dc.SaveChanges();
  42. }
  43.  
  44. public partial class tblUserDetails
  45. {
  46. public int intId { get; set; }
  47. public string vchFirstName { get; set; }
  48. public string vchLastName { get; set; }
  49. public string vchUserName { get; set; }
  50. public string vchPassword { get; set; }
  51. public string vchEmail { get; set; }
  52. public string vchIMEI { get; set; }
  53. public Nullable<double> Weight { get; set; }
  54. ...
  55. }
  56.  
  57. using System;
  58. using System.Data.Entity;
  59. using System.Data.Entity.Infrastructure;
  60.  
  61. public partial class pwpEntities : DbContext
  62. {
  63. public pwpEntities()
  64. : base("name=pwpEntities")
  65. {
  66. }
  67.  
  68. protected override void OnModelCreating(DbModelBuilder modelBuilder)
  69. {
  70. throw new UnintentionalCodeFirstException();
  71. }
  72.  
  73. public DbSet<tblUserDetails> tblUserDetailsProp { get; set; }
  74. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement