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();
}
}