public PRODUCT_DEVELOPMENT ChangeStatus(string id, Core.ReferenceKeys.ApprovalStatus status, int formType, int actionType, int role, string user, string comment = null)
{
using (var context = new EMSDataModel())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var old = context.PRODUCT_DEVELOPMENT.Find(id);
var data = (PRODUCT_DEVELOPMENT)context.Entry(old).GetDatabaseValues().ToObject();
//data.STATUS_APPROVAL = refService.GetReferenceByKey(status).REFF_ID;
//if (status == Core.ReferenceKeys.ApprovalStatus.Completed)
//{
// data.LASTAPPROVED_BY = user;
// data.LASTAPPROVED_DATE = DateTime.Now;
//}
//else if (status == Core.ReferenceKeys.ApprovalStatus.AwaitingAdminApproval)
//{
// data.LASTMODIFIED_BY = user;
// data.LASTMODIFIED_DATE = DateTime.Now;
//}
//data.APPROVAL_STATUS = context.SYS_REFFERENCES.Find(data.STATUS_APPROVAL);
//Dictionary<string, string[]> changes = GetAllChanges(old, data);
//context.Entry(old).CurrentValues.SetValues(data);
//context.SaveChanges();
//LogsActivity(context, data, changes, formType, actionType, role, user, comment);
//transaction.Commit();
return(data);
}
catch (Exception ex)
{
throw this.HandleException("Exception occured on Brand Registration Service. See Inner Exception property to see details", ex);
}
}
}
}
public MASTER_FINANCIAL_RATIO ChangeStatus(long id, Core.ReferenceKeys.ApprovalStatus status, int formType, int actionType, int role, string user, string comment = null)
{
using (var context = new EMSDataModel())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var old = context.MASTER_FINANCIAL_RATIO.Find(id);
var data = (MASTER_FINANCIAL_RATIO)context.Entry(old).GetDatabaseValues().ToObject();
data.STATUS_APPROVAL = refService.GetReferenceByKey(status).REFF_ID;
if (status == Core.ReferenceKeys.ApprovalStatus.Completed)
{
data.LASTAPPROVED_BY = user;
data.LASTAPPROVED_DATE = DateTime.Now;
}
else if (status == Core.ReferenceKeys.ApprovalStatus.AwaitingAdminApproval)
{
data.LASTMODIFIED_BY = user;
data.LASTMODIFIED_DATE = DateTime.Now;
}
data.COMPANY = context.T001.Find(data.BUKRS);
data.APPROVALSTATUS = context.SYS_REFFERENCES.Find(data.STATUS_APPROVAL);
Dictionary <string, string[]> changes = GetAllChanges(old, data);
context.Entry(old).CurrentValues.SetValues(data);
context.SaveChanges();
LogsActivity(context, data, changes, formType, actionType, role, user, comment);
transaction.Commit();
return(data);
}
catch (Exception ex)
{
throw this.HandleException("Exception occured on FinanceRatioManagementService. See Inner Exception property to see details", ex);
}
}
}
}