public HttpResponseMessage SaveFinishProPricSetup(object[] data)
{
string result = "";
try
{
prdFinishingProcessPriceSetup objPrdFinishingProcessPriceSetup = JsonConvert.DeserializeObject <prdFinishingProcessPriceSetup>(data[0].ToString());
int menuID = Convert.ToInt16(data[1]);
if (ModelState.IsValid && objPrdFinishingProcessPriceSetup != null && objPrdFinishingProcessPriceSetup.FinishingProcessID.ToString() != "" && menuID != 0)
{
result = objFPR.SaveFinishProPricSetup(objPrdFinishingProcessPriceSetup, menuID);
}
else
{
result = "";
}
}
catch (Exception e)
{
e.ToString();
result = "";
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public string SaveFinishProPricSetup(prdFinishingProcessPriceSetup objPrdFinishingProcessPriceSetup, int menuID)
{
GenericFactory_EF_CmnCombo = new CmnCombo_EF();
string result = "";
using (ERP_Entities _ctxCmn = new ERP_Entities())
{
using (TransactionScope transactionScope = new TransactionScope())
{
try
{
List <prdFinishingProcessPriceSetup> lstFroUpdate = (from lupdate in _ctxCmn.prdFinishingProcessPriceSetups.Where(m => m.IsActive == true && m.CompanyID == objPrdFinishingProcessPriceSetup.CompanyID && m.FinishingProcessID == objPrdFinishingProcessPriceSetup.FinishingProcessID).ToList() select lupdate).ToList();
prdFinishingProcessPriceSetup objFpp = new prdFinishingProcessPriceSetup();
foreach (prdFinishingProcessPriceSetup fp in lstFroUpdate)
{
fp.IsActive = false;
//objFpp = fp;
}
long NextId = Convert.ToInt64(GenericFactory_EF_CmnCombo.getMaxID("prdFinishingProcessPriceSetup"));
string customCode = "";
string CustomNo = GenericFactory_EF_CmnCombo.getCustomCode(menuID, DateTime.Now, objPrdFinishingProcessPriceSetup.CompanyID, 1, 1);
if (!string.IsNullOrEmpty(CustomNo))
{
customCode = CustomNo;
}
else if (string.IsNullOrEmpty(CustomNo))
{
customCode = NextId.ToString();
}
//.........END for custom code............ //
string newProcessPriceNo = customCode;
objPrdFinishingProcessPriceSetup.ProcessPriceID = (int)NextId;
objPrdFinishingProcessPriceSetup.CreateOn = DateTime.Now;
objPrdFinishingProcessPriceSetup.CreatePc = HostService.GetIP();
objPrdFinishingProcessPriceSetup.ProcessPriceNo = newProcessPriceNo;
_ctxCmn.prdFinishingProcessPriceSetups.Add(objPrdFinishingProcessPriceSetup);
//............Update MaxID.................//
GenericFactory_EF_CmnCombo.updateMaxID("prdFinishingProcessPriceSetup", Convert.ToInt64(NextId));
//............Update CustomCode.............//
GenericFactory_EF_CmnCombo.updateCustomCode(menuID, DateTime.Now, objPrdFinishingProcessPriceSetup.CompanyID, 1, 1);
_ctxCmn.SaveChanges();
transactionScope.Complete();
result = newProcessPriceNo;
}
catch (Exception e)
{
result = "";
}
}
}
return(result);
}
