Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Import to Database
- using (pwpEntities dc = new pwpEntities())
- {
- foreach (DataRow dr in ds.Tables[0].Rows)
- {
- string FirstName = dr["First Name"].ToString();
- var v = dc.tblUserDetailsProp.Where(a => a.vchFirstName.Equals(FirstName)).FirstOrDefault();
- if (v != null)
- {
- // Update here
- v.CompanyName = dr["Company Name"].ToString();
- v.vchLocation = dr["Location"].ToString();
- v.vchFirstName = dr["First Name"].ToString();
- v.vchMobile1 = dr["Mobile 1"].ToString();
- v.vchMobile = dr["Mobile"].ToString();
- v.vchEmail = dr["Email"].ToString();
- v.vchUserName = dr["User Name"].ToString();
- v.ServiceId = Convert.ToInt32(dr["Service Id"]);
- v.vchPassword = dr["Password"].ToString();
- v.UserTypeFkId = Convert.ToInt32(dr["UserTypeFkId"]);
- }
- else
- {
- // Insert
- dc.tblUserDetailsProp.Add(new tblUserDetails
- {
- CompanyName = dr["Company Name"].ToString(),
- vchLocation = dr["Location"].ToString(),
- vchFirstName = dr["First Name"].ToString(),
- vchMobile1 = dr["Mobile 1"].ToString(),
- vchMobile = dr["Mobile"].ToString(),
- vchEmail = dr["Email"].ToString(),
- vchUserName = dr["User Name"].ToString(),
- ServiceId = Convert.ToInt32(dr["Service Id"]),
- vchPassword = dr["Password"].ToString(),
- UserTypeFkId = Convert.ToInt32(dr["UserTypeFkId"])
- });
- }
- }
- dc.SaveChanges();
- }
- public partial class tblUserDetails
- {
- public int intId { get; set; }
- public string vchFirstName { get; set; }
- public string vchLastName { get; set; }
- public string vchUserName { get; set; }
- public string vchPassword { get; set; }
- public string vchEmail { get; set; }
- public string vchIMEI { get; set; }
- public Nullable<double> Weight { get; set; }
- ...
- }
- using System;
- using System.Data.Entity;
- using System.Data.Entity.Infrastructure;
- public partial class pwpEntities : DbContext
- {
- public pwpEntities()
- : base("name=pwpEntities")
- {
- }
- protected override void OnModelCreating(DbModelBuilder modelBuilder)
- {
- throw new UnintentionalCodeFirstException();
- }
- public DbSet<tblUserDetails> tblUserDetailsProp { get; set; }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement