public void UpdateProduct(ProductView pv) { using (SampleEntities db = new SampleEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { Product _product = db.Products.Find(pv.Id); if(_product!=null) { _product.ProductDescription = pv.ProductDescription; _product.ProductName = pv.ProductName; _product.ProductProce = pv.ProductProce; _product.UpdateBy = pv.UpdateBy; _product.UpdatedDate = pv.UpdatedDate; db.SaveChanges(); } dbContextTransaction.Commit(); } catch(Exception ex) { dbContextTransaction.Rollback(); } } } }
public void AddUserAccount(UserSignUpView user) { using (SampleEntities db = new SampleEntities()) { SYSUser SU = new SYSUser(); SU.LoginName = user.LoginName; SU.PasswordEncryptedText = user.Password; SU.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SU.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; ; SU.RowCreatedDateTime = DateTime.Now; SU.RowMOdifiedDateTime = DateTime.Now; db.SYSUsers.Add(SU); db.SaveChanges(); SYSUserProfile SUP = new SYSUserProfile(); SUP.SYSUserID = SU.SYSUserID; SUP.FirstName = user.FirstName; SUP.LastName = user.LastName; SUP.Gender = user.Gender; SUP.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SUP.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SUP.RowCreatedDateTime = DateTime.Now; SUP.RowModifiedDateTime = DateTime.Now; db.SYSUserProfiles.Add(SUP); db.SaveChanges(); if (user.LOOKUPRoleID > 0) { SYSUserRole SUR = new SYSUserRole(); SUR.LOOKUPRoleID = user.LOOKUPRoleID; SUR.SYSUserID = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SUR.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; db.SYSUserRoles.Add(SUR); db.SaveChanges(); } } }
public void AddProduct(ProductView pv) { using (SampleEntities db = new SampleEntities()) { Product p = new Product(); p.ProductName = pv.ProductName; p.ProductProce = pv.ProductProce; p.ProductDescription = pv.ProductDescription; p.CreatedBy = pv.CreatedBy; p.CreatedDate = pv.CreatedDate; p.UpdateBy = pv.UpdateBy; p.UpdatedDate = pv.UpdatedDate; db.Products.Add(p); db.SaveChanges(); } }