public int UpdatePersonRoute(PharmaBusinessObjects.Master.PersonRouteMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { var personRouteMaster = context.PersonRouteMaster.Where(q => q.PersonRouteID == p.PersonRouteID).FirstOrDefault(); if (personRouteMaster != null) { //personRouteMaster.PersonRouteCode = p.PersonRouteCode; personRouteMaster.PersonRouteName = p.PersonRouteName; personRouteMaster.ModifiedBy = this.LoggedInUser.Username; personRouteMaster.ModifiedOn = System.DateTime.Now; personRouteMaster.Status = p.Status; } if (context.SaveChanges() > 0) { return(personRouteMaster.PersonRouteID); } else { return(0); } } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } } }
public int AddPersonRoute(PharmaBusinessObjects.Master.PersonRouteMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { var maxPersonRouteMasterID = context.PersonRouteMaster.Where(q => q.RecordTypeId == p.RecordTypeId).Count() + 1; var systemName = context.RecordType.Where(q => q.RecordTypeId == p.RecordTypeId).FirstOrDefault().SystemName; var personRouteCode = systemName + maxPersonRouteMasterID.ToString().PadLeft(3, '0'); Entity.PersonRouteMaster table = new Entity.PersonRouteMaster() { PersonRouteID = p.PersonRouteID, PersonRouteCode = personRouteCode, PersonRouteName = p.PersonRouteName, RecordTypeId = p.RecordTypeId, CreatedBy = this.LoggedInUser.LastName, CreatedOn = System.DateTime.Now, Status = p.Status }; context.PersonRouteMaster.Add(table); if (context.SaveChanges() > 0) { return(table.PersonRouteID); } else { return(0); } } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } } }