public int SaveMRRSet(List <vmProductionPrdSetSetupDDL> masterList, UserCommonEntity commonEntity)
{
int result = (int)ResponseMessage.Error;
try
{
PrdDyingMRRSet entity = GenerateSetup(masterList, commonEntity);
GenericFactoryEF_PrdDyingMRRSet.Insert(entity);
GenericFactoryEF_PrdDyingMRRSet.Save();
result = (int)entity.DyingSetID;
}
catch (Exception ex)
{
ex.Message.ToString();
result = (int)ResponseMessage.Exception;
}
return(result);
}
public PrdDyingMRRSet GenerateSetup(List <vmProductionPrdSetSetupDDL> masterList, UserCommonEntity commonEntity)
{
PrdDyingMRRSet mRRSet = new PrdDyingMRRSet();
try
{
bool isDeleted = false;
DateTime serverDate = DateTime.Now;
List <vmPrdSetSetup> listSetup = new List <vmPrdSetSetup>();
using (ERP_Entities context = new ERP_Entities())
{
var dateQuery = context.Database.SqlQuery <DateTime>("SELECT getdate()");
serverDate = dateQuery.AsEnumerable().First();
foreach (vmProductionPrdSetSetupDDL item in masterList)
{
vmPrdSetSetup setupEntity = (from setup in context.PrdSetSetups
join pi in context.SalPIMasters on setup.PIID equals pi.PIID into leftPIgroup
from lfg in leftPIgroup.DefaultIfEmpty()
where setup.SetID == item.id
select new vmPrdSetSetup
{
SetID = setup.SetID,
SetNo = setup.SetNo,
SetMasterID = setup.SetMasterID,
ItemID = setup.ItemID,
YarnID = setup.YarnID,
YarnCount = setup.YarnCount,
YarnRatioLot = setup.YarnRatioLot,
YarnRatio = setup.YarnRatio,
SetTrackingNo = setup.SetTrackingNo,
NoOfBall = setup.NoOfBall,
SetLength = setup.SetLength,
MachineSpeed = setup.MachineSpeed,
TotalEnds = setup.TotalEnds,
Weave = setup.Weave,
EndsPerRope = setup.EndsPerRope,
EndsPerCreel = setup.EndsPerCreel,
LeaseReapet = setup.LeaseReapet,
PIID = setup.PIID,
PINo = lfg.PINO,
SupplierID = setup.SupplierID,
BuyerID = setup.BuyerID,
ColorID = setup.ColorID,
WeftYarnID = setup.WeftYarnID,
WarpYarnID = setup.WarpYarnID,
Description = setup.Description,
SetDate = setup.SetDate,
CompanyID = setup.CompanyID,
CreateBy = setup.CreateBy,
CreateOn = setup.CreateOn,
CreatePc = setup.CreatePc,
UpdateBy = setup.UpdateBy,
UpdateOn = setup.UpdateOn,
UpdatePc = setup.UpdatePc,
IsDeleted = setup.IsDeleted,
DeleteBy = setup.DeleteBy,
DeleteOn = setup.DeleteOn,
DeletePc = setup.DeletePc
}).FirstOrDefault();
listSetup.Add(setupEntity);
}
}
GenericFactoryEF_PrdDyingMRRSet = new PrdDyingMRRSet_EF();
mRRSet.DyingSetID = Convert.ToInt16(GenericFactoryEF_PrdDyingMRRSet.getMaxID("PrdDyingMRRSet"));
GenericFactoryEF_PrdDyingMRRSet.updateMaxID("PrdDyingMRRSet", Convert.ToInt64(mRRSet.DyingSetID));
mRRSet.DyingPINo = null;
bool firstRow = true;
foreach (vmPrdSetSetup item in listSetup)
{
mRRSet.ItemID = item.ItemID;
if (string.IsNullOrEmpty(mRRSet.DyingPINo))
{
mRRSet.DyingPINo = "0";
}
if (firstRow)
{
mRRSet.DyingSetNo = item.SetNo;
mRRSet.TotalSetLength = item.SetLength ?? 0;
}
else
{
mRRSet.DyingSetNo = mRRSet.DyingSetNo + "," + item.SetNo;
mRRSet.TotalSetLength = mRRSet.TotalSetLength + item.SetLength ?? 0;
}
mRRSet.DyingPINo = mRRSet.DyingPINo + mRRSet.DyingPINo ?? "0";
mRRSet.CompanyID = commonEntity.loggedCompnyID ?? 0;
mRRSet.IsDeleted = isDeleted;
mRRSet.CreateBy = commonEntity.loggedUserID;
mRRSet.CreatePc = HostService.GetIP();
mRRSet.CreateOn = serverDate;
PrdDyingMRRSetDetail mrrSetDetails = new PrdDyingMRRSetDetail();
GenericFactoryEF_PrdDyingMRRSetDetail = new PrdDyingMRRSetDetail_EF();
mrrSetDetails.DyingSetIDDetailID = Convert.ToInt16(GenericFactoryEF_PrdDyingMRRSetDetail.getMaxID("PrdDyingMRRSetDetail"));
GenericFactoryEF_PrdDyingMRRSetDetail.updateMaxID("PrdDyingMRRSetDetail", Convert.ToInt64(mrrSetDetails.DyingSetIDDetailID));
mrrSetDetails.DyingSetID = mRRSet.DyingSetID;
mrrSetDetails.PIID = item.PIID;
mrrSetDetails.SetLength = item.SetLength ?? 0;
mrrSetDetails.SetID = item.SetID;
mrrSetDetails.CompanyID = commonEntity.loggedCompnyID ?? 0;
mrrSetDetails.IsDeleted = isDeleted;
mrrSetDetails.CreateBy = mRRSet.CreateBy;
mrrSetDetails.CreatePc = mRRSet.CreatePc;
mrrSetDetails.CreateOn = mRRSet.CreateOn;
mRRSet.PrdDyingMRRSetDetails.Add(mrrSetDetails);
firstRow = false;
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(mRRSet);
}
