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