public string DeleteChemicalPreparationMasterDetail(vmCmnParameters objcmnParam)
{
string result = "";
using (var transaction = new TransactionScope())
{
GFactory_EF_PrdDyingChemicalSetup = new PrdDyingChemicalSetup_EF();
GenericFactory_EF_PrdDyingChemicalSetupDetail = new PrdDyingChemicalSetupDetail_EF();
var MasterItem = new PrdDyingChemicalSetup();
var DetailItem = new List <PrdDyingChemicalSetupDetail>();
//For Update Master Detail
var MasterAll = GFactory_EF_PrdDyingChemicalSetup.GetAll().Where(x => x.ChemicalSetupID == objcmnParam.id && x.CompanyID == objcmnParam.loggedCompany);
var DetailAll = GenericFactory_EF_PrdDyingChemicalSetupDetail.GetAll().Where(x => x.ChemicalSetupID == objcmnParam.id && x.CompanyID == objcmnParam.loggedCompany);
//-------------------END----------------------
try
{
MasterItem = MasterAll.First(x => x.ChemicalSetupID == objcmnParam.id);
MasterItem.CompanyID = objcmnParam.loggedCompany;
MasterItem.DeleteBy = objcmnParam.loggeduser;
MasterItem.DeleteOn = DateTime.Now;
MasterItem.DeletePc = HostService.GetIP();
MasterItem.IsDeleted = true;
foreach (PrdDyingChemicalSetupDetail d in DetailAll.Where(d => d.ChemicalSetupID == objcmnParam.id))
{
d.CompanyID = objcmnParam.loggedCompany;
d.DeleteBy = objcmnParam.loggeduser;
d.DeleteOn = DateTime.Now;
d.DeletePc = HostService.GetIP();
d.IsDeleted = true;
DetailItem.Add(d);
}
if (MasterItem != null)
{
GFactory_EF_PrdDyingChemicalSetup.Update(MasterItem);
GFactory_EF_PrdDyingChemicalSetup.Save();
}
if (DetailItem != null)
{
GenericFactory_EF_PrdDyingChemicalSetupDetail.UpdateList(DetailItem.ToList());
GenericFactory_EF_PrdDyingChemicalSetupDetail.Save();
}
transaction.Complete();
result = MasterItem.CmnItemColor.ColorName;
}
catch (Exception e)
{
result = "";
e.ToString();
}
}
return(result);
}
public int SaveChemicalPrepartion(PrdDyingChemicalSetup model, List <PrdDyingChemicalSetupDetail> details, UserCommonEntity commonEntity)
{
GFactory_EF_PrdDyingChemicalSetup = new PrdDyingChemicalSetup_EF();
GenericFactory_EF_PrdDyingChemicalSetupDetail = new PrdDyingChemicalSetupDetail_EF();
int masterID = (int)model.ChemicalSetupID;
PrdDyingChemicalSetup modelBase = new PrdDyingChemicalSetup();
List <Int32> UpdatedIDs = new List <Int32>();
List <PrdDyingChemicalSetupDetail> detailsList = new List <PrdDyingChemicalSetupDetail>();
List <PrdDyingChemicalSetupDetail> detailsInsertionList = new List <PrdDyingChemicalSetupDetail>();
int result = 0;
try
{
modelBase = ModelBinding(model, details);
foreach (var item in modelBase.PrdDyingChemicalSetupDetails)
{
if (item.EntryStateStatus == "Modified")
{
PrdDyingChemicalSetupDetail detailsEntity = new PrdDyingChemicalSetupDetail();
detailsEntity = DetailsBinding(modelBase.PrdDyingChemicalSetupDetails.Where(x => x.ChemicalSetupDetailID == item.ChemicalSetupDetailID).FirstOrDefault());
detailsList.Add(detailsEntity);
UpdatedIDs.Add((int)detailsEntity.ChemicalSetupDetailID);
}
if (item.EntryStateStatus == "Add" && masterID > 0)
{
PrdDyingChemicalSetupDetail detailsEntity = new PrdDyingChemicalSetupDetail();
detailsEntity = DetailsBinding(modelBase.PrdDyingChemicalSetupDetails.Where(x => x.ChemicalSetupDetailID == item.ChemicalSetupDetailID).FirstOrDefault());
detailsInsertionList.Add(detailsEntity);
}
}
foreach (var item in UpdatedIDs)
{
modelBase.PrdDyingChemicalSetupDetails.Remove(modelBase.PrdDyingChemicalSetupDetails.Where(x => x.ChemicalSetupDetailID == item).FirstOrDefault());
}
if (masterID == 0)
{
GFactory_EF_PrdDyingChemicalSetup.Insert(modelBase);
GFactory_EF_PrdDyingChemicalSetup.Save();
}
else
{
GFactory_EF_PrdDyingChemicalSetup.Update(model);
GenericFactory_EF_PrdDyingChemicalSetupDetail.UpdateList(detailsList);
GenericFactory_EF_PrdDyingChemicalSetupDetail.InsertList(detailsInsertionList);
GFactory_EF_PrdDyingChemicalSetup.Save();
GenericFactory_EF_PrdDyingChemicalSetupDetail.Save();
}
result = 1;
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(result);
}
public IHttpActionResult SaveChemicalPrepartion(object[] data)
{
int result = 0;
PrdDyingChemicalSetup master = JsonConvert.DeserializeObject <PrdDyingChemicalSetup>(data[0].ToString());
List <PrdDyingChemicalSetupDetail> Details = JsonConvert.DeserializeObject <List <PrdDyingChemicalSetupDetail> >(data[1].ToString());
#region Shared Entity
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[2].ToString());
var loggedCompnyID = commonEntity.loggedCompnyID;
var loggedUserID = commonEntity.loggedUserID;
var MenuID = commonEntity.currentMenuID;
var loggedUserBranchID = commonEntity.loggedUserBranchID;
var currentModuleID = commonEntity.currentModuleID;
var loggedUserDepartmentID = commonEntity.loggedUserDepartmentID;
var TransactionTypeID = commonEntity.currentTransactionTypeID;
List <CmnMenu> menuList = JsonConvert.DeserializeObject <List <CmnMenu> >(commonEntity.MenuList.ToString());
List <CmnMenu> ChildMenues = JsonConvert.DeserializeObject <List <CmnMenu> >(commonEntity.ChildMenues.ToString());
#endregion Shared Entity
try
{
result = objChemicalService.SaveChemicalPrepartion(master, Details, commonEntity);
// result = 1;
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(Json(new
{
result
}));
//return _finishGoodes;
}
private PrdDyingChemicalSetup ModelBinding(PrdDyingChemicalSetup model, List <PrdDyingChemicalSetupDetail> details)
{
GFactory_EF_PrdDyingChemicalSetup = new PrdDyingChemicalSetup_EF();
try
{
Int64 NextID = GFactory_EF_PrdDyingChemicalSetup.getMaxVal_int64("ChemicalSetupID", "PrdDyingChemicalSetup");
model.ChemicalSetupID = model.ChemicalSetupID == 0 ? NextID : model.ChemicalSetupID;
model.ColorID = model.ColorID;
model.Qty = model.Qty;
model.DepartmentID = model.DepartmentID;
model.UserID = model.UserID;
model.UnitID = model.UnitID;
model.IsDeleted = false;
NextID = GFactory_EF_PrdDyingChemicalSetup.getMaxVal_int64("ChemicalSetupDetailID", "PrdDyingChemicalSetupDetail");
foreach (PrdDyingChemicalSetupDetail Item in details)
{
PrdDyingChemicalSetupDetail entity = new PrdDyingChemicalSetupDetail();
entity.ChemicalSetupDetailID = Item.ChemicalSetupDetailID;
if (Item.ChemicalSetupDetailID == 0)
{
if (Item.IsDeleted)
{
continue;
}
Item.ChemicalSetupDetailID = NextID++;
entity.ChemicalSetupDetailID = Item.ChemicalSetupDetailID;
entity.EntryStateStatus = "Add";
}
else if (Item.IsDeleted == true)
{
entity.EntryStateStatus = "Delete";
}
else
{
entity.EntryStateStatus = "Modified";
}
entity.ItemID = Item.ItemID;
entity.Qty = Item.Qty;
entity.ChemicalSetupID = model.ChemicalSetupID;
entity.UnitID = Item.UnitID;
entity.IsDeleted = Item.IsDeleted;
entity.CompanyID = Item.CompanyID;
entity.CompanyID = model.CompanyID;
entity.CreateBy = Item.CreateBy;
entity.CreateOn = Item.CreateOn;
entity.CreatePc = Item.CreatePc;
entity.UpdateBy = Item.UpdateBy;
entity.UpdateOn = Item.UpdateOn;
entity.UpdatePc = Item.UpdatePc;
if (entity.EntryStateStatus != "Delete")
{
entity.IsDeleted = false;
}
else
{
entity.EntryStateStatus = "Modified";
entity.IsDeleted = true;
}
entity.DeleteBy = Item.DeleteBy;
entity.DeleteOn = Item.DeleteOn;
entity.DeletePc = Item.DeletePc;
model.PrdDyingChemicalSetupDetails.Add(entity);
}
return(model);
}
catch (Exception ex)
{
ex.Message.ToString();
throw;
}
}
