public IEnumerable <vmHDODetail> GetDODetailByID(vmCmnParameters objcmnParam)
{
GenericFactoryFor_HDOMaster_EF = new SalHDOMaster_EF();
GenericFactoryFor_HDODetails_EF = new SalHDODetail_EF();
IEnumerable <vmHDODetail> objDODetail = null;
string spQuery = string.Empty;
try
{
using (_ctxCmn = new ERP_Entities())
{
var HDONoWiseID = GenericFactoryFor_HDOMaster_EF.FindBy(HD => objcmnParam.ParamName == "" ? HD.HDOID == objcmnParam.id : HD.HDONo == objcmnParam.ParamName).Select(x => x.HDOID).FirstOrDefault();
var IsPIID = GenericFactoryFor_HDODetails_EF.FindBy(HD => HD.HDOID == HDONoWiseID).ToList().Select(x => x.PIID).FirstOrDefault();
if (IsPIID > 0)
{
objDODetail = (from HD in _ctxCmn.SalHDODetails
join CIM in _ctxCmn.CmnItemMasters on HD.ProductID equals CIM.ItemID
join PM in _ctxCmn.SalPIMasters on HD.PIID equals PM.PIID
where HD.HDOID == HDONoWiseID && HD.IsFDOCompleted == false
orderby HD.HDODetailID descending
select new vmHDODetail
{
HDODetailID = HD.HDODetailID,
PIID = (int)HD.PIID,
ItemID = (int)HD.ProductID,
PINO = PM.PINO,
ItemName = CIM.ItemName,
UnitPrice = (decimal)HD.Price,
Quantity = (decimal)HD.Quantity,
RemainingQty = (decimal)HD.RemainingQty,
HoldQty = (decimal)HD.RemainingQty,
Amount = (decimal)HD.Amount,
LotNos = (from L in _ctxCmn.CmnLots
where L.LotNo != null && L.ItemID == HD.ProductID
select new vmLot {
LotID = L.LotID, LotNo = L.LotNo
}).ToList(),
BatchNos = (from B in _ctxCmn.CmnBatches
where B.BatchNo != null && B.ItemID == HD.ProductID
select new vmBatch {
BatchID = B.BatchID, BatchNo = B.BatchNo
}).ToList(),
GradeList = (from B in _ctxCmn.CmnItemGrades
where B.GradeName != null
select new vmGrade {
ItemGradeID = B.ItemGradeID, GradeName = B.GradeName
}).ToList()
}).ToList();
}
else
{
objDODetail = (from HD in _ctxCmn.SalHDODetails
join CIM in _ctxCmn.CmnItemMasters on HD.ProductID equals CIM.ItemID
where HD.HDOID == HDONoWiseID && HD.IsFDOCompleted == false //&& PM.IsActive == true
orderby HD.HDODetailID descending
select new vmHDODetail
{
HDODetailID = HD.HDODetailID,
PIID = 0,
ItemID = (int)HD.ProductID,
PINO = "Not Available",
ItemName = CIM.ItemName,
UnitPrice = (decimal)HD.Price,
Quantity = (decimal)HD.Quantity,
RemainingQty = (decimal)HD.RemainingQty,
HoldQty = (decimal)HD.RemainingQty,
Amount = (decimal)HD.Amount,
LotNos = (from L in _ctxCmn.CmnLots
where L.LotNo != null && L.ItemID == HD.ProductID
select new vmLot {
LotID = L.LotID, LotNo = L.LotNo
}).ToList(),
BatchNos = (from B in _ctxCmn.CmnBatches
where B.BatchNo != null && B.ItemID == HD.ProductID
select new vmBatch {
BatchID = B.BatchID, BatchNo = B.BatchNo
}).ToList(),
GradeList = (from B in _ctxCmn.CmnItemGrades
where B.GradeName != null
select new vmGrade {
ItemGradeID = B.ItemGradeID, GradeName = B.GradeName
}).ToList()
}).ToList();
}
}
}
catch (Exception e)
{
e.ToString();
}
return(objDODetail);
}
public string SaveUpdateFebricInspection(PrdFinishingInspactionMaster Master, List <vmFinishingInspactionDetail> Detail, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (var transaction = new TransactionScope())
{
//*********************************************Start Initialize Variable*****************************************
long MasterId = 0, DetailId = 0, FirstDigit = 0, OtherDigits = 0; string CustomNo = string.Empty, InspactionNo = string.Empty;
//***************************************End Initialize Variable*************************************************
//**************************Start Initialize Generic Repository Based on table***********************************
GenericFactory_EFFinishingInspactionMaster = new PrdFinishingInspactionMaster_EF();
GenericFactory_EFFinishingInspactionDetails = new PrdFinishingInspactionDetail_EF();
//****************************End Initialize Generic Repository Based on table***********************************
//**********************************Start Create Related Table Instance to Save**********************************
var MasterItem = new PrdFinishingInspactionMaster();
var DetailItem = new List <PrdFinishingInspactionDetail>();
var DetailItems = new List <PrdFinishingInspactionDetail>();
//************************************End Create Related Table Instance to Save**********************************
//*************************************Start Create Model Instance to get Data***********************************
vmFinishingInspactionDetail item = new vmFinishingInspactionDetail();
vmFinishingInspactionDetail items = new vmFinishingInspactionDetail();
PrdFinishingInspactionDetail itemdel = new PrdFinishingInspactionDetail();
//***************************************End Create Model Instance to get Data***********************************
var SDetail = Detail.Where(x => x.InspactionID == 0).ToList();
var UDetail = Detail.Where(x => x.InspactionID != 0).ToList();
//**************************************************Start Main Operation************************************************
if (Detail.Count > 0)
{
try
{
if (Master.InspactionID == 0)
{
//***************************************************Start Save Operation************************************************
//**********************************************Start Generate Master & Detail ID****************************************
MasterId = Convert.ToInt16(GenericFactory_EFFinishingInspactionMaster.getMaxID("PrdFinishingInspactionMaster"));
DetailId = Convert.ToInt64(GenericFactory_EFFinishingInspactionDetails.getMaxID("PrdFinishingInspactionDetail"));
FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1));
//***********************************************End Generate Master & Detail ID*****************************************
CustomNo = GenericFactory_EFFinishingInspactionMaster.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
if (CustomNo == null || CustomNo == "")
{
InspactionNo = MasterId.ToString();
}
else
{
InspactionNo = CustomNo;
}
MasterItem = new PrdFinishingInspactionMaster
{
InspactionID = MasterId,
InspactionNo = InspactionNo,
FinishingMRRID = Master.FinishingMRRID,
ItemID = Master.ItemID,
SetID = Master.SetID,
WeivingMRRID = Master.WeivingMRRID,
SizeMRRID = Master.SizeMRRID,
MachineConfigID = Master.MachineConfigID,
ShiftID = Master.ShiftID,
PlateID = Master.PlateID,
OperatorID = Master.OperatorID,
Date = Master.Date,
Remarks = Master.Remarks,
IsQAComplete = false,
IsDeleted = false,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP()
};
for (int i = 0; i < Detail.Count; i++)
{
item = Detail[i];
var Detailitem = new PrdFinishingInspactionDetail
{
InspactionDateilID = Convert.ToInt64(FirstDigit + "" + OtherDigits),
InspactionID = MasterId,
BeamNo = item.BeamNo,
RollNo = item.RollNo,
Length = item.GreigeLength,
UnitID = item.UnitID,
Piece = item.Piece,
DefecetPointID = item.DefectPoint,
GrossWeight = item.GrossWt,
NetWeight = item.NetWt,
Remarks = item.Remarks,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
DetailItem.Add(Detailitem);
OtherDigits++;
}
//***************************************************End Save Operation************************************************
}
else
{
//***********************************Start Get Data From Related Table to Update*********************************
var MasterAll = GenericFactory_EFFinishingInspactionMaster.GetAll().Where(x => x.InspactionID == Master.InspactionID && x.CompanyID == objcmnParam.loggedCompany);
var DetailAll = GenericFactory_EFFinishingInspactionDetails.GetAll().Where(x => x.InspactionID == Master.InspactionID && x.CompanyID == objcmnParam.loggedCompany).ToList();
//*************************************End Get Data From Related Table to Update*********************************
//***************************************************Start Update Operation********************************************
MasterItem = MasterAll.First(x => x.InspactionID == Master.InspactionID);
MasterItem.FinishingMRRID = Master.FinishingMRRID;
MasterItem.ItemID = Master.ItemID;
MasterItem.SetID = Master.SetID;
MasterItem.WeivingMRRID = Master.WeivingMRRID;
MasterItem.SizeMRRID = Master.SizeMRRID;
MasterItem.MachineConfigID = Master.MachineConfigID;
MasterItem.ShiftID = Master.ShiftID;
MasterItem.PlateID = Master.PlateID;
MasterItem.OperatorID = Master.OperatorID;
MasterItem.Date = Master.Date;
MasterItem.Remarks = Master.Remarks;
MasterItem.CompanyID = objcmnParam.loggedCompany;
MasterItem.UpdateBy = objcmnParam.loggeduser;
MasterItem.UpdateOn = DateTime.Now;
MasterItem.UpdatePc = HostService.GetIP();
MasterItem.IsDeleted = false;
for (int i = 0; i < UDetail.Count; i++)
{
item = UDetail[i];
foreach (PrdFinishingInspactionDetail d in DetailAll.Where(d => d.InspactionID == Master.InspactionID && d.InspactionDateilID == item.InspactionDateilID))
{
d.BeamNo = item.BeamNo;
d.RollNo = item.RollNo;
d.Length = item.GreigeLength;
d.UnitID = item.UnitID;
d.Piece = item.Piece;
d.DefecetPointID = item.DefectPoint;
d.GrossWeight = item.GrossWt;
d.NetWeight = item.NetWt;
d.Remarks = item.Remarks;
d.CompanyID = objcmnParam.loggedCompany;
d.UpdateBy = objcmnParam.loggeduser;
d.UpdateOn = DateTime.Now;
d.UpdatePc = HostService.GetIP();
d.IsDeleted = false;
DetailItem.Add(d);
break;
}
}
if (SDetail != null && SDetail.Count != 0)
{
for (int i = 0; i < SDetail.Count; i++)
{
item = SDetail[i];
DetailId = Convert.ToInt64(GenericFactory_EFFinishingInspactionDetails.getMaxID("PrdFinishingInspactionDetail"));
FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1));
var Detailitems = new PrdFinishingInspactionDetail
{
InspactionDateilID = Convert.ToInt64(FirstDigit + "" + OtherDigits),
InspactionID = Master.InspactionID,
BeamNo = item.BeamNo,
RollNo = item.RollNo,
Length = item.GreigeLength,
UnitID = item.UnitID,
Piece = item.Piece,
DefecetPointID = item.DefectPoint,
GrossWeight = item.GrossWt,
NetWeight = item.NetWt,
Remarks = item.Remarks,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
DetailItems.Add(Detailitems);
GenericFactory_EFFinishingInspactionDetails.updateMaxID("PrdFinishingInspactionDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits)));
}
}
if (UDetail.Count < DetailAll.Count())
{
for (int i = 0; i < DetailAll.Count(); i++)
{
itemdel = DetailAll[i];
var delDetail = (from del in DetailItem.Where(x => x.InspactionDateilID == itemdel.InspactionDateilID) select del.InspactionDateilID).FirstOrDefault();
if (delDetail != itemdel.InspactionDateilID)
{
var tem = DetailAll.FirstOrDefault(d => d.InspactionID == Master.InspactionID && d.InspactionDateilID == itemdel.InspactionDateilID);
tem.CompanyID = objcmnParam.loggedCompany;
tem.DeleteBy = objcmnParam.loggeduser;
tem.DeleteOn = DateTime.Now;
tem.DeletePc = HostService.GetIP();
tem.IsDeleted = true;
DetailItem.Add(tem);
}
}
}
//***************************************************End Update Operation********************************************
}
if (Master.InspactionID > 0)
{
//***************************************************Start Update************************************************
if (MasterItem != null)
{
GenericFactory_EFFinishingInspactionMaster.Update(MasterItem);
GenericFactory_EFFinishingInspactionMaster.Save();
}
if (DetailItem != null && DetailItem.Count != 0)
{
GenericFactory_EFFinishingInspactionDetails.UpdateList(DetailItem.ToList());
GenericFactory_EFFinishingInspactionDetails.Save();
}
if (DetailItems != null && DetailItems.Count != 0)
{
GenericFactory_EFFinishingInspactionDetails.InsertList(DetailItems.ToList());
GenericFactory_EFFinishingInspactionDetails.Save();
}
//***************************************************End Update************************************************
}
else
{
//***************************************************Start Save************************************************
if (MasterItem != null)
{
GenericFactory_EFFinishingInspactionMaster.Insert(MasterItem);
GenericFactory_EFFinishingInspactionMaster.Save();
GenericFactory_EFFinishingInspactionMaster.updateMaxID("PrdFinishingInspactionMaster", Convert.ToInt64(MasterId));
}
if (DetailItem != null && DetailItem.Count != 0)
{
GenericFactory_EFFinishingInspactionDetails.InsertList(DetailItem.ToList());
GenericFactory_EFFinishingInspactionDetails.Save();
GenericFactory_EFFinishingInspactionDetails.updateMaxID("PrdFinishingInspactionDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
}
//******************************************************End Save************************************************
}
transaction.Complete();
result = MasterItem.InspactionNo;
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
else
{
result = "";
}
}
return(result);
//**************************************************End Main Operation************************************************
}
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);
}
public string SaveUpdateSetWiseMachineSetupMasterDetail(vmItemSetSetup Master, List <vmItemSetSetup> Detail, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (var transaction = new TransactionScope())
{
GFactory_EF_PrdDyingMachineSetup = new PrdDyingMachineSetup_EF();
GFactory_EF_PrdDyingMachineSetupDetail = new PrdDyingMachineSetupDetail_EF();
long SetMasterId = 0, SetDetailId = 0, FirstDigit = 0, OtherDigits = 0; //string SetNo = "";
var Masteritem = new PrdDyingMachineSetup();
var SetDetail = new List <PrdDyingMachineSetupDetail>();
vmItemSetSetup item = new vmItemSetSetup();
vmItemSetSetup items = new vmItemSetSetup();
//-------------------END----------------------
if (Detail.Count() > 0)
{
try
{
if (Master.SetupID == 0)
{
SetMasterId = Convert.ToInt16(GFactory_EF_PrdDyingMachineSetup.getMaxID("PrdDyingMachineSetup"));
SetDetailId = Convert.ToInt64(GFactory_EF_PrdDyingMachineSetupDetail.getMaxID("PrdDyingMachineSetupDetail"));
FirstDigit = Convert.ToInt64(SetDetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(SetDetailId.ToString().Substring(1, SetDetailId.ToString().Length - 1));
Masteritem = new PrdDyingMachineSetup
{
SetupID = SetMasterId,
Speed = Master.Speed == null ? 0 : (decimal)Master.Speed,
KGPreMin = Master.KGPreMin == null ? 0 : (decimal)Master.KGPreMin,
MechineID = (long)Master.MachineID,
Moiture = Master.Moiture == null ? 0 : (decimal)Master.Moiture,
ItemID = (long)Master.ItemID,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
for (int i = 0; i < Detail.Count(); i++)
{
item = Detail[i];
var Detailitem = new PrdDyingMachineSetupDetail
{
SetupDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits),
SetupID = SetMasterId,
SQPress = item.SQPress == null ? 0 : item.SQPress,
Temp = item.Temp == null ? 0 : item.Temp,
MachineOperationID = (int)item.MachineOperationID,
MachinePartID = (int)item.MachinePartID,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
//***************************************END*******************************************
SetDetail.Add(Detailitem);
OtherDigits++;
}
}
else
{
var SetMasterAll = GFactory_EF_PrdDyingMachineSetup.GetAll().Where(x => x.SetupID == Master.SetupID);
var SetDetailAll = GFactory_EF_PrdDyingMachineSetupDetail.GetAll().Where(x => x.SetupID == Master.SetupID);
Masteritem = SetMasterAll.FirstOrDefault(x => x.SetupID == Master.SetupID);
Masteritem.Speed = (decimal)Master.Speed;
Masteritem.KGPreMin = (decimal)Master.KGPreMin;
Masteritem.MechineID = (long)Master.MachineID;
Masteritem.ItemID = (long)Master.ItemID;
Masteritem.Moiture = (decimal)Master.Moiture;
Masteritem.CompanyID = objcmnParam.loggedCompany;
Masteritem.UpdateBy = objcmnParam.loggeduser;
Masteritem.UpdateOn = DateTime.Now;
Masteritem.UpdatePc = HostService.GetIP();
Masteritem.IsDeleted = false;
for (int i = 0; i < Detail.Count(); i++)
{
item = Detail[i];
foreach (PrdDyingMachineSetupDetail d in SetDetailAll.Where(d => d.SetupID == Master.SetupID && d.SetupDetailID == item.SetupDetailID))
{
d.SQPress = item.SQPress;
d.Temp = item.Temp;
d.MachineOperationID = (int)item.MachineOperationID;
d.MachinePartID = (int)item.MachinePartID;
d.CompanyID = objcmnParam.loggedCompany;
d.CreateBy = objcmnParam.loggeduser;
d.CreateOn = DateTime.Now;
d.CreatePc = HostService.GetIP();
d.IsDeleted = false;
SetDetail.Add(d);
break;
}
}
}
if (Master.SetupID > 0)
{
if (Masteritem != null)
{
GFactory_EF_PrdDyingMachineSetup.Update(Masteritem);
GFactory_EF_PrdDyingMachineSetup.Save();
}
if (SetDetail != null && SetDetail.Count != 0)
{
GFactory_EF_PrdDyingMachineSetupDetail.UpdateList(SetDetail.ToList());
GFactory_EF_PrdDyingMachineSetupDetail.Save();
}
}
else
{
if (Masteritem != null)
{
GFactory_EF_PrdDyingMachineSetup.Insert(Masteritem);
GFactory_EF_PrdDyingMachineSetup.Save();
GFactory_EF_PrdDyingMachineSetup.updateMaxID("PrdDyingMachineSetup", Convert.ToInt64(SetMasterId));
}
if (SetDetail != null && SetDetail.Count != 0)
{
GFactory_EF_PrdDyingMachineSetupDetail.InsertList(SetDetail.ToList());
GFactory_EF_PrdDyingMachineSetupDetail.Save();
GFactory_EF_PrdDyingMachineSetupDetail.updateMaxID("PrdDyingMachineSetupDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
}
}
transaction.Complete();
result = "1";
}
catch (Exception e)
{
result = "";
e.ToString();
}
}
else
{
result = "";
throw new Exception();
}
}
return(result);
}
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;
}
}
public string SaveUpdateSizingChemicalMasterDetail(vmChemicalSetupMasterDetail Master, List <vmChemicalSetupMasterDetail> Detail, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (var transaction = new TransactionScope())
{
//*********************************************Start Initialize Variable*****************************************
long MasterId = 0, DetailId = 0, FirstDigit = 0, OtherDigits = 0;
//***************************************End Initialize Variable*************************************************
//**************************Start Initialize Generic Repository Based on table***********************************
GFactory_EF_PrdSizingChemicalSetup = new PrdSizingChemicalSetup_EF();
GFactory_EF_PrdSizingChemicalSetupDetail = new PrdSizingChemicalSetupDetail_EF();
//****************************End Initialize Generic Repository Based on table***********************************
//**********************************Start Create Related Table Instance to Save**********************************
var MasterItem = new PrdSizingChemicalSetup();
var DetailItem = new List <PrdSizingChemicalSetupDetail>();
var DetailItems = new List <PrdSizingChemicalSetupDetail>();
//************************************End Create Related Table Instance to Save**********************************
//*************************************Start Create Model Instance to get Data***********************************
vmChemicalSetupMasterDetail item = new vmChemicalSetupMasterDetail();
vmChemicalSetupMasterDetail items = new vmChemicalSetupMasterDetail();
PrdSizingChemicalSetupDetail itemdel = new PrdSizingChemicalSetupDetail();
//***************************************End Create Model Instance to get Data***********************************
var SDetail = Detail.Where(x => x.ChemicalSetupDetailID == 0).ToList();
var UDetail = Detail.Where(x => x.ChemicalSetupDetailID != 0).ToList();
//**************************************************Start Main Operation************************************************
if (Detail.Count > 0)
{
try
{
if (Master.ChemicalSetupID == 0)
{
//***************************************************Start Save Operation************************************************
//**********************************************Start Generate Master & Detail ID****************************************
MasterId = Convert.ToInt16(GFactory_EF_PrdSizingChemicalSetup.getMaxID("PrdSizingChemicalSetup"));
DetailId = Convert.ToInt64(GFactory_EF_PrdSizingChemicalSetupDetail.getMaxID("PrdSizingChemicalSetupDetail"));
FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1));
//***********************************************End Generate Master & Detail ID*****************************************
MasterItem = new PrdSizingChemicalSetup
{
ChemicalSetupID = MasterId,
DepartmentID = (int)objcmnParam.DepartmentID,
ItemID = (long)Master.ItemID,
Qty = (decimal)Master.Qty,
SetID = Master.SetID,
UnitID = (int)Master.UnitID,
UserID = objcmnParam.loggeduser,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
for (int i = 0; i < Detail.Count; i++)
{
item = Detail[i];
var Detailitem = new PrdSizingChemicalSetupDetail
{
ChemicalSetupDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits),
ChemicalSetupID = MasterId,
ChemicalID = (long)item.ChemicalID,
MaxQty = item.MaxQty,
MinQty = (decimal)item.MinQty,
UnitID = (int)item.UnitID,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
DetailItem.Add(Detailitem);
OtherDigits++;
}
//***************************************************End Save Operation************************************************
}
else
{
//***********************************Start Get Data From Related Table to Update*********************************
var MasterAll = GFactory_EF_PrdSizingChemicalSetup.GetAll().Where(x => x.ChemicalSetupID == Master.ChemicalSetupID && x.CompanyID == objcmnParam.loggedCompany);
var DetailAll = GFactory_EF_PrdSizingChemicalSetupDetail.GetAll().Where(x => x.ChemicalSetupID == Master.ChemicalSetupID && x.CompanyID == objcmnParam.loggedCompany).ToList();
//*************************************End Get Data From Related Table to Update*********************************
//***************************************************Start Update Operation********************************************
MasterItem = MasterAll.First(x => x.ChemicalSetupID == Master.ChemicalSetupID);
MasterItem.DepartmentID = (int)objcmnParam.DepartmentID;
MasterItem.ItemID = (long)Master.ItemID;
MasterItem.Qty = (decimal)Master.Qty;
MasterItem.SetID = Master.SetID;
MasterItem.UnitID = (int)Master.UnitID;
MasterItem.UserID = objcmnParam.loggeduser;
MasterItem.CompanyID = objcmnParam.loggedCompany;
MasterItem.UpdateBy = objcmnParam.loggeduser;
MasterItem.UpdateOn = DateTime.Now;
MasterItem.UpdatePc = HostService.GetIP();
MasterItem.IsDeleted = false;
for (int i = 0; i < UDetail.Count; i++)
{
item = UDetail[i];
foreach (PrdSizingChemicalSetupDetail d in DetailAll.Where(d => d.ChemicalSetupID == Master.ChemicalSetupID && d.ChemicalSetupDetailID == item.ChemicalSetupDetailID))
{
d.ChemicalID = (long)item.ChemicalID;
d.MaxQty = item.MaxQty;
d.MinQty = (decimal)item.MinQty;
d.UnitID = (int)item.UnitID;
d.CompanyID = objcmnParam.loggedCompany;
d.UpdateBy = objcmnParam.loggeduser;
d.UpdateOn = DateTime.Now;
d.UpdatePc = HostService.GetIP();
d.IsDeleted = false;
DetailItem.Add(d);
break;
}
}
if (SDetail != null && SDetail.Count != 0)
{
for (int i = 0; i < SDetail.Count; i++)
{
item = SDetail[i];
DetailId = Convert.ToInt64(GFactory_EF_PrdSizingChemicalSetupDetail.getMaxID("PrdSizingChemicalSetupDetail"));
FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1));
var Detailitems = new PrdSizingChemicalSetupDetail
{
ChemicalSetupDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits),
ChemicalSetupID = (long)Master.ChemicalSetupID,
ChemicalID = (long)item.ChemicalID,
MaxQty = item.MaxQty,
MinQty = (decimal)item.MinQty,
UnitID = (int)item.UnitID,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
DetailItems.Add(Detailitems);
GFactory_EF_PrdSizingChemicalSetupDetail.updateMaxID("PrdSizingChemicalSetupDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits)));
}
}
if (UDetail.Count < DetailAll.Count())
{
for (int i = 0; i < DetailAll.Count(); i++)
{
itemdel = DetailAll[i];
var delDetail = (from del in DetailItem.Where(x => x.ChemicalSetupDetailID == itemdel.ChemicalSetupDetailID) select del.ChemicalSetupDetailID).FirstOrDefault();
if (delDetail != itemdel.ChemicalSetupDetailID)
{
var tem = DetailAll.FirstOrDefault(d => d.ChemicalSetupID == Master.ChemicalSetupID && d.ChemicalSetupDetailID == itemdel.ChemicalSetupDetailID);
tem.CompanyID = objcmnParam.loggedCompany;
tem.DeleteBy = objcmnParam.loggeduser;
tem.DeleteOn = DateTime.Now;
tem.DeletePc = HostService.GetIP();
tem.IsDeleted = true;
DetailItem.Add(tem);
}
}
}
//***************************************************End Update Operation********************************************
}
if (Master.ChemicalSetupID > 0)
{
//***************************************************Start Update************************************************
if (MasterItem != null)
{
GFactory_EF_PrdSizingChemicalSetup.Update(MasterItem);
GFactory_EF_PrdSizingChemicalSetup.Save();
}
if (DetailItem != null && DetailItem.Count != 0)
{
GFactory_EF_PrdSizingChemicalSetupDetail.UpdateList(DetailItem.ToList());
GFactory_EF_PrdSizingChemicalSetupDetail.Save();
}
if (DetailItems != null && DetailItems.Count != 0)
{
GFactory_EF_PrdSizingChemicalSetupDetail.InsertList(DetailItems.ToList());
GFactory_EF_PrdSizingChemicalSetupDetail.Save();
}
//***************************************************End Update************************************************
}
else
{
//***************************************************Start Save************************************************
if (MasterItem != null)
{
GFactory_EF_PrdSizingChemicalSetup.Insert(MasterItem);
GFactory_EF_PrdSizingChemicalSetup.Save();
GFactory_EF_PrdSizingChemicalSetup.updateMaxID("PrdSizingChemicalSetup", Convert.ToInt64(MasterId));
}
if (DetailItem != null && DetailItem.Count != 0)
{
GFactory_EF_PrdSizingChemicalSetupDetail.InsertList(DetailItem.ToList());
GFactory_EF_PrdSizingChemicalSetupDetail.Save();
GFactory_EF_PrdSizingChemicalSetupDetail.updateMaxID("PrdSizingChemicalSetupDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
}
//******************************************************End Save************************************************
}
transaction.Complete();
result = "1";
}
catch (Exception e)
{
result = "";
e.ToString();
}
}
else
{
result = "";
}
}
return(result);
//**************************************************End Main Operation************************************************
}
public int SavCustomCode(CmnCustomCode model, List <CmnCustomCodeDetail> details)
{
GenericFactory_EF_customCode = new CmnCustomCode_EF();
GenericFactory_EF_customDetails = new CmnCustomCodeDetail_EF();
int masterID = model.RecordID;
CmnCustomCode modelBase = new CmnCustomCode();
List <Int32> UpdatedIDs = new List <Int32>();
List <CmnCustomCodeDetail> detailsListDeleted = new List <CmnCustomCodeDetail>();
List <CmnCustomCodeDetail> detailsList = new List <CmnCustomCodeDetail>();
List <CmnCustomCodeDetail> detailsInsertionList = new List <CmnCustomCodeDetail>();
int result = 0;
try
{
modelBase = ModelBinding(model, details);
foreach (var item in modelBase.CmnCustomCodeDetails)
{
if (item.EntryStateStatus == "Modified")
{
CmnCustomCodeDetail detailsEntity = new CmnCustomCodeDetail();
detailsEntity = DetailsBinding(modelBase.CmnCustomCodeDetails.Where(x => x.RecordDetailID == item.RecordDetailID).FirstOrDefault());
detailsList.Add(detailsEntity);
UpdatedIDs.Add(detailsEntity.RecordDetailID);
}
if (item.EntryStateStatus == "Add" && masterID > 0)
{
CmnCustomCodeDetail detailsEntity = new CmnCustomCodeDetail();
detailsEntity = DetailsBinding(modelBase.CmnCustomCodeDetails.Where(x => x.RecordDetailID == item.RecordDetailID).FirstOrDefault());
detailsInsertionList.Add(detailsEntity);
}
}
foreach (var item in UpdatedIDs)
{
modelBase.CmnCustomCodeDetails.Remove(modelBase.CmnCustomCodeDetails.Where(x => x.RecordDetailID == item).FirstOrDefault());
}
if (masterID == 0)
{
GenericFactory_EF_customCode.Insert(modelBase);
GenericFactory_EF_customCode.Save();
}
else
{
GenericFactory_EF_customCode.Update(model);
GenericFactory_EF_customDetails.UpdateList(detailsList);
foreach (CmnCustomCodeDetail item in detailsList)
{
if (item.IsDeleted)
{
detailsListDeleted.Add(item);
}
}
if (detailsListDeleted.Count > 0)
{
GenericFactory_EF_customDetails.DeleteList(detailsListDeleted);
}
GenericFactory_EF_customDetails.InsertList(detailsInsertionList);
GenericFactory_EF_customCode.Save();
GenericFactory_EF_customDetails.Save();
GenericFactory_EF_customDetails = new CmnCustomCodeDetail_EF();
}
result = 1;
}
catch (Exception ex)
{
ex.ToString();
return(result);
}
return(result);
}
public async Task <string> SaveUpdateSetSetupMasterDetail(vmSetSetupMasterDetail ModelMaster, List <vmSetSetupMasterDetail> ModelDetail, vmCmnParameters objcmnParam)
{
string result = string.Empty;
long TransactionID = 0;
using (var transaction = new TransactionScope())
{
GFactory_EF_PrdSetMaster = new PrdSetMaster_EF();
GFactory_EF_PrdSetSetup = new PrdSetSetup_EF();
string SetNo = string.Empty; int SetMasterId = 0, SetDetailId = 0;
long SetFirstDigit = 0, SetOtherDigits = 0;
var Masteritem = new PrdSetMaster();
var SetDetail = new List <PrdSetSetup>();
vmSetSetupMasterDetail item = new vmSetSetupMasterDetail();
vmSetSetupMasterDetail items = new vmSetSetupMasterDetail();
//-------------------END----------------------
if (ModelDetail.Count() > 0)
{
try
{
using (_ctxCmn = new ERP_Entities())
{
if (ModelMaster.SetMasterID == 0)
{
SetMasterId = Convert.ToInt16(GFactory_EF_PrdSetMaster.getMaxID("PrdSetMaster"));
SetDetailId = Convert.ToInt16(GFactory_EF_PrdSetSetup.getMaxID("PrdSetSetup"));
SetFirstDigit = Convert.ToInt64(SetDetailId.ToString().Substring(0, 1));
SetOtherDigits = Convert.ToInt64(SetDetailId.ToString().Substring(1, SetDetailId.ToString().Length - 1));
//CustomNo = GFactory_EF_PrdSetSetup.getCustomCode(MenuId, DateTime.Now, CompanyId, 1, 1);
//if (CustomNo == null || CustomNo == "")
//{
// SetNo = SetDetailId.ToString();
//}
//else
//{
// SetNo = CustomNo;
//}
TransactionID = SetMasterId;
Masteritem = new PrdSetMaster
{
SetMasterID = SetMasterId,
BuyerID = ModelMaster.BuyerID,
Description = ModelMaster.Description,
ItemID = (long)ModelMaster.ItemID,
PIID = ModelMaster.PIID,
PIItemlength = ModelMaster.PIItemlength,
RefSetDate = ModelMaster.RefSetDate,
RefSetID = ModelMaster.RefSetID,
SetDate = ModelMaster.SetDate,
SupplierID = ModelMaster.SupplierID,
StatusID = ModelMaster.StatusID,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
for (int i = 0; i < ModelDetail.Count(); i++)
{
item = ModelDetail[i];
var Detailitem = new PrdSetSetup
{
SetID = Convert.ToInt64(SetFirstDigit + "" + SetOtherDigits),
YarnID = (long)item.YarnID,
WarpYarnID = item.YarnID,
WeftYarnID = item.WeftYarnID,
Weave = item.Weave,
BuyerID = item.BuyerID,
ColorID = item.ColorID,
Description = item.Description,
EndsPerCreel = item.EndsPerCreel,
LeaseReapet = item.LeaseRepeat,
MachineSpeed = item.MachineSpeed,
SetDate = item.SetDate,
ItemID = (long)item.ItemID,
PIID = item.PIID,
SetLength = (long)item.SetLength,
SetMasterID = SetMasterId,
SetNo = item.SetNo,
SupplierID = item.SupplierID,
TotalEnds = item.TotalEnds,
YarnCount = item.YarnCount,
YarnRatio = item.YarnRatio,
YarnRatioLot = item.YarnRatioLot,
NoOfBall = item.NoOfBall,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
//***************************************END*******************************************
SetDetail.Add(Detailitem);
SetOtherDigits++;
}
}
else
{
var SetMasterAll = GFactory_EF_PrdSetMaster.GetAll().Where(x => x.SetMasterID == ModelMaster.SetMasterID);
var SetDetailAll = GFactory_EF_PrdSetSetup.GetAll().Where(x => x.SetMasterID == ModelMaster.SetMasterID);
Masteritem = SetMasterAll.FirstOrDefault(x => x.SetMasterID == ModelMaster.SetMasterID);
Masteritem.BuyerID = ModelMaster.BuyerID;
Masteritem.Description = ModelMaster.Description;
Masteritem.ItemID = (long)ModelMaster.ItemID;
Masteritem.PIID = ModelMaster.PIID;
Masteritem.PIItemlength = ModelMaster.PIItemlength;
Masteritem.RefSetDate = ModelMaster.RefSetDate;
Masteritem.RefSetID = ModelMaster.RefSetID;
Masteritem.SetDate = ModelMaster.SetDate;
Masteritem.SupplierID = ModelMaster.SupplierID;
Masteritem.StatusID = ModelMaster.StatusID;
Masteritem.CompanyID = objcmnParam.loggedCompany;
Masteritem.UpdateBy = objcmnParam.loggeduser;
Masteritem.UpdateOn = DateTime.Now;
Masteritem.UpdatePc = HostService.GetIP();
Masteritem.IsDeleted = false;
for (int i = 0; i < ModelDetail.Count(); i++)
{
item = ModelDetail[i];
foreach (PrdSetSetup d in SetDetailAll.Where(d => d.SetMasterID == ModelMaster.SetMasterID && d.SetID == item.SetID))
{
d.YarnID = (long)item.YarnID;
d.WarpYarnID = item.YarnID;
d.WeftYarnID = item.WeftYarnID;
d.Weave = item.Weave;
d.BuyerID = item.BuyerID;
d.ColorID = item.ColorID;
d.Description = item.Description;
d.EndsPerCreel = item.EndsPerCreel;
d.LeaseReapet = item.LeaseRepeat;
d.MachineSpeed = item.MachineSpeed;
d.SetDate = item.SetDate;
d.ItemID = (long)item.ItemID;
d.PIID = item.PIID;
d.SetLength = (long)item.SetLength;
d.SetNo = item.SetNo;
d.SupplierID = item.SupplierID;
d.TotalEnds = item.TotalEnds;
d.YarnCount = item.YarnCount;
d.YarnRatio = item.YarnRatio;
d.YarnRatioLot = item.YarnRatioLot;
d.NoOfBall = item.NoOfBall;
d.CompanyID = objcmnParam.loggedCompany;
d.UpdateBy = objcmnParam.loggeduser;
d.UpdateOn = DateTime.Now;
d.UpdatePc = HostService.GetIP();
d.IsDeleted = false;
SetDetail.Add(d);
break;
}
}
}
if (ModelMaster.SetMasterID > 0)
{
if (Masteritem != null)
{
GFactory_EF_PrdSetMaster.Update(Masteritem);
GFactory_EF_PrdSetMaster.Save();
}
if (SetDetail != null && SetDetail.Count != 0)
{
GFactory_EF_PrdSetSetup.UpdateList(SetDetail.ToList());
GFactory_EF_PrdSetSetup.Save();
}
}
else
{
if (Masteritem != null)
{
GFactory_EF_PrdSetMaster.Insert(Masteritem);
GFactory_EF_PrdSetMaster.Save();
GFactory_EF_PrdSetMaster.updateMaxID("PrdSetMaster", Convert.ToInt64(SetMasterId));
}
if (SetDetail != null && SetDetail.Count != 0)
{
GFactory_EF_PrdSetSetup.InsertList(SetDetail.ToList());
GFactory_EF_PrdSetSetup.Save();
GFactory_EF_PrdSetSetup.updateMaxID("PrdSetSetup", Convert.ToInt64(SetFirstDigit + "" + (SetOtherDigits - 1)));
}
}
transaction.Complete();
result = "1";
}
}
catch (Exception e)
{
result = "";
e.ToString();
}
}
else
{
result = "";
throw new Exception();
}
}
// Approval Code
#region WorkFlow Transaction Entry and email sending
if (ModelMaster.SetMasterID == 0)
{
UserCommonEntity commonEntity = new UserCommonEntity();
commonEntity.currentMenuID = objcmnParam.menuId;
commonEntity.loggedCompnyID = objcmnParam.loggedCompany;
commonEntity.loggedUserID = objcmnParam.loggeduser;
int workflowID = 0;
List <vmCmnWorkFlowMaster> listWorkFlow = new WorkFLowMgt().GetWorkFlowMasterListByMenu(commonEntity);
foreach (vmCmnWorkFlowMaster itemWFM in listWorkFlow)
{
int userTeamID = itemWFM.UserTeamID ?? 0;
if (new WorkFLowMgt().checkUserValidation(commonEntity.loggedUserID ?? 0, itemWFM.WorkFlowID) && userTeamID > 0)
{
itemWFM.WorkFlowTranCustomID = (Int16)TransactionID;
workflowID = new WorkFLowMgt().ExecuteTransactionProcess(itemWFM, commonEntity);
}
if (userTeamID == 0)
{
itemWFM.WorkFlowTranCustomID = (Int16)TransactionID;
workflowID = new WorkFLowMgt().ExecuteTransactionProcess(itemWFM, commonEntity);
}
}
int mail = 0;
foreach (vmCmnWorkFlowMaster itemWFM in listWorkFlow)
{
NotificationEntity notification = new NotificationEntity();
notification.WorkFlowID = itemWFM.WorkFlowID;
notification.TransactionID = (Int16)TransactionID;
List <vmNotificationMail> nModel = new WorkFLowMgt().GetNotificationMailObjectList(notification, "Created");
foreach (var mailModel in nModel)
{
mail = await new EmailService().NotificationMail(mailModel);
}
}
}
#endregion WorkFlow Transaction Entry and email sending
return(result);
}
public string SaveUpdateOutputUnit(PrdOutputUnit OutputUnitInfo, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (TransactionScope transaction = new TransactionScope())
{
GenericFactory_EF_OutputUnit = new PrdOutputUnit_EF();
long MainId = 0; string CustomNo = string.Empty, OutputNos = string.Empty;
var UOutputUnit = new PrdOutputUnit();
try
{
if (OutputUnitInfo.OutputID > 0)
{
UOutputUnit = GenericFactory_EF_OutputUnit.GetAll().Where(x => x.OutputID == OutputUnitInfo.OutputID).FirstOrDefault();
UOutputUnit.OutputNo = OutputUnitInfo.OutputNo;
UOutputUnit.OutputName = OutputUnitInfo.OutputName;
UOutputUnit.ProcessID = OutputUnitInfo.ProcessID;
UOutputUnit.Description = OutputUnitInfo.Description;
UOutputUnit.CompanyID = objcmnParam.loggedCompany;
UOutputUnit.UpdateBy = objcmnParam.loggeduser;
UOutputUnit.UpdateOn = DateTime.Now;
UOutputUnit.UpdatePc = HostService.GetIP();
//OutputNos = UOutputUnit.OutputNo;
}
else
{
MainId = Convert.ToInt16(GenericFactory_EF_OutputUnit.getMaxID("PrdOutputUnit"));
//CustomNo = GenericFactory_EF_OutputUnit.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
//if (CustomNo == null || CustomNo == "")
//{
// OutputNos = MainId.ToString();
//}
//else
//{
// OutputNos = CustomNo;
//}
UOutputUnit = new PrdOutputUnit()
{
OutputID = (int)MainId,
OutputNo = OutputUnitInfo.OutputNo,//OutputNos.ToString(),
OutputName = OutputUnitInfo.OutputName,
ProcessID = OutputUnitInfo.ProcessID,
Description = OutputUnitInfo.Description,
IsDeleted = false,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP()
};
}
if (OutputUnitInfo.OutputID > 0)
{
GenericFactory_EF_OutputUnit.Update(UOutputUnit);
GenericFactory_EF_OutputUnit.Save();
}
else
{
GenericFactory_EF_OutputUnit.Insert(UOutputUnit);
GenericFactory_EF_OutputUnit.Save();
GenericFactory_EF_OutputUnit.updateMaxID("PrdOutputUnit", Convert.ToInt64(MainId));
GenericFactory_EF_OutputUnit.updateCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
}
transaction.Complete();
result = OutputUnitInfo.OutputNo;
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
return(result);
}
private int SaveSizeBeamIssueMasterDetails(List <vmSizeBeamIssue> _objSizeIssueDetails, Int64 BeamIssueID, vmSizeBeamIssue _objSizeIssueMaster)
{
int status = 0;
GenericFactory_EFSizingBeamIssueDetail = new PrdSizingBeamIssueDetail_EF();
try
{
Int64 NextId = 0;
foreach (vmSizeBeamIssue aitem in _objSizeIssueDetails)
{
NextId = GenericFactory_EFSizingBeamIssueDetail.getMaxVal_int64("BeamIssueDetailID", "PrdSizingBeamIssueDetail");
PrdSizingBeamIssueDetail _prdSizingBeamIssueDetail = new PrdSizingBeamIssueDetail();
_prdSizingBeamIssueDetail.BeamIssueDetailID = NextId;
_prdSizingBeamIssueDetail.BeamIssueID = BeamIssueID;
_prdSizingBeamIssueDetail.BeamID = aitem.OutputID;// OutputID is the beamID
_prdSizingBeamIssueDetail.Length = aitem.LengthYds;
if (aitem.BSDate != null)
{
_prdSizingBeamIssueDetail.BSDate = Convert.ToDateTime(aitem.BSDate).AddDays(1);
}
else
{
_prdSizingBeamIssueDetail.BSDate = null;
}
if (aitem.BMDate != null)
{
_prdSizingBeamIssueDetail.BMDate = Convert.ToDateTime(aitem.BMDate).AddDays(1);
}
else
{
_prdSizingBeamIssueDetail.BMDate = null;
}
_prdSizingBeamIssueDetail.LoomID = aitem.LoomID;
_prdSizingBeamIssueDetail.Totalfabric = aitem.Totalfabric ?? 0;
if (aitem.BFDate != null)
{
_prdSizingBeamIssueDetail.BFDate = Convert.ToDateTime(aitem.BFDate).AddDays(1);
}
else
{
_prdSizingBeamIssueDetail.BFDate = null;
}
_prdSizingBeamIssueDetail.CompanyID = _objSizeIssueMaster.CompanyID;
_prdSizingBeamIssueDetail.CreateBy = _objSizeIssueMaster.CreateBy;
_prdSizingBeamIssueDetail.IsDeleted = _objSizeIssueMaster.IsDeleted;
GenericFactory_EFSizingBeamIssueDetail.Insert(_prdSizingBeamIssueDetail);
GenericFactory_EFSizingBeamIssueDetail.Save();
}
status = 1;
}
catch
{
}
return(status);
}
public string SaveUpdateCSMasterNdetails(PurchaseCSMaster CSMaster, List <PurchaseCSDetail> CSDetails, int menuID)
{
_ctxCmn = new ERP_Entities();
GenericFactory_EF_CmnCombo = new CmnCombo_EF();
string result = "";
if (CSMaster.CSID > 0)
{
//using (TransactionScope transaction = new TransactionScope())
//{
// try
// {
// Int64 poID = chMaster.POID;
// IEnumerable<PurchasePOMaster> lstPurchasePOMaster = (from qcm in _ctxCmn.PurchasePOMasters.Where(m => m.POID == poID && m.CompanyID == chMaster.CompanyID) select qcm).ToList();
// PurchasePOMaster objPurchasePOMaster = new PurchasePOMaster();
// foreach (PurchasePOMaster qcms in lstPurchasePOMaster)
// {
// qcms.UpdateBy = chMaster.CreateBy;
// qcms.UpdateOn = DateTime.Now;
// qcms.UpdatePc = HostService.GetIP();
// qcms.POID = chMaster.POID;
// qcms.CurrencyID = chMaster.CurrencyID;
// qcms.Amount = chMaster.Amount;
// qcms.PODate = chMaster.PODate;
// qcms.BankAccountNo = chMaster.BankAccountNo;
// qcms.DepartmentID = chMaster.DepartmentID;
// qcms.TransactionTypeID = chMaster.TransactionTypeID;
// qcms.BankBranchID = chMaster.BankBranchID;
// qcms.IsDeleted = false;
// qcms.BankID = chMaster.BankID;
// qcms.PartyID = chMaster.PartyID;
// //qcms.PIID = chMaster.PIID;
// qcms.CompanyID = chMaster.CompanyID;
// qcms.ExpireDate = chMaster.ExpireDate;
// //qcms.FRID= chMaster.FRID;
// qcms.LCorVoucherorLcafDate = chMaster.LCorVoucherorLcafDate;
// qcms.LCorVoucherorLcafNo = chMaster.LCorVoucherorLcafNo;
// qcms.MoneyTransactionTypeID = chMaster.MoneyTransactionTypeID;
// qcms.OrderTypeID = chMaster.OrderTypeID;
// qcms.RequisitionID = qcms.RequisitionID;
// qcms.ShipmentDate = qcms.ShipmentDate;
// objPurchasePOMaster = qcms;
// }
// List<PurchasePODetail> lstPurchasePODetail = new List<PurchasePODetail>();
// foreach (PurchasePODetail qcdt in chDetails)
// {
// PurchasePODetail objPurchasePODetail = (from qcdetl in _ctxCmn.PurchasePODetails.Where(m => m.PODetailID == qcdt.PODetailID) select qcdetl).FirstOrDefault();
// objPurchasePODetail.Amount = qcdt.Amount;
// objPurchasePODetail.FOBValue = qcdt.FOBValue;
// objPurchasePODetail.FreightCharge = qcdt.FreightCharge;
// objPurchasePODetail.HSCode = qcdt.HSCode;
// objPurchasePODetail.ItemID = qcdt.ItemID;
// objPurchasePODetail.NetWeight = qcdt.NetWeight;
// objPurchasePODetail.IsDeleted = false;
// objPurchasePODetail.GrossWeight = qcdt.GrossWeight;
// objPurchasePODetail.OriginCountryID = qcdt.OriginCountryID;
// objPurchasePODetail.NetWeight = qcdt.NetWeight;
// objPurchasePODetail.PackingQty = qcdt.PackingQty;
// objPurchasePODetail.PackingUnitID = qcdt.PackingUnitID;
// objPurchasePODetail.Qty = qcdt.Qty;
// objPurchasePODetail.UnitID = qcdt.UnitID;
// objPurchasePODetail.UnitPrice = qcdt.UnitPrice;
// objPurchasePODetail.WeightUnitID = qcdt.WeightUnitID;
// objPurchasePODetail.UpdateBy = chMaster.CreateBy;
// objPurchasePODetail.UpdateOn = DateTime.Now;
// objPurchasePODetail.UpdatePc = HostService.GetIP();
// lstPurchasePODetail.Add(objPurchasePODetail);
// }
// _ctxCmn.SaveChanges();
// //**********----------------------Start File Upload----------------------**********
// GenericFactory_CmnDocument = new CmnDocument_EF();
// int DocumentID = Convert.ToInt16(GenericFactory_CmnDocument.getMaxID("CmnDocument"));
// List<CmnDocument> lstCmnDocument = new List<CmnDocument>();
// for (int i = 1; i <= fileNames.Count; i++)
// {
// CmnDocument objCmnDocument = new CmnDocument();
// objCmnDocument.DocumentID = DocumentID;
// objCmnDocument.DocumentPahtID = 2;
// //objCmnDocument.DocumentName = fileNames[i].ToString();
// string extension = System.IO.Path.GetExtension(fileNames[i - 1].ToString());
// objCmnDocument.DocumentName = chMaster.PONo + "_Doc_" + i + extension;
// objCmnDocument.TransactionID = chMaster.POID;
// objCmnDocument.TransactionTypeID = 22;
// objCmnDocument.CompanyID = chMaster.CompanyID;
// objCmnDocument.CreateBy = Convert.ToInt16(chMaster.CreateBy);
// objCmnDocument.CreateOn = DateTime.Now;
// objCmnDocument.CreatePc = HostService.GetIP();
// objCmnDocument.IsDeleted = false;
// objCmnDocument.IsDeleted = false;
// lstCmnDocument.Add(objCmnDocument);
// DocumentID++;
// }
// GenericFactory_CmnDocument.InsertList(lstCmnDocument);
// GenericFactory_CmnDocument.Save();
// GenericFactory_CmnDocument.updateMaxID("CmnDocument", Convert.ToInt64(DocumentID - 1));
// //**********----------------------File upload completed----------------------**********
// transaction.Complete();
// result = chMaster.PONo.ToString();
// }
// catch (Exception e)
// {
// e.ToString();
// result = "";
// }
//}
}
else
{
using (TransactionScope transaction = new TransactionScope())
{
try
{
//...........START new maxId...............//
long NextId = Convert.ToInt16(GenericFactory_EF_CmnCombo.getMaxID("PurchaseCSMaster"));
long FirstDigit = 0;
long OtherDigits = 0;
long nextChDetailId = Convert.ToInt16(GenericFactory_EF_CmnCombo.getMaxID("PurchaseCSDetail"));
FirstDigit = Convert.ToInt64(nextChDetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(nextChDetailId.ToString().Substring(1, nextChDetailId.ToString().Length - 1));
//..........END new maxId....................//
//......... START for custom code........... //
string customCode = "";
string CustomNo = GenericFactory_EF_CmnCombo.getCustomCode(menuID, Convert.ToDateTime(CSMaster.CSDate), CSMaster.CompanyID ?? 1, 1, 1);
if (CustomNo != null)
{
customCode = CustomNo;
}
else
{
customCode = NextId.ToString();
}
//.........END for custom code............ //
string newChNo = customCode;
CSMaster.CSID = NextId;
CSMaster.CreateOn = DateTime.Now;
CSMaster.CreatePc = HostService.GetIP();
CSMaster.CSNo = customCode;
CSMaster.IsDeleted = false;
List <PurchaseCSDetail> lstCSDetail = new List <PurchaseCSDetail>();
foreach (PurchaseCSDetail sdtl in CSDetails)
{
PurchaseCSDetail objchDetail = new PurchaseCSDetail();
objchDetail.CSDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits);//nextQCDetailId;
objchDetail.CSID = NextId;
objchDetail.FOBValue = sdtl.FOBValue;
objchDetail.FreightCharge = sdtl.FreightCharge;
objchDetail.PartyID = sdtl.PartyID;
objchDetail.CurrencyID = sdtl.CurrencyID;
objchDetail.ItemID = sdtl.ItemID;
objchDetail.UnitID = sdtl.UnitID;
objchDetail.Qty = sdtl.Qty;
objchDetail.UnitPrice = sdtl.UnitPrice;
objchDetail.Amount = sdtl.Amount;
objchDetail.IsDeleted = false;
objchDetail.CreateBy = CSMaster.CreateBy;
objchDetail.CreateOn = DateTime.Now;
objchDetail.CreatePc = HostService.GetIP();
lstCSDetail.Add(objchDetail);
OtherDigits++;
}
_ctxCmn.PurchaseCSMasters.Add(CSMaster);
//............Update MaxID.................//
GenericFactory_EF_CmnCombo.updateMaxID("PurchaseCSMaster", Convert.ToInt64(NextId));
//............Update CustomCode.............//
GenericFactory_EF_CmnCombo.updateCustomCode(menuID, Convert.ToDateTime(CSMaster.CSDate), CSMaster.CompanyID ?? 1, 1, 1);
_ctxCmn.PurchaseCSDetails.AddRange(lstCSDetail);
//............Update MaxID.................//
GenericFactory_EF_CmnCombo.updateMaxID("PurchaseCSDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
_ctxCmn.SaveChanges();
transaction.Complete();
result = customCode;
}
catch (Exception e)
{
result = "";
}
}
}
return(result);
}
public string SaveUpdatePackingListMasterDetail(vmFinishingPackingListMasterDetail Master, List <vmFinishingPackingListMasterDetail> Detail, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (var transaction = new TransactionScope())
{
//*********************************************Start Initialize Variable*****************************************
long MasterId = 0, DetailId = 0, FirstDigit = 0, OtherDigits = 0; string CustomNo = string.Empty, PackingNo = string.Empty;
//***************************************End Initialize Variable*************************************************
//**************************Start Initialize Generic Repository Based on table***********************************
GenericFactory_PrdFinishingPackingList_EF = new PrdFinishingPackingList_EF();
GenericFactory_PrdFinishingPackingListDetail_EF = new PrdFinishingPackingListDetail_EF();
//****************************End Initialize Generic Repository Based on table***********************************
//**********************************Start Create Related Table Instance to Save**********************************
var MasterItem = new PrdFinishingPackingList();
var DetailItem = new List <PrdFinishingPackingListDetail>();
//************************************End Create Related Table Instance to Save**********************************
//*************************************Start Create Model Instance to get Data***********************************
vmFinishingPackingListMasterDetail item = new vmFinishingPackingListMasterDetail();
//***************************************End Create Model Instance to get Data***********************************
//**************************************************Start Main Operation************************************************
if (Detail.Count > 0)
{
try
{
if (Master.PackingID == 0)
{
//***************************************************Start Save Operation************************************************
//**********************************************Start Generate Master & Detail ID****************************************
MasterId = Convert.ToInt16(GenericFactory_PrdFinishingPackingList_EF.getMaxID("PrdFinishingPackingList"));
DetailId = Convert.ToInt64(GenericFactory_PrdFinishingPackingListDetail_EF.getMaxID("PrdFinishingPackingListDetail"));
FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1));
//***********************************************End Generate Master & Detail ID*****************************************
CustomNo = GenericFactory_PrdFinishingPackingList_EF.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
if (CustomNo == null || CustomNo == "")
{
PackingNo = MasterId.ToString();
}
else
{
PackingNo = CustomNo;
}
MasterItem = new PrdFinishingPackingList
{
PackingID = MasterId,
PackingNo = PackingNo,
PackingDate = (DateTime)Master.PackingDate,
IsDCComplete = false,
IsFDOComplete = false,
PIID = (long)Master.PIID,
FinishingMRRID = (long)Master.FinishingMRRID,
ItemID = (long)Master.ItemID,
Remarks = Master.Remarks,
IsDeleted = false,
PackingTypeID = objcmnParam.tTypeId,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP()
};
for (int i = 0; i < Detail.Count; i++)
{
item = Detail[i];
var Detailitem = new PrdFinishingPackingListDetail
{
PackingDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits),
PackingID = MasterId,
QADetailID = (long)item.QADetailID,
Shade = item.Shade,
Length = item.Length,
GWeight = item.GWeight,
NWeight = item.NWeight,
Shipment = item.Shipment,
FiniWidth = item.FiniWidth,
WPercent = item.WidthSr,
DefectPointID = item.DefectPointID,
IsNotDeliverable = false,
Remarks = item.Remarks,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
DetailItem.Add(Detailitem);
OtherDigits++;
}
//***************************************************End Save Operation************************************************
}
else
{
//***********************************Start Get Data From Related Table to Update*********************************
var MasterAll = GenericFactory_PrdFinishingPackingList_EF.GetAll().Where(x => x.PackingID == Master.PackingID && x.CompanyID == objcmnParam.loggedCompany);
var DetailAll = GenericFactory_PrdFinishingPackingListDetail_EF.GetAll().Where(x => x.PackingID == Master.PackingID && x.CompanyID == objcmnParam.loggedCompany).ToList();
//*************************************End Get Data From Related Table to Update*********************************
//***************************************************Start Update Operation********************************************
MasterItem = MasterAll.First(x => x.PackingID == Master.PackingID);
MasterItem.PackingDate = (DateTime)Master.PackingDate;
MasterItem.ItemID = (long)Master.ItemID;
MasterItem.PIID = (long)Master.PIID;
MasterItem.FinishingMRRID = (long)Master.FinishingMRRID;
MasterItem.Remarks = Master.Remarks;
MasterItem.PackingTypeID = objcmnParam.tTypeId;
MasterItem.CompanyID = objcmnParam.loggedCompany;
MasterItem.UpdateBy = objcmnParam.loggeduser;
MasterItem.UpdateOn = DateTime.Now;
MasterItem.UpdatePc = HostService.GetIP();
MasterItem.IsDeleted = false;
for (int i = 0; i < Detail.Count; i++)
{
item = Detail[i];
foreach (PrdFinishingPackingListDetail d in DetailAll.Where(d => d.PackingID == Master.PackingID && d.PackingDetailID == item.PackingDetailID))
{
d.QADetailID = (long)item.QADetailID;
d.Shade = item.Shade;
d.Length = item.Length;
d.GWeight = item.GWeight;
d.NWeight = item.NWeight;
d.Shipment = item.Shipment;
d.FiniWidth = item.FiniWidth;
d.WPercent = item.WidthSr;
d.DefectPointID = item.DefectPointID;
d.Remarks = item.Remarks;
d.CompanyID = objcmnParam.loggedCompany;
d.UpdateBy = objcmnParam.loggeduser;
d.UpdateOn = DateTime.Now;
d.UpdatePc = HostService.GetIP();
DetailItem.Add(d);
break;
}
}
//***************************************************End Update Operation********************************************
}
if (Master.PackingID > 0)
{
//***************************************************Start Update************************************************
if (MasterItem != null)
{
GenericFactory_PrdFinishingPackingList_EF.Update(MasterItem);
GenericFactory_PrdFinishingPackingList_EF.Save();
}
if (DetailItem != null && DetailItem.Count != 0)
{
GenericFactory_PrdFinishingPackingListDetail_EF.UpdateList(DetailItem.ToList());
GenericFactory_PrdFinishingPackingListDetail_EF.Save();
}
//***************************************************End Update************************************************
}
else
{
//***************************************************Start Save************************************************
if (MasterItem != null)
{
GenericFactory_PrdFinishingPackingList_EF.Insert(MasterItem);
GenericFactory_PrdFinishingPackingList_EF.Save();
GenericFactory_PrdFinishingPackingList_EF.updateMaxID("PrdFinishingPackingList", Convert.ToInt64(MasterId));
}
if (DetailItem != null && DetailItem.Count != 0)
{
GenericFactory_PrdFinishingPackingListDetail_EF.InsertList(DetailItem.ToList());
GenericFactory_PrdFinishingPackingListDetail_EF.Save();
GenericFactory_PrdFinishingPackingListDetail_EF.updateMaxID("PrdFinishingPackingListDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
}
//******************************************************End Save************************************************
}
transaction.Complete();
result = MasterItem.PackingNo;
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
else
{
result = "";
}
}
return(result);
//**************************************************End Main Operation************************************************
}
//public IEnumerable<vmWeavingMachineSetup> GetMachineSetupInfo(vmCmnParameters cmnParam)
//{
// GenericFactory_WeavingMachineSetup_GF = new vmPrdWeavingMachineSetup_GF();
// IEnumerable<vmWeavingMachineSetup> objWeavingMachineSetup = null;
// using (ERP_Entities _ctxCmn = new ERP_Entities())
// {
// try
// {
// var CmnItemMaster = _ctxCmn.CmnItemMasters.ToList();
// var PrdWeavingMachineSetup = _ctxCmn.PrdWeavingMachineSetups.ToList();
// objWeavingMachineSetup = (from master in PrdWeavingMachineSetup
// join color in CmnItemMaster on master.ItemID equals color.ItemID// into leftColorGroup
// // from lcg in leftColorGroup.DefaultIfEmpty()
// where (master.MachineSetupID == cmnParam.id && master.IsDeleted == false)
// select new vmWeavingMachineSetup
// {
// MachineSetupID = master.MachineSetupID,
// ItemID = master.ItemID,
// Selvedge = master.Selvedge,
// Brackrest = master.Brackrest,
// ShadeAngle = master.ShadeAngle,
// SFHight = master.SFHight,
// CompanyID = master.CompanyID,
// ArticleNo = color.ArticleNo
// }).ToList();
// }
// catch (Exception e)
// {
// e.ToString();
// }
// }
// return objWeavingMachineSetup;
//}
public string SaveUpdateCodewiseMachineSetup(PrdWeavingMachineSetup CodewiseMachineSetupInfo, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (TransactionScope transaction = new TransactionScope())
{
GenericFactory_EF_PrdWeavingMachineSetup = new PrdWeavingMachineSetup_EF();
long MainId = 0; string CustomNo = string.Empty, DefectNo = string.Empty;
var CodeMachineSetup = new PrdWeavingMachineSetup();
try
{
if (CodewiseMachineSetupInfo.MachineSetupID > 0)
{
CodeMachineSetup = GenericFactory_EF_PrdWeavingMachineSetup.GetAll().Where(x => x.MachineSetupID == CodewiseMachineSetupInfo.MachineSetupID).FirstOrDefault();
CodeMachineSetup.ItemID = CodewiseMachineSetupInfo.ItemID;
CodeMachineSetup.Selvedge = CodewiseMachineSetupInfo.Selvedge;
CodeMachineSetup.SFHight = CodewiseMachineSetupInfo.SFHight;
CodeMachineSetup.ShadeAngle = CodewiseMachineSetupInfo.ShadeAngle;
CodeMachineSetup.Brackrest = CodewiseMachineSetupInfo.Brackrest;
CodeMachineSetup.CompanyID = objcmnParam.loggedCompany;
CodeMachineSetup.UpdateBy = objcmnParam.loggeduser;
CodeMachineSetup.UpdateOn = DateTime.Now;
CodeMachineSetup.UpdatePc = HostService.GetIP();
}
else
{
MainId = Convert.ToInt16(GenericFactory_EF_PrdWeavingMachineSetup.getMaxID("PrdWeavingMachineSetup"));
CodeMachineSetup = new PrdWeavingMachineSetup()
{
MachineSetupID = (int)MainId,
ItemID = CodewiseMachineSetupInfo.ItemID,
Selvedge = CodewiseMachineSetupInfo.Selvedge,
SFHight = CodewiseMachineSetupInfo.SFHight,
ShadeAngle = CodewiseMachineSetupInfo.ShadeAngle,
Brackrest = CodewiseMachineSetupInfo.Brackrest,
IsDeleted = false,
IsActive = true,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP()
};
}
if (CodewiseMachineSetupInfo.MachineSetupID > 0)
{
GenericFactory_EF_PrdWeavingMachineSetup.Update(CodeMachineSetup);
GenericFactory_EF_PrdWeavingMachineSetup.Save();
}
else
{
GenericFactory_EF_PrdWeavingMachineSetup.Insert(CodeMachineSetup);
GenericFactory_EF_PrdWeavingMachineSetup.Save();
GenericFactory_EF_PrdWeavingMachineSetup.updateMaxID("PrdWeavingMachineSetup", Convert.ToInt64(MainId));
}
transaction.Complete();
result = CodeMachineSetup.Selvedge.ToString();
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
return(result);
}
public string SaveUpdateFactorySalesDeliveryOrderMasterDetail(vmSalFDODetail Master, List <vmSalFDODetail> Detail, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (var transaction = new TransactionScope())
{
GenericFactoryFor_HDOMaster_EF = new SalHDOMaster_EF();
GenericFactoryFor_HDODetails_EF = new SalHDODetail_EF();
GenericFactoryFor_FDOMaster = new SalFDOMaster_EF();
GenericFactoryFor_FDODetails = new SalFDODetail_EF();
GFactory_EF_InvStockTransit = new InvStocTransit_Sale_EF();
GFactory_EF_InvStockMaster = new InvStockMaster_Sale_EF();
string CustomNo = string.Empty, FDONo = ""; decimal CurrentStock = 0, TransitQty = 0;
long FdoMasterId = 0, FdoDetailId = 0, FirstDigit = 0, OtherDigits = 0, NextId = 0;
var Masteritem = new SalFDOMaster();
var FDODetail = new List <SalFDODetail>();
var UpdateHDODetail = new List <SalHDODetail>();
var InsertStockTransit = new List <InvStockTransit>();
var item = new vmSalFDODetail();
var items = new vmSalFDODetail();
//To Update Remaining Quantity in SalHDODetail
var HdoDetail = GenericFactoryFor_HDODetails_EF.GetAll();
var StockMaster = GFactory_EF_InvStockMaster.GetAll().Where(x => x.DepartmentID == objcmnParam.SelectedDepartmentID).ToList();
var StockTransit = GFactory_EF_InvStockTransit.GetAll().Where(x => x.DepartmentID == objcmnParam.SelectedDepartmentID).ToList();
//-------------------END----------------------
if (Detail.Count() > 0)
{
try
{
NextId = GFactory_EF_InvStockTransit.getMaxVal_int64("StockTransitID", "InvStockTransit");
//start new maxId
FdoMasterId = Convert.ToInt64(GenericFactoryFor_FDOMaster.getMaxID("SalFDOMaster"));
FdoDetailId = Convert.ToInt64(GenericFactoryFor_FDODetails.getMaxID("SalFDODetail"));
FirstDigit = Convert.ToInt64(FdoDetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(FdoDetailId.ToString().Substring(1, FdoDetailId.ToString().Length - 1));
//end new maxId
CustomNo = GenericFactoryFor_FDOMaster.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1); // // 1 for user id and 1 for db id --- work later
if (CustomNo != null)
{
FDONo = CustomNo;
}
else
{
FDONo = FdoMasterId.ToString();
}
Masteritem = new SalFDOMaster
{
FDOMasterID = FdoMasterId,
TransactionTypeID = objcmnParam.tTypeId,
FDONo = FDONo,
FDODate = DateTime.Today,
HDOID = (Master.MHDOID).ToString(),
PartyID = (int)Master.MPartyID,
DeliveryTo = Master.MDeliveryTo,
BillNo = Master.MBillNo,
BillDate = Master.MBillDate,
DriverName = Master.DriverName,
DriverPhoneNo = Master.DriverPhoneNo,
BuyerContactName = Master.BuyerContactName,
BuyerContactPhoneNo = Master.BuyerContactPhoneNo,
TruckNo = Master.TruckNo,
CompanyID = objcmnParam.loggedCompany,
DepartmentID = objcmnParam.SelectedDepartmentID,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsActive = true,
IsDeleted = false,
StatusBy = objcmnParam.loggeduser,
StatusID = 1,
IsDCCompleted = false
};
for (int i = 0; i < Detail.Count(); i++)
{
item = Detail[i];
CurrentStock = 0;
TransitQty = 0;
//*************************To Check Stock Quantity in InvStockMaster************************
var StockMasterTemp1 = StockMaster.Where(s => item.BatchId == null ? true : s.BatchID == item.BatchId).ToList();
var StockMasterTemp2 = (from x in StockMasterTemp1.Where(x => item.LotId == null ? true : x.LotID == item.LotId)
where item.ItemGradeID == null ? true : x.GradeID == item.ItemGradeID
select new InvStockMaster
{
DepartmentID = x.DepartmentID,
LotID = x.LotID,
BatchID = x.BatchID,
GradeID = x.GradeID,
ItemID = x.ItemID,
CurrentStock = x.CurrentStock
}).ToList();
foreach (InvStockMaster j in StockMasterTemp2.Where(s => s.ItemID == item.ItemID))
{
CurrentStock = CurrentStock + (decimal)j.CurrentStock;
//break;
}
///// checking transit table from database data//////////////
var TransitReal1 = StockTransit.Where(x => x.ItemID == item.ItemID).ToList();
var TransitReal2 = TransitReal1.Where(x => item.BatchId == null ? true : x.BatchID == item.BatchId).ToList();
var TransitReal = (from t in TransitReal2.Where(x => item.LotId == null ? true : x.LotID == item.LotId)
where item.ItemGradeID == null ? true : t.GradeID == item.ItemGradeID
select t.TransitQty).Sum();
/////////// checking data from FDO Detail///////////////////
var TransitTemp1 = InsertStockTransit.Where(x => x.ItemID == item.ItemID).ToList();
var TransitTemp2 = TransitTemp1.Where(x => item.BatchId == null ? true : x.BatchID == item.BatchId).ToList();
var TransitTemp = (from t in TransitTemp2.Where(x => item.LotId == null ? true : x.LotID == item.LotId)
where item.ItemGradeID == null ? true : t.GradeID == item.ItemGradeID
select t.TransitQty).Sum();
TransitQty = (decimal)(TransitReal + TransitTemp);
//***************************************END*******************************************
//**********************************Detail Entry***************************************
if ((CurrentStock - TransitQty) >= item.QuantityYds && item.QuantityYds > 0)
{
var Detailitem = new SalFDODetail
{
FDODetailsID = Convert.ToInt64(FirstDigit + "" + OtherDigits),
FDOMasterID = FdoMasterId,
ItemID = (long)item.ItemID,
NetQtyKg = (decimal)item.NetQuantityKg,
PIID = (int)item.PIID,
QuantitYds = (decimal)item.QuantityYds,
QuantityKg = (decimal)item.Quantity,
GrossQtyKg = (decimal)item.GrossQuantityKg,
Amount = (decimal)item.Amount,
Rate = (decimal)item.UnitPrice,
RollNo = (decimal)item.Roll,
LotID = item.LotId,
BatchID = item.BatchId,
GradeID = item.ItemGradeID,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false,
IsDCCompleted = false
};
//***************************************END*******************************************
var InsertTran = new InvStockTransit
{
StockTransitID = NextId,
TransactionID = FdoMasterId,
TransactionTypeID = objcmnParam.tTypeId,
TransitQty = item.QuantityYds,
ItemID = item.ItemID,
DepartmentID = objcmnParam.SelectedDepartmentID,
LotID = item.LotId ?? 0,
BatchID = item.BatchId ?? 0,
GradeID = Convert.ToInt16(item.ItemGradeID ?? 0),
IsDeleted = false,
IsComplete = false,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP()
};
InsertStockTransit.Add(InsertTran);
NextId = NextId + 1;
//******************To Update Remaining Quantity in SalHDODetail******************
foreach (SalHDODetail u in HdoDetail.Where(u => u.HDODetailID == item.HDODetailID))
{
if (u.RemainingQty > 0)
{
if (item.RemainingQty > 0)
{
u.RemainingQty = item.RemainingQty;
}
else
{
u.RemainingQty = item.RemainingQty;
u.IsFDOCompleted = true;
}
UpdateHDODetail.Add(u);
break;
}
}
//************************************END************************************
FDODetail.Add(Detailitem);
OtherDigits++;
}
else
{
result = "1";
throw new Exception(); // if any product don't support by stock, go back.
}
}
if (Masteritem != null)
{
GenericFactoryFor_FDOMaster.Insert(Masteritem);
GenericFactoryFor_FDOMaster.Save();
GenericFactoryFor_FDOMaster.updateMaxID("SalFDOMaster", Convert.ToInt64(FdoMasterId));
GenericFactoryFor_FDOMaster.updateCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
}
if (FDODetail != null && FDODetail.Count != 0)
{
GenericFactoryFor_FDODetails.InsertList(FDODetail.ToList());
GenericFactoryFor_FDODetails.Save();
GenericFactoryFor_FDODetails.updateMaxID("SalFDODetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
}
if (UpdateHDODetail != null && UpdateHDODetail.Count != 0)
{
GenericFactoryFor_HDODetails_EF.UpdateList(UpdateHDODetail.ToList());
GenericFactoryFor_HDODetails_EF.Save();
}
if (InsertStockTransit != null || InsertStockTransit.Count() != 0)
{
GFactory_EF_InvStockTransit.InsertList(InsertStockTransit.ToList());
GFactory_EF_InvStockTransit.Save();
}
transaction.Complete();
result = FDONo;
}
catch (Exception e)
{
e.ToString();
}
}
}
return(result);
}
public string SaveIssueMasterDetails(InvIssueMaster IssueMaster, List <InvIssueDetail> IssueDetails, int menuID)
{
GenericFactory_GF_IssueDetail = new InvIssueDetail_GF();
GenericFactory_GF_IssueMaster = new InvIssueMaster_GF();
GenericFactory_EF_IssueMaster = new InvIssueMaster_EF();
GenericFactory_EF_IssueDetail = new InvIssueDetail_EF();
_ctxCmn = new ERP_Entities();
List <InvStockMaster> lstStockMaster = new List <InvStockMaster>();
List <InvIssueDetail> lstIssueDetail = new List <InvIssueDetail>();
string result = "";
if (IssueMaster.IssueID > 0)
{
int Result = 0;
try
{
var lstInvIssueMaster = GenericFactory_EF_IssueMaster.GetAll().FirstOrDefault(x => x.IssueID == IssueMaster.IssueID);
lstInvIssueMaster.UpdateBy = IssueMaster.CreateBy;
lstInvIssueMaster.UpdateOn = DateTime.Now;
lstInvIssueMaster.UpdatePc = HostService.GetIP();
lstInvIssueMaster.IssueDate = IssueMaster.IssueDate;
lstInvIssueMaster.DepartmentID = IssueMaster.DepartmentID;
lstInvIssueMaster.Comments = IssueMaster.Comments;
result = lstInvIssueMaster.RequisitionNo;
foreach (InvIssueDetail ivrd in IssueDetails)
{
InvIssueDetail objIssueDetail = GenericFactory_EF_IssueDetail.GetAll().FirstOrDefault(x => x.IssueID == IssueMaster.IssueID && x.IssueDetailID == ivrd.IssueDetailID);
objIssueDetail.IssueID = IssueMaster.IssueID;
objIssueDetail.ItemID = ivrd.ItemID;
objIssueDetail.UnitID = (int)ivrd.UnitID;
objIssueDetail.LotID = ivrd.LotID == 0 ? null : ivrd.LotID;
objIssueDetail.BatchID = ivrd.BatchID == 0 ? null : ivrd.BatchID;
objIssueDetail.IssueQty = ivrd.IssueQty;
objIssueDetail.UnitPrice = ivrd.UnitPrice == null ? 0 : ivrd.UnitPrice;
objIssueDetail.Amount = ivrd.IssueQty * ivrd.UnitPrice == null ? 0 : ivrd.UnitPrice;
objIssueDetail.UpdateBy = IssueMaster.CreateBy;
objIssueDetail.UpdateOn = DateTime.Now;
objIssueDetail.UpdatePc = HostService.GetIP();
lstIssueDetail.Add(objIssueDetail);
}
if (lstInvIssueMaster != null)
{
GenericFactory_EF_IssueMaster.Update(lstInvIssueMaster);
GenericFactory_EF_IssueMaster.Save();
}
// **************Details Transaction Update************************************************
if (lstIssueDetail.Count != 0)
{
GenericFactory_EF_IssueDetail.UpdateList(lstIssueDetail);
GenericFactory_EF_IssueDetail.Save();
}
}
catch (Exception e)
{
e.ToString();
Result = 0;
}
return(result);
}
else
{
using (TransactionScope transaction = new TransactionScope())
{
try
{
//...........START new maxId........//
long NextId = Convert.ToInt16(GenericFactory_EF_IssueMaster.getMaxID("InvIssueMaster"));
long FirstDigit = 0;
long OtherDigits = 0;
long nextDetailId = Convert.ToInt64(GenericFactory_EF_IssueDetail.getMaxID("InvIssueDetail"));
FirstDigit = Convert.ToInt64(nextDetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(nextDetailId.ToString().Substring(1, nextDetailId.ToString().Length - 1));
string customCode = "";
string CustomNo = customCode = GenericFactory_EF_IssueMaster.getCustomCode(menuID, Convert.ToDateTime(IssueMaster.IssueDate), IssueMaster.CompanyID, 1, 1);
if (customCode != "")
{
customCode = CustomNo;
}
else
{
customCode = NextId.ToString();
}
//.........END for custom code............ //
IssueMaster.IssueID = NextId;
IssueMaster.CreateOn = DateTime.Now;
IssueMaster.CreatePc = HostService.GetIP();
IssueMaster.IssueNo = customCode;
foreach (InvIssueDetail ivrd in IssueDetails)
{
InvIssueDetail objIssueDetail = new InvIssueDetail();
objIssueDetail.IssueDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits);
objIssueDetail.IssueID = NextId;
objIssueDetail.ItemID = ivrd.ItemID;
objIssueDetail.UnitID = ivrd.UnitID;
objIssueDetail.LotID = ivrd.LotID == 0 ? null : ivrd.LotID;
objIssueDetail.BatchID = ivrd.BatchID == 0 ? null : ivrd.BatchID;
objIssueDetail.IssueQty = ivrd.IssueQty;
objIssueDetail.UnitPrice = ivrd.UnitPrice;
objIssueDetail.Amount = ivrd.Amount;
objIssueDetail.CreateBy = IssueMaster.CreateBy;
objIssueDetail.CreateOn = DateTime.Now;
objIssueDetail.IsDeleted = false;
objIssueDetail.CreatePc = HostService.GetIP();
lstIssueDetail.Add(objIssueDetail);
OtherDigits++;
}
_ctxCmn.InvIssueMasters.Add(IssueMaster);
//GenericFactory_EF_IssueMaster.Insert(IssueMaster);
//GenericFactory_EF_IssueMaster.Save();
//............Update MaxID.................//
GenericFactory_EF_IssueMaster.updateMaxID("InvIssueMaster", Convert.ToInt64(NextId));
//............Update CustomCode.............//
GenericFactory_EF_IssueMaster.updateCustomCode(menuID, DateTime.Now, IssueMaster.CompanyID, 1, 1);
// GenericFactory_EF_IssueDetail.InsertList(lstRequisitionDetail);
_ctxCmn.InvIssueDetails.AddRange(lstIssueDetail);
//GenericFactory_EF_IssueDetail.Save();
_ctxCmn.SaveChanges();
//............Update MaxID.................//
GenericFactory_EF_IssueDetail.updateMaxID("InvIssueDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
transaction.Complete();
result = customCode;
}
catch (Exception e)
{
result = "";
}
}
}
return(result);
}
public string SaveUpdateBWS(PrdBWSlist BWSInfo, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (TransactionScope transaction = new TransactionScope())
{
GenericFactory_EF_PrdBWSlist = new PrdBWSlist_EF();
long MainId = 0; string CustomNo = string.Empty, BWSNos = string.Empty;
var UBWSInfo = new PrdBWSlist();
try
{
if (BWSInfo.BWSID > 0)
{
UBWSInfo = GenericFactory_EF_PrdBWSlist.GetAll().Where(x => x.BWSID == BWSInfo.BWSID).FirstOrDefault();
UBWSInfo.BWSName = BWSInfo.BWSName;
UBWSInfo.BWSType = BWSInfo.BWSType;
UBWSInfo.DepartmentID = BWSInfo.DepartmentID;
UBWSInfo.Description = BWSInfo.Description;
UBWSInfo.CompanyID = objcmnParam.loggedCompany;
UBWSInfo.UpdateBy = objcmnParam.loggeduser;
UBWSInfo.UpdateOn = DateTime.Now;
UBWSInfo.UpdatePc = HostService.GetIP();
BWSNos = UBWSInfo.BWSNo;
}
else
{
MainId = Convert.ToInt16(GenericFactory_EF_PrdBWSlist.getMaxID("PrdBWSlist"));
CustomNo = GenericFactory_EF_PrdBWSlist.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
if (CustomNo == null || CustomNo == "")
{
BWSNos = MainId.ToString();
}
else
{
BWSNos = CustomNo;
}
UBWSInfo = new PrdBWSlist()
{
BWSID = (int)MainId,
BWSNo = BWSNos.ToString(),
BWSName = BWSInfo.BWSName,
BWSType = BWSInfo.BWSType,
DepartmentID = BWSInfo.DepartmentID,
Description = BWSInfo.Description,
IsDeleted = false,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP()
};
}
if (BWSInfo.BWSID > 0)
{
GenericFactory_EF_PrdBWSlist.Update(UBWSInfo);
GenericFactory_EF_PrdBWSlist.Save();
}
else
{
GenericFactory_EF_PrdBWSlist.Insert(UBWSInfo);
GenericFactory_EF_PrdBWSlist.Save();
GenericFactory_EF_PrdBWSlist.updateMaxID("PrdBWSlist", Convert.ToInt64(MainId));
GenericFactory_EF_PrdBWSlist.updateCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
}
transaction.Complete();
result = BWSNos;
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
return(result);
}
public TransactionTypeMgt()
{
GenericFactory_EF_ItemGroup = new CmnItemGroup_EF();
GenericFactory_EF_ItemType = new CmnItemItemType_EF();
}
public IEnumerable <vmSalDCMasterDetail> GetDCMaster(vmCmnParameters cmnParam, out int recordsTotal)
{
GenericFactory_EF_DCMaster = new SalDCMaster_EF();
IEnumerable <vmSalDCMasterDetail> objDCMaster = null;
IEnumerable <vmSalDCMasterDetail> objDCMasterWithoutPage = null;
List <CmnUserWiseCompany> whichCompanies = null;
recordsTotal = 0;
//string spQuery = string.Empty;
using (ERP_Entities _ctxCmn = new ERP_Entities())
{
whichCompanies = _ctxCmn.CmnUserWiseCompanies.Where(m => m.UserID == cmnParam.loggeduser && m.IsDeleted == false).ToList().
Select(m => new CmnUserWiseCompany
{
CompanyID = m.CompanyID,
// CreatePc = m.CreatePc
}).ToList();
List <SalDCMaster> SalDCMaster = new List <SalDCMaster>();
foreach (CmnUserWiseCompany u in whichCompanies)
{
List <SalDCMaster> AddToList = new List <SalDCMaster>();
AddToList = _ctxCmn.SalDCMasters.Where(m => m.CompanyID == u.CompanyID && m.IsDeleted == false && m.IsActive == true).ToList();
if (AddToList != null && AddToList.Count > 0)
{
SalDCMaster.AddRange(AddToList);
}
}
List <SalDCDetail> SalDCDetail = new List <SalDCDetail>();
foreach (CmnUserWiseCompany u in whichCompanies)
{
List <SalDCDetail> AddDetailToList = new List <SalDCDetail>();
AddDetailToList = _ctxCmn.SalDCDetails.Where(m => m.CompanyID == u.CompanyID && m.IsDeleted == false).ToList();
if (AddDetailToList != null && AddDetailToList.Count > 0)
{
SalDCDetail.AddRange(AddDetailToList);
}
}
try
{
//objDCMasterWithoutPage = SalDCMaster.Select(m => new SalDCMaster
//{
// DCID = m.DCID,
// DCNo = m.DCNo,
// DCDate = m.DCDate,
// CompanyID = m.CompanyID
//}).ToList();
objDCMasterWithoutPage = (from dcm in SalDCMaster
join dcd in _ctxCmn.SalDCDetails on dcm.DCID equals dcd.DCID
select new
{
DCID = dcm.DCID,
DCNo = dcm.DCNo,
DCDate = dcm.DCDate,
QuantityYds = dcd.QuantityYds == null ? 0 : dcd.QuantityYds
}).GroupBy(s => new { s.DCID }).Select(x => new vmSalDCMasterDetail
{
DCID = x.FirstOrDefault().DCID,
DCNo = x.FirstOrDefault().DCNo,
DCDate = x.FirstOrDefault().DCDate,
QuantityYds = x.Sum(p => p.QuantityYds)
}).ToList();
objDCMaster = objDCMasterWithoutPage.OrderByDescending(x => x.DCID).Skip(cmnParam.pageNumber).
Take(cmnParam.pageSize).ToList();
recordsTotal = objDCMasterWithoutPage.Count();
}
catch (Exception e)
{
e.ToString();
}
}
return(objDCMaster);
}
private CmnCustomCode ModelBinding(CmnCustomCode model, List <CmnCustomCodeDetail> details)
{
GenericFactory_EF_customCode = new CmnCustomCode_EF();
try
{
int NextID = GenericFactory_EF_customCode.getMaxVal_int("RecordID", "CmnCustomCode");
model.RecordID = model.RecordID == 0 ? NextID : model.RecordID;
model.CustomCode = model.RecordID.ToString();
model.CompanyID = model.CompanyID;
model.IsCompany = model.IsCompany ?? false;
model.IsOrganogramCode = model.IsOrganogramCode ?? false;
model.IsDeleted = false;
NextID = GenericFactory_EF_customCode.getMaxVal_int("RecordDetailID", "CmnCustomCodeDetail");
foreach (CmnCustomCodeDetail Item in details)
{
CmnCustomCodeDetail entity = new CmnCustomCodeDetail();
entity.RecordDetailID = Item.RecordDetailID;
if (Item.RecordDetailID == 0)
{
if (Item.IsDeleted)
{
continue;
}
Item.RecordDetailID = NextID++;
entity.RecordDetailID = Item.RecordDetailID;
entity.EntryStateStatus = "Add";
}
else if (Item.IsDeleted == true)
{
entity.EntryStateStatus = "Delete";
}
else
{
entity.EntryStateStatus = "Modified";
}
entity.CustomCode = entity.RecordDetailID.ToString();
entity.CustomCodeID = model.RecordID;
entity.ParameterName = Item.ParameterName;
entity.Length = Item.Length;
entity.Seperator = Item.Seperator;
entity.Sequence = Item.Sequence;
entity.StatusID = Item.StatusID;
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.CmnCustomCodeDetails.Add(entity);
}
}
catch (Exception ex)
{
ex.ToString();
}
return(model);
}
public string SaveUpdateDC(SalDCMaster DCInfo, List <SalDCDetail> DCDetailList, vmCmnParameters objcmnParam)
{
GenericFactory_EF_DCMaster = new SalDCMaster_EF();
GenericFactory_EF_DCDetail = new SalDCDetail_EF();
GFactory_EF_InvStockMaster = new InvStockMaster_EF();
GFactory_EF_InvStockDetail = new InvStockDetail_EF();
GenericFactory_EF_FDOMaster = new SalFDOMaster_EF();
GenericFactory_EF_FDODetail = new SalFDODetail_EF();
GFactory_EF_InvStockTransit = new InvStockTransit_EF();
string result = "";
long NextId = Convert.ToInt64(GenericFactory_EF_DCMaster.getMaxID("SalDCMaster"));
long FirstDigit = 0;
long OtherDigits = 0;
long nextDetailId = Convert.ToInt64(GenericFactory_EF_DCDetail.getMaxID("SalDCDetail"));
FirstDigit = Convert.ToInt64(nextDetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(nextDetailId.ToString().Substring(1, nextDetailId.ToString().Length - 1));
string customCode = "";
string CustomNo = customCode = GenericFactory_EF_DCMaster.getCustomCode(objcmnParam.menuId, DCInfo.DCDate,
DCInfo.CompanyID, objcmnParam.loggeduser, 1); // 1 for DB ID
if (CustomNo != null)
{
customCode = CustomNo;
}
else
{
customCode = NextId.ToString();
}
try
{
DCInfo.DCID = NextId;
DCInfo.DCNo = customCode;
DCInfo.CreateOn = DateTime.Now;
DCInfo.IsActive = true;
List <SalDCDetail> lstSalDCDetail = new List <SalDCDetail>();
foreach (SalDCDetail sdtl in DCDetailList)
{
SalDCDetail objSalDCDetail = new SalDCDetail();
//objSalDCDetail.DCDetailID = nextDetailId;
objSalDCDetail.DCDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits);
objSalDCDetail.DCID = NextId;
objSalDCDetail.FDOID = sdtl.FDOID;
objSalDCDetail.TruckNo = sdtl.TruckNo;
objSalDCDetail.QuantityYds = sdtl.QuantityYds;
objSalDCDetail.Roll = sdtl.Roll;
objSalDCDetail.CompanyID = DCInfo.CompanyID;
objSalDCDetail.CreateBy = DCInfo.CreateBy;
objSalDCDetail.CreateOn = DateTime.Now;
objSalDCDetail.CreatePc = HostService.GetIP();
objSalDCDetail.IsDeleted = false;
objSalDCDetail.StatusBy = 1;
objSalDCDetail.StatusID = 1;
lstSalDCDetail.Add(objSalDCDetail);
OtherDigits++;
}
using (TransactionScope transaction = new TransactionScope())
{
/////////////////////// Start FDOMaster and FDO Detail Table Update /////////////////////////////
foreach (SalDCDetail sdcd in DCDetailList)
{
SalFDOMaster objSalFDOMaster = GenericFactory_EF_FDOMaster.FindBy(m => m.FDOMasterID == sdcd.FDOID).FirstOrDefault();
objSalFDOMaster.IsDCCompleted = true;
GenericFactory_EF_FDOMaster.Update(objSalFDOMaster);
GenericFactory_EF_FDOMaster.Save();
List <SalFDODetail> objSalFDODetail = GenericFactory_EF_FDODetail.FindBy(m => m.FDOMasterID == sdcd.FDOID).ToList();
foreach (SalFDODetail sfdod in objSalFDODetail)
{
sfdod.IsDCCompleted = true;
GenericFactory_EF_FDODetail.Update(sfdod);
GenericFactory_EF_FDODetail.Save();
}
}
/////////////////////// End FDOMaster and FDO Detail Table Update /////////////////////////////
/////////////////////// Start Stock Table Update /////////////////////////////
//#region Stock Hit
//IEnumerable<SalFDODetail> objFDODetail = null;
////string spQuery = string.Empty;
//try
//{
// objFDODetail = GenericFactory_EF_FDODetail.GetAll().Select(m => new
// SalFDODetail
// {
// ItemID = m.ItemID,
// BatchID = m.BatchID,
// LotID = m.LotID,
// GradeID = m.GradeID,
// QuantitYds = m.QuantitYds,
// FDOMasterID = m.FDOMasterID,
// CompanyID = m.CompanyID
// }).
// Where(m => m.FDOMasterID == DCInfo.FDOID).ToList();
//}
//catch (Exception e)
//{
// e.ToString();
//}
//List<InvStockMaster> objInvStockMaster = GFactory_EF_InvStockMaster.FindBy(m => m.DepartmentID == objSalFDOMaster.DepartmentID).ToList();
//foreach (SalFDODetail sfdod in objFDODetail)
//{
// InvStockMaster objStockMaster = new InvStockMaster();
// var ItemBatchFilter = objInvStockMaster.Where(x => x.ItemID == sfdod.ItemID
// && sfdod.BatchID == null ? true : x.BatchID == sfdod.BatchID).ToArray();
// var TransitBatch2 = ItemBatchFilter.Where(x => sfdod.LotID == null ? true : x.LotID == sfdod.LotID).ToArray();
// objStockMaster = ItemBatchFilter.Where(x => sfdod.GradeID == null ? true : x.GradeID == sfdod.GradeID).FirstOrDefault();
// objStockMaster.IssueQty = objStockMaster.IssueQty + sfdod.QuantitYds;
// GFactory_EF_InvStockMaster.Update(objStockMaster);
// GFactory_EF_InvStockMaster.Save();
// ///////////////////////////////// detail insert /////////////////////////////////////
// InvStockDetail objInvStockDetail = new InvStockDetail();
// objInvStockDetail.StockID = objStockMaster.StockID;
// objInvStockDetail.DepartmentID = objSalFDOMaster.DepartmentID;
// objInvStockDetail.TransactionID = objSalFDOMaster.FDOMasterID;
// objInvStockDetail.TransactionTypeID = objcmnParam.tTypeId??0;
// objInvStockDetail.StockDate = DateTime.Now;
// objInvStockDetail.ItemID = sfdod.ItemID;
// objInvStockDetail.ItemTypeID = 1;
// objInvStockDetail.LotID = sfdod.LotID == null ? 0 : (int)sfdod.LotID;
// objInvStockDetail.BatchID = sfdod.BatchID == null ? 0 : (int)sfdod.BatchID;
// objInvStockDetail.GradeID = sfdod.GradeID == null ? 0 : (int)sfdod.GradeID;
// objInvStockDetail.LotNo = "";
// objInvStockDetail.SupplierID = 0;
// objInvStockDetail.ReceiveQty = 0;
// objInvStockDetail.ReceiveValue = 0;
// objInvStockDetail.ReceiveRate = 0;
// objInvStockDetail.IssueQty = sfdod.QuantitYds;
// objInvStockDetail.UOMID = 0;
// objInvStockDetail.IssueRate = 0;
// objInvStockDetail.IssueValue = 0;
// objInvStockDetail.IsActive = true;
// objInvStockDetail.IssueRate = 0;
// objInvStockDetail.CompanyID = sfdod.CompanyID;
// objInvStockDetail.CreateBy = objSalFDOMaster.CreateBy;
// objInvStockDetail.CreateOn = DateTime.Now;
// objInvStockDetail.CreatePc = HostService.GetIP();
// GFactory_EF_InvStockDetail.Insert(objInvStockDetail);
// GFactory_EF_InvStockDetail.Save();
//}
//#endregion Stock Hit
/////////////////////// End Stock Table Update //////////////////////////////
/////////////////////// Stock Transit Table Data Delete /////////////////////
//#region Stock Transit Hit
//foreach (SalFDODetail sfdod in objFDODetail)
//{
// List<InvStockTransit> objInvStockTransit =
// GFactory_EF_InvStockTransit.FindBy(m => m.DepartmentID == objSalFDOMaster.DepartmentID
// //&& m.LotID == sfdod.LotID && m.BatchID == sfdod.BatchID && m.GradeID == sfdod.GradeID
// && m.ItemID == sfdod.ItemID && m.CompanyID == sfdod.CompanyID
// && m.TransactionTypeID == objSalFDOMaster.FDOTypeID
// && m.TransactionID == sfdod.FDOMasterID).ToList();
// GFactory_EF_InvStockTransit.DeleteList(objInvStockTransit);
// GFactory_EF_InvStockTransit.Save();
//}
//#endregion End Stock Transit Hit
/////////////////////// End Stock Transit Table Data Delete /////////////////////
GenericFactory_EF_DCMaster.Insert(DCInfo);
GenericFactory_EF_DCMaster.Save();
GenericFactory_EF_DCMaster.updateMaxID("SalDCMaster", Convert.ToInt64(NextId));
GenericFactory_EF_DCMaster.updateCustomCode(objcmnParam.menuId, DateTime.Now, DCInfo.CompanyID, 1, 1);
GenericFactory_EF_DCDetail.InsertList(lstSalDCDetail);
GenericFactory_EF_DCDetail.Save();
GenericFactory_EF_DCDetail.updateMaxID("SalDCDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
transaction.Complete();
}
result = customCode;
}
catch (Exception e)
{
e.ToString();
result = "";
}
finally
{
}
return(result);
}
public List <CmnCustomCodeDetail> GetCustomCodeDetailsByID(int?companyID, int?loggedUser, int?pageNumber, int?pageSize, int?IsPaging, int?DetailsID)
{
GenericFactory_EF_customDetails = new CmnCustomCodeDetail_EF();
return(GenericFactory_EF_customDetails.FindBy(x => x.CustomCodeID == DetailsID && x.IsDeleted == false).ToList());
}
public string SaveQuotationMasterDetails(PurchaseQuotationMaster QuotationMaster, List <PurchaseQuotationDetail> QuotationDetails, int menuID)
{
//Declerations
string result = string.Empty; string customCode = string.Empty; string CustomNo = string.Empty;
int RequisitionID = Convert.ToInt32(QuotationMaster.QuotationID), SDetailRowNum = 0, UDetailRowNum = 0;
long FirstDigit = 0, OtherDigits = 0, nextDetailId = 0; int NextId = 0;
GenericFactory_EF_QuotationMaster = new PurchaseQuotationMaster_EF();
GenericFactory_EF_QuotationDetail = new PurchaseQuotationDetail_EF();
List <PurchaseQuotationDetail> objRqDetails = new List <PurchaseQuotationDetail>();
List <InvRequisitionDetail> SobjDetails = new List <InvRequisitionDetail>();
// SDetailRowNum = Convert.ToInt32(RequisitionDetails.Where(s => s.ModelState == "Save").Count());
// UDetailRowNum = Convert.ToInt32(RequisitionDetails.Where(s => s.ModelState == "Update").Count());
try
{
using (_ctxCmn = new ERP_Entities())
{
//Transaction Occur here************************************************
using (TransactionScope transaction = new TransactionScope())
{
if (RequisitionID > 0)
{
//**************Master Model************************************************
//var lstInvReqMaster = GenericFactory_EF_RequisitionMaster.GetAll().FirstOrDefault(x => x.RequisitionID == RequisitionID);
//lstInvReqMaster.UpdateBy = RequisitionMaster.CreateBy;
//lstInvReqMaster.UpdateOn = DateTime.Now;
//lstInvReqMaster.UpdatePc = HostService.GetIP();
//lstInvReqMaster.RequisitionBy = RequisitionMaster.RequisitionBy;
//lstInvReqMaster.RequisitionDate = RequisitionMaster.RequisitionDate;
//lstInvReqMaster.Remarks = RequisitionMaster.Remarks;
//lstInvReqMaster.Purpose = RequisitionMaster.Purpose;
////*************Details Model************************************************
//if (UDetailRowNum > 0)
//{
// foreach (vmRequisitionDetails ivrd in RequisitionDetails.Where(x => x.ModelState == "Update"))
// {
// InvRequisitionDetail objRequisitionDetail = GenericFactory_EF_RequisitionDetail.GetAll().FirstOrDefault(x => x.RequisitionID == RequisitionID && x.RequisitionDetailID == ivrd.RequisitionDetailID);
// objRequisitionDetail.Qty = ivrd.Qty;
// objRequisitionDetail.UpdateBy = RequisitionMaster.CreateBy;
// objRequisitionDetail.UpdateOn = DateTime.Now;
// objRequisitionDetail.UpdatePc = HostService.GetIP();
// objRqDetails.Add(objRequisitionDetail);
// }
//}
//if (SDetailRowNum > 0)
//{
// nextDetailId = Convert.ToInt64(GenericFactory_EF_RequisitionDetail.getMaxID("InvRequisitionDetail"));
// FirstDigit = Convert.ToInt64(nextDetailId.ToString().Substring(0, 1));
// OtherDigits = Convert.ToInt64(nextDetailId.ToString().Substring(1, nextDetailId.ToString().Length - 1));
// foreach (vmRequisitionDetails ivrd in RequisitionDetails.Where(x => x.ModelState == "Save"))
// {
// InvRequisitionDetail objRequisitionDetail = new InvRequisitionDetail();
// objRequisitionDetail.RequisitionDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits);
// objRequisitionDetail.RequisitionID = RequisitionMaster.RequisitionID;
// objRequisitionDetail.ItemID = ivrd.ItemID;
// objRequisitionDetail.UnitID = (int)ivrd.UnitID;
// objRequisitionDetail.LotID = ivrd.LotID;
// objRequisitionDetail.BatchID = ivrd.BatchID;
// objRequisitionDetail.Qty = ivrd.Qty;
// objRequisitionDetail.UnitPrice = ivrd.UnitPrice;
// objRequisitionDetail.Amount = ivrd.Amount;
// objRequisitionDetail.CreateBy = RequisitionMaster.CreateBy;
// objRequisitionDetail.CreateOn = DateTime.Now;
// objRequisitionDetail.IsDeleted = false;
// objRequisitionDetail.CreatePc = HostService.GetIP();
// SobjDetails.Add(objRequisitionDetail);
// OtherDigits++;
// }
//}
////RequisitionID
////**************Master Transaction Update************************************************
//if (lstInvReqMaster != null)
//{
// GenericFactory_EF_RequisitionMaster.Update(lstInvReqMaster);
// GenericFactory_EF_RequisitionMaster.Save();
//}
////RequisitionDetailID
//// **************Details Transaction Update************************************************
//if (objRqDetails.Count != 0)
//{
// GenericFactory_EF_RequisitionDetail.UpdateList(objRqDetails);
// GenericFactory_EF_RequisitionDetail.Save();
//}
//if (SobjDetails.Count != 0)
//{
// GenericFactory_EF_RequisitionDetail.InsertList(SobjDetails);
// GenericFactory_EF_RequisitionDetail.Save();
// GenericFactory_EF_RequisitionDetail.updateMaxID("InvRequisitionDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
//}
////**************Commit Transaction************************************************
//// _ctxCmn.SaveChanges();
//transaction.Complete();
//result = customCode;
}
else
{
//Initialisation ************************************************
NextId = Convert.ToInt16(GenericFactory_EF_QuotationMaster.getMaxID("PurchaseQuotationMaster"));
nextDetailId = Convert.ToInt64(GenericFactory_EF_QuotationDetail.getMaxID("PurchaseQuotationDetail"));
FirstDigit = Convert.ToInt64(nextDetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(nextDetailId.ToString().Substring(1, nextDetailId.ToString().Length - 1));
CustomNo = GenericFactory_EF_QuotationMaster.getCustomCode(menuID, Convert.ToDateTime(QuotationMaster.QuotationDate), QuotationMaster.CompanyID, 1, 1); // QuotationMaster.CompanyID
if ((customCode != "") || (customCode != null))
{
customCode = CustomNo;
}
else
{
customCode = NextId.ToString();
}
//**************Master Model************************************************
QuotationMaster.QuotationID = NextId;
QuotationMaster.CreateOn = DateTime.Now;
QuotationMaster.CreatePc = HostService.GetIP();
QuotationMaster.QuotationNo = customCode;
//*************Details Model************************************************
foreach (PurchaseQuotationDetail ivrd in QuotationDetails)
{
PurchaseQuotationDetail objDetail = new PurchaseQuotationDetail();
objDetail.QuotationDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits);
objDetail.QuotationID = NextId;
objDetail.ItemID = ivrd.ItemID;
objDetail.UnitID = (int)ivrd.UnitID;
objDetail.Qty = ivrd.Qty;
objDetail.UnitPrice = ivrd.UnitPrice;
objDetail.Amount = ivrd.Amount;
objDetail.FOBValue = ivrd.FOBValue;
objDetail.TransportTypeID = ivrd.TransportTypeID;
objDetail.FreightCharge = ivrd.FreightCharge;
objDetail.DischargeLocationID = ivrd.DischargeLocationID;
objDetail.LoadingLocationID = ivrd.LoadingLocationID;
objDetail.CreateBy = QuotationMaster.CreateBy;
objDetail.CreateOn = DateTime.Now;
objDetail.IsDeleted = false;
objDetail.CreatePc = HostService.GetIP();
objRqDetails.Add(objDetail);
OtherDigits++;
}
//QuotationID
//**************Master Transaction Save************************************************
_ctxCmn.PurchaseQuotationMasters.Add(QuotationMaster);
//QuotationIDDetailID
//**************Details Transaction Save************************************************
_ctxCmn.PurchaseQuotationDetails.AddRange(objRqDetails);
_ctxCmn.SaveChanges();
//**************Reset Transaction************************************************
GenericFactory_EF_QuotationMaster.updateMaxID("PurchaseQuotationMaster", Convert.ToInt64(NextId));
GenericFactory_EF_QuotationMaster.updateCustomCode(menuID, DateTime.Now, 1, 1, 1); // QuotationMaster.CompanyID
GenericFactory_EF_QuotationDetail.updateMaxID("PurchaseQuotationDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
//**************Commit Transaction************************************************
transaction.Complete();
result = customCode;
}
}
}
}
catch (Exception)
{
result = "-1";
}
return(result);
}
public string DelUpdateSetWiseMachineSetupMasterDetail(vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (var transaction = new TransactionScope())
{
GFactory_EF_PrdDyingMachineSetup = new PrdDyingMachineSetup_EF();
GFactory_EF_PrdDyingMachineSetupDetail = new PrdDyingMachineSetupDetail_EF();
var Masteritem = new PrdDyingMachineSetup();
var SetDetail = new List <PrdDyingMachineSetupDetail>();
//For Update Master Detail
var SetMasterAll = GFactory_EF_PrdDyingMachineSetup.GetAll().Where(x => x.SetupID == objcmnParam.id);
var SetDetailAll = GFactory_EF_PrdDyingMachineSetupDetail.GetAll().Where(x => x.SetupID == objcmnParam.id);
//-------------------END----------------------
try
{
using (_ctxCmn = new ERP_Entities())
{
Masteritem = SetMasterAll.First(x => x.SetupID == objcmnParam.id);
Masteritem.CompanyID = objcmnParam.loggedCompany;
Masteritem.DeleteBy = objcmnParam.loggeduser;
Masteritem.DeleteOn = DateTime.Now;
Masteritem.DeletePc = HostService.GetIP();
Masteritem.IsDeleted = true;
foreach (PrdDyingMachineSetupDetail d in SetDetailAll.Where(d => d.SetupID == objcmnParam.id))
{
d.CompanyID = objcmnParam.loggedCompany;
d.DeleteBy = objcmnParam.loggeduser;
d.DeleteOn = DateTime.Now;
d.DeletePc = HostService.GetIP();
d.IsDeleted = true;
SetDetail.Add(d);
//break;
}
}
if (Masteritem != null)
{
GFactory_EF_PrdDyingMachineSetup.Update(Masteritem);
GFactory_EF_PrdDyingMachineSetup.Save();
}
if (SetDetail != null && SetDetail.Count != 0)
{
GFactory_EF_PrdDyingMachineSetupDetail.UpdateList(SetDetail.ToList());
GFactory_EF_PrdDyingMachineSetupDetail.Save();
}
transaction.Complete();
result = "1";
}
catch (Exception e)
{
result = "";
e.ToString();
}
}
return(result);
}
public string SaveUpdateWastage(vmWastageMasterDetail itemMaster, List <vmWastageMasterDetail> MainDetail, vmCmnParameters objcmnParam)
{
// private iGenericFactory_EF<PrdWastage> GenericFactory_PrdWastage_EF;
//private iGenericFactory_EF<PrdWastageDetail> GenericFactory_PrdWastageDetail_EF;
//private iGenericFactory<vmWastageMasterDetail> GenericFactory_vmWastageMasterDetail_VM = null;
string result = string.Empty;
using (TransactionScope transaction = new TransactionScope())
{
//*********************************************Start Initialize Variable*****************************************
string CustomNo = string.Empty; long MainMasterId = 0, StopMasterId = 0, BreakMasterId = 0,
MainDetailId = 0, MainFirstDigit = 0, MainOtherDigits = 0;
int SMainRowNum = 0, UMainRowNum = 0, LastRowNum = 0; string WastageNo = "";
//***************************************End Initialize Variable*************************************************
//**************************Start Initialize Generic Repository Based on table***********************************
GenericFactory_PrdWastage_EF = new PrdWastage_EF();
GenericFactory_PrdWastageDetail_EF = new PrdWastageDetail_EF();
//****************************End Initialize Generic Repository Based on table***********************************
//**********************************Start Create Related Table Instance to Save**********************************
var MasterItem = new PrdWastage();
var DetailItemMain = new List <PrdWastageDetail>();
var UDetailItemMain = new List <PrdWastageDetail>();
//************************************End Create Related Table Instance to Save**********************************
//*************************************Start Create Model Instance to get Data***********************************
vmWastageMasterDetail item = new vmWastageMasterDetail();
//***************************************End Create Model Instance to get Data***********************************
SMainRowNum = Convert.ToInt32(MainDetail.Where(x => x.ModelState == "Save").Count());
UMainRowNum = Convert.ToInt32(MainDetail.Where(x => x.ModelState == "Update" || x.ModelState == "Delete").Count());
//**************************************************Start Main Operation************************************************
if (SMainRowNum > 0 || UMainRowNum > 0)
{
try
{
if (itemMaster.WastageID == 0)
{
//***************************************************Start Save Operation************************************************
//**********************************************Start Generate Master & Detail ID****************************************
MainMasterId = Convert.ToInt16(GenericFactory_PrdWastage_EF.getMaxID("PrdWastage"));
MainDetailId = Convert.ToInt64(GenericFactory_PrdWastageDetail_EF.getMaxID("PrdWastageDetail"));
MainFirstDigit = Convert.ToInt64(MainDetailId.ToString().Substring(0, 1));
MainOtherDigits = Convert.ToInt64(MainDetailId.ToString().Substring(1, MainDetailId.ToString().Length - 1));
//***********************************************End Generate Master & Detail ID*****************************************
CustomNo = GenericFactory_PrdWastage_EF.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
if (CustomNo == null || CustomNo == "")
{
WastageNo = MainMasterId.ToString();
}
else
{
WastageNo = CustomNo;
}
MasterItem = new PrdWastage
{
WastageID = MainMasterId,
WastageNo = WastageNo,
WastageDate = (DateTime)itemMaster.WastageDate,
DepartmentID = (int)itemMaster.DepartmentID,
Remarks = itemMaster.Remarks,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
for (int i = 0; i < SMainRowNum; i++)
{
item = MainDetail[i];
var Detailitem = new PrdWastageDetail
{
WastageDetailID = Convert.ToInt64(MainFirstDigit + "" + MainOtherDigits),
WastageID = MainMasterId,
ItemID = item.ItemID,
Qty = item.Qty,
UnitID = item.UnitID,
Remarks = item.Remarks,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
DetailItemMain.Add(Detailitem);
MainOtherDigits++;
}
//***************************************************End Save Operation************************************************
}
else
{
if (UMainRowNum > 0)
{
var MasterAll = GenericFactory_PrdWastage_EF.GetAll().Where(x => x.WastageID == itemMaster.WastageID && x.CompanyID == objcmnParam.loggedCompany);
var DetailAll = GenericFactory_PrdWastageDetail_EF.GetAll().Where(x => x.WastageID == itemMaster.WastageID && x.CompanyID == objcmnParam.loggedCompany);
//*************************************End Get Data From Related Table to Update*********************************
WastageNo = itemMaster.WastageNo;
MasterItem = MasterAll.First(x => x.WastageID == itemMaster.WastageID);
MasterItem.WastageDate = (DateTime)itemMaster.WastageDate;
MasterItem.DepartmentID = (int)itemMaster.DepartmentID;
MasterItem.Remarks = itemMaster.Remarks;
MasterItem.CompanyID = objcmnParam.loggedCompany;
MasterItem.UpdateBy = objcmnParam.loggeduser;
MasterItem.UpdateOn = DateTime.Now;
MasterItem.UpdatePc = HostService.GetIP();
for (int i = 0; i < UMainRowNum; i++)
{
item = MainDetail.Where(x => x.ModelState == "Update" || x.ModelState == "Delete").ToList()[i];
foreach (PrdWastageDetail d in DetailAll.Where(d => d.WastageID == item.WastageID && d.WastageDetailID == item.WastageDetailID))
{
if (item.ModelState == "Delete")
{
d.CompanyID = objcmnParam.loggedCompany;
d.DeleteBy = objcmnParam.loggeduser;
d.DeleteOn = DateTime.Now;
d.DeletePc = HostService.GetIP();
d.IsDeleted = true;
}
else
{
d.ItemID = item.ItemID;
d.Qty = item.Qty;
d.UnitID = item.UnitID;
d.Remarks = item.Remarks;
d.CompanyID = objcmnParam.loggedCompany;
d.UpdateBy = objcmnParam.loggeduser;
d.UpdateOn = DateTime.Now;
d.UpdatePc = HostService.GetIP();
}
UDetailItemMain.Add(d);
}
}
}
if (SMainRowNum > 0)
{
for (int i = 0; i < SMainRowNum; i++)
{
item = MainDetail.Where(x => x.ModelState == "Save").ToList()[i];
MainDetailId = Convert.ToInt64(GenericFactory_PrdWastageDetail_EF.getMaxID("PrdWastageDetail"));
MainFirstDigit = Convert.ToInt64(MainDetailId.ToString().Substring(0, 1));
MainOtherDigits = Convert.ToInt64(MainDetailId.ToString().Substring(1, MainDetailId.ToString().Length - 1));
//***********************************************End Generate Master & Detail ID*****************************************
var Detailitem = new PrdWastageDetail
{
WastageDetailID = Convert.ToInt64(MainFirstDigit + "" + MainOtherDigits),
WastageID = (long)itemMaster.WastageID,
ItemID = item.ItemID,
Qty = item.Qty,
UnitID = item.UnitID,
Remarks = item.Remarks,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
DetailItemMain.Add(Detailitem);
MainOtherDigits++;
}
}
}
//***********************************Start Get Data From Related Table to Update*********************************
if (itemMaster.WastageID > 0)
{
if (MasterItem != null)
{
GenericFactory_PrdWastage_EF.Update(MasterItem);
GenericFactory_PrdWastage_EF.Save();
}
if (UDetailItemMain != null && UDetailItemMain.Count != 0)
{
GenericFactory_PrdWastageDetail_EF.UpdateList(UDetailItemMain.ToList());
GenericFactory_PrdWastageDetail_EF.Save();
}
if (DetailItemMain != null && DetailItemMain.Count != 0)
{
GenericFactory_PrdWastageDetail_EF.InsertList(DetailItemMain.ToList());
GenericFactory_PrdWastageDetail_EF.Save();
GenericFactory_PrdWastageDetail_EF.updateMaxID("PrdWastageDetail", Convert.ToInt64(MainFirstDigit + "" + (MainOtherDigits - 1)));
}
}
else
{
if (MasterItem != null)
{
GenericFactory_PrdWastage_EF.Insert(MasterItem);
GenericFactory_PrdWastage_EF.Save();
GenericFactory_PrdWastage_EF.updateMaxID("PrdWastage", Convert.ToInt64(MainMasterId));
GenericFactory_PrdWastage_EF.updateCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
}
if (DetailItemMain != null && DetailItemMain.Count != 0)
{
GenericFactory_PrdWastageDetail_EF.InsertList(DetailItemMain.ToList());
GenericFactory_PrdWastageDetail_EF.Save();
GenericFactory_PrdWastageDetail_EF.updateMaxID("PrdWastageDetail", Convert.ToInt64(MainFirstDigit + "" + (MainOtherDigits - 1)));
}
}
transaction.Complete();
result = "1";
}
catch (Exception e)
{
e.ToString();
if (result == "")
{
result = "";
}
}
#region To check Validation Error
//catch (DbEntityValidationException e)
//{
// foreach (var eve in e.EntityValidationErrors)
// {
// Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
// eve.Entry.Entity.GetType().Name, eve.Entry.State);
// foreach (var ve in eve.ValidationErrors)
// {
// Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
// ve.PropertyName, ve.ErrorMessage);
// }
// }
// throw;
//}
#endregion
}
else
{
result = "";
}
}
return(result);
//**************************************************End Main Operation************************************************
}
public string SaveUpdateLC(SalLCMaster LCInfo, List <SalLCDetail> LCDetailList, ArrayList fileNames, vmCmnParameters objcmnParam)
{
GenericFactory_SalLCMaster = new SalLCMaster_EF();
GenericFactory_SalLCDetail = new SalLCDetail_EF();
GenericFactory_CmnDocument = new CmnDocument_EF();
GenericFactory_EF_SalPIMaster = new SalPIMaster_EF();
GenericFactory_EF_SalBookingMaster = new SalBookingMaster_EF();
string result = ""; string newLCRefNo = "";
long FirstDigit = 0, OtherDigits = 0, nextDetailId = 0, NextId = 0;
#region Amendment Block
if (LCInfo.LCID > 0)
{
using (TransactionScope transaction = new TransactionScope())
{
try
{
NextId = Convert.ToInt64(GenericFactory_SalLCMaster.getMaxID("SalLCMaster"));
nextDetailId = Convert.ToInt64(GenericFactory_SalLCDetail.getMaxID("SalLCDetail"));
FirstDigit = Convert.ToInt64(nextDetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(nextDetailId.ToString().Substring(1, Convert.ToInt32(nextDetailId.ToString().Length) - 1));
//******------------------start create LC Amendment No No------------------******
string[] amendmendNo = LCInfo.LCReferenceNo.ToString().Split(new string[] { "-AMD-" }, StringSplitOptions.None); //itemMaster.PINO.ToString().Contains("Revise").ToString();
int amendNo = 0;
if (amendmendNo.Length > 1)
{
amendNo = Convert.ToInt16(amendmendNo[amendmendNo.Length - 1]) + 1;
newLCRefNo = amendmendNo[0] + "-AMD-" + amendNo.ToString();
}
else if (amendmendNo.Length == 1)
{
newLCRefNo = LCInfo.LCReferenceNo.ToString() + "-AMD-1".ToString();
amendNo = 1;
}
//******------------------end create LC Amendment No------------------******
//******------------------Update LC master and Detail------------------******
Int64 lLCID = LCInfo.LCID;
IEnumerable <SalLCMaster> objSalLCMaster = GenericFactory_SalLCMaster.FindBy(m => m.LCID == lLCID).ToList();
SalLCMaster lstSalLCMaster = new SalLCMaster();
foreach (SalLCMaster lc in objSalLCMaster)
{
lc.IsActive = false;
lstSalLCMaster = lc;
}
GenericFactory_SalLCMaster.Update(lstSalLCMaster);
GenericFactory_SalLCMaster.Save();
IEnumerable <SalLCDetail> objSalLCDetail = GenericFactory_SalLCDetail.FindBy(m => m.LCID == lLCID).ToList();
SalLCDetail lstSalLCDetail = new SalLCDetail();
foreach (SalLCDetail lcd in objSalLCDetail)
{
lcd.IsActive = false;
lstSalLCDetail = lcd;
}
GenericFactory_SalLCDetail.Update(lstSalLCDetail);
GenericFactory_SalLCDetail.Save();
//******------------------End Update LC master and Detail ------------------******
//******------------------Start PI Table Update ------------------******
foreach (SalLCDetail sdtl in LCDetailList)
{
SalPIMaster objSalPIMaster = GenericFactory_EF_SalPIMaster.FindBy(m => m.PIID == sdtl.PIID).FirstOrDefault();
objSalPIMaster.IsLcCompleted = true;
GenericFactory_EF_SalPIMaster.Update(objSalPIMaster);
GenericFactory_EF_SalPIMaster.Save();
}
//******------------------ End PI Table Update ------------------******
LCInfo.LCID = NextId;
LCInfo.LCReferenceNo = newLCRefNo;
LCInfo.AmendmentDate = LCInfo.LCDate;
LCInfo.AmendmentNo = amendNo.ToString();
LCInfo.CreateOn = DateTime.Now;
LCInfo.IsMasterLC = false;
LCInfo.IsActive = true;
LCInfo.IsHDOCompleted = false;
List <SalLCDetail> lstLCDetail = new List <SalLCDetail>();
foreach (SalLCDetail sdtl in LCDetailList)
{
SalLCDetail objLCDetail = new SalLCDetail();
objLCDetail.LCDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits);
objLCDetail.LCID = NextId;
objLCDetail.PIID = sdtl.PIID;
objLCDetail.PINo = sdtl.PINo;
objLCDetail.CustomCode = LCInfo.LCReferenceNo;
objLCDetail.LCReferenceNo = LCInfo.LCReferenceNo;
objLCDetail.AmendmentNo = LCInfo.AmendmentNo;
objLCDetail.AmendmentDate = LCInfo.AmendmentDate;
objLCDetail.CompanyID = LCInfo.CompanyID;
objLCDetail.IsHDOCompleted = false;
objLCDetail.CreateBy = LCInfo.CreateBy;
objLCDetail.CreateOn = DateTime.Now;
objLCDetail.CreatePc = HostService.GetIP();
objLCDetail.IsActive = true;
objLCDetail.IsDeleted = false;
objLCDetail.DBID = 1;
objLCDetail.StatusBy = 1;
objLCDetail.StatusID = 1;
lstLCDetail.Add(objLCDetail);
OtherDigits++;
}
GenericFactory_SalLCMaster.Insert(LCInfo);
GenericFactory_SalLCMaster.Save();
GenericFactory_SalLCMaster.updateMaxID("SalLCMaster", Convert.ToInt64(NextId));
GenericFactory_SalLCDetail.InsertList(lstLCDetail);
GenericFactory_SalLCDetail.Save();
GenericFactory_SalLCDetail.updateMaxID("SalLCDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
//**********----------------------Start File Upload----------------------**********
int DocumentID = Convert.ToInt16(GenericFactory_CmnDocument.getMaxID("CmnDocument"));
List <CmnDocument> lstCmnDocument = new List <CmnDocument>();
for (int i = 1; i <= fileNames.Count; i++)
{
CmnDocument objCmnDocument = new CmnDocument();
objCmnDocument.DocumentID = DocumentID;
objCmnDocument.DocumentPahtID = 1;
//objCmnDocument.DocumentName = fileNames[i].ToString();
string extension = System.IO.Path.GetExtension(fileNames[i - 1].ToString());
objCmnDocument.DocumentName = newLCRefNo + "_Doc_" + i + extension;
objCmnDocument.TransactionID = LCInfo.LCID;
objCmnDocument.TransactionTypeID = 1;
objCmnDocument.CompanyID = LCInfo.CompanyID;
objCmnDocument.CreateBy = LCInfo.CreateBy;
objCmnDocument.CreateOn = DateTime.Now;
objCmnDocument.CreatePc = HostService.GetIP();
objCmnDocument.IsDeleted = false;
objCmnDocument.IsDeleted = false;
lstCmnDocument.Add(objCmnDocument);
DocumentID++;
}
GenericFactory_CmnDocument.InsertList(lstCmnDocument);
GenericFactory_CmnDocument.Save();
GenericFactory_CmnDocument.updateMaxID("CmnDocument", Convert.ToInt64(DocumentID - 1));
//**********----------------------File upload completed----------------------**********
transaction.Complete();
result = newLCRefNo;
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
}
#endregion Amendment Block
#region New LC Block
else
{
using (TransactionScope transaction = new TransactionScope())
{
//////////////////////////////////////////Primary Key and Custom Code Strat//////////////////////////////////
////start new maxId
//int NextId = Convert.ToInt16(GenericFactory_SalLCMaster.getMaxID("SalLCMaster"));
//int nextDetailId = Convert.ToInt16(GenericFactory_SalLCDetail.getMaxID("SalLCDetail"));
////end new maxId
//...........START new maxId........//
NextId = Convert.ToInt64(GenericFactory_SalLCMaster.getMaxID("SalLCMaster"));
nextDetailId = Convert.ToInt64(GenericFactory_SalLCDetail.getMaxID("SalLCDetail"));
FirstDigit = Convert.ToInt64(nextDetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(nextDetailId.ToString().Substring(1, nextDetailId.ToString().Length - 1));
//..........END new maxId.........//
//// start for custom code
//string customCode = "";
//CmnCustomCode objCustomCode = GFactory_EF_CmnCustomCode.FindBy(m => m.MenuID == 25 && m.CompanyID == LCInfo.CompanyID).FirstOrDefault();
//int customCodeID = Convert.ToInt16(objCustomCode.RecordID);
//if (customCodeID > 0)
//{
// customCode = GenericFactory_SalLCMaster.getCustomCode(customCodeID, DateTime.Now, LCInfo.CompanyID, 1, 1);
//}
//else
//{
// customCode = NextId.ToString();
//}
//// end for custom code
//......... START for custom code........... //
string customCode = "";
string CustomNo = customCode = GenericFactory_SalLCMaster.getCustomCode(objcmnParam.menuId, LCInfo.LCDate ?? DateTime.Now, LCInfo.CompanyID, 1, 1);// // 1 for user id and 1 for db id --- work later
if (CustomNo != null)
{
customCode = CustomNo;
}
else
{
customCode = NextId.ToString();
}
//.........END for custom code............ //
//////////////////////////////////////////Primary Key and Custom Code End//////////////////////////////////
try
{
LCInfo.LCID = NextId;
LCInfo.CreateOn = DateTime.Now;
if (LCInfo.MasterLCNO != "")
{
LCInfo.IsMasterLC = true;
}
else
{
LCInfo.IsMasterLC = false;
}
LCInfo.IsActive = true;
LCInfo.LCReferenceNo = customCode;
LCInfo.AmendmentNo = "0";
LCInfo.IsHDOCompleted = false;
string ImagePath = string.Empty;
//if (string.IsNullOrEmpty(ImagePath) && !string.IsNullOrEmpty(LCInfo.ImageNames))
//{
// //ImagePath=utils
//}
List <SalLCDetail> lstSalLCDetail = new List <SalLCDetail>();
foreach (SalLCDetail sdtl in LCDetailList)
{
SalLCDetail objSalLCDetail = new SalLCDetail();
//objSalLCDetail.LCDetailID = nextDetailId;
objSalLCDetail.LCDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits);
objSalLCDetail.LCID = NextId;
objSalLCDetail.PIID = sdtl.PIID;
objSalLCDetail.PINo = sdtl.PINo;
objSalLCDetail.CustomCode = LCInfo.LCReferenceNo;
objSalLCDetail.LCReferenceNo = LCInfo.LCReferenceNo;
objSalLCDetail.IsHDOCompleted = false;
objSalLCDetail.CompanyID = LCInfo.CompanyID;
objSalLCDetail.CreateBy = LCInfo.CreateBy;
objSalLCDetail.CreateOn = DateTime.Now;
objSalLCDetail.CreatePc = HostService.GetIP();
objSalLCDetail.IsActive = true;
objSalLCDetail.IsDeleted = false;
objSalLCDetail.DBID = 1;
objSalLCDetail.StatusBy = 1;
objSalLCDetail.StatusID = 1;
lstSalLCDetail.Add(objSalLCDetail);
OtherDigits++;
}
//foreach (SalLCDetail sdtl in LCDetailList)
//{
// SalPIMaster objSalPIMaster = GenericFactory_EF_SalPIMaster.FindBy(m => m.PIID == sdtl.PIID).FirstOrDefault();
// objSalPIMaster.IsLcCompleted = true;
// GenericFactory_EF_SalPIMaster.Update(objSalPIMaster);
// GenericFactory_EF_SalPIMaster.Save();
//}
/////////////////////// Start PI Table Update /////////////////////////////
foreach (SalLCDetail sdtl in LCDetailList)
{
SalPIMaster objSalPIMaster = GenericFactory_EF_SalPIMaster.FindBy(m => m.PIID == sdtl.PIID).FirstOrDefault();
objSalPIMaster.IsLcCompleted = true;
GenericFactory_EF_SalPIMaster.Update(objSalPIMaster);
GenericFactory_EF_SalPIMaster.Save();
}
/////////////////////// End PI Table Update /////////////////////////////
/////////////////////// Start Booking Table Update /////////////////////////////
foreach (SalLCDetail sdtl in LCDetailList)
{
SalPIMaster objSalPIMaster = GenericFactory_EF_SalPIMaster.FindBy(m => m.PIID == sdtl.PIID).FirstOrDefault();
SalBookingMaster objBookingMaster = GenericFactory_EF_SalBookingMaster.FindBy(m => m.BookingID ==
objSalPIMaster.BookingID).FirstOrDefault();
objBookingMaster.IsLCCompleted = true;
GenericFactory_EF_SalBookingMaster.Update(objBookingMaster);
GenericFactory_EF_SalBookingMaster.Save();
}
/////////////////////// End Booking Table Update /////////////////////////////
GenericFactory_SalLCMaster.Insert(LCInfo);
GenericFactory_SalLCMaster.Save();
GenericFactory_SalLCMaster.updateMaxID("SalLCMaster", Convert.ToInt64(NextId));
GenericFactory_SalLCMaster.updateCustomCode(25, DateTime.Now, LCInfo.CompanyID, 1, 1);
GenericFactory_SalLCDetail.InsertList(lstSalLCDetail);
GenericFactory_SalLCDetail.Save();
//GenericFactory_SalLCDetail.updateMaxID("SalLCDetail", Convert.ToInt64(nextDetailId - 1));
GenericFactory_SalLCDetail.updateMaxID("SalLCDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
////////////////////////////////////////Start File Upload//////////////////////////////
int DocumentID = Convert.ToInt16(GenericFactory_CmnDocument.getMaxID("CmnDocument"));
List <CmnDocument> lstCmnDocument = new List <CmnDocument>();
for (int i = 1; i <= fileNames.Count; i++)
{
CmnDocument objCmnDocument = new CmnDocument();
objCmnDocument.DocumentID = DocumentID;
objCmnDocument.DocumentPahtID = 1;
//objCmnDocument.DocumentName = fileNames[i].ToString();
string extension = System.IO.Path.GetExtension(fileNames[i - 1].ToString());
objCmnDocument.DocumentName = customCode + "_Doc_" + i + extension;
objCmnDocument.TransactionID = LCInfo.LCID;
objCmnDocument.TransactionTypeID = 1;
objCmnDocument.CompanyID = LCInfo.CompanyID;
objCmnDocument.CreateBy = LCInfo.CreateBy;
objCmnDocument.CreateOn = DateTime.Now;
objCmnDocument.CreatePc = HostService.GetIP();
objCmnDocument.IsDeleted = false;
objCmnDocument.IsDeleted = false;
lstCmnDocument.Add(objCmnDocument);
DocumentID++;
}
GenericFactory_CmnDocument.InsertList(lstCmnDocument);
GenericFactory_CmnDocument.Save();
GenericFactory_CmnDocument.updateMaxID("CmnDocument", Convert.ToInt64(DocumentID - 1));
///////////////////////////////////////////////File upload completed/////////////////////////////////////////////
transaction.Complete();
result = customCode;
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
}
#endregion New LC Block
return(result);
}
public string SaveUpdateMachineMaintenanceOrder(vmPrdWeavingMachineConfigMasterDetail model, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (TransactionScope transaction = new TransactionScope())
{
GenericFactory_MntMachineMaintenanceOrder_EF = new MntMachineMaintenanceOrder_EF();
GenericFactory_WeavingMachinConfig_EF = new PrdWeavingMachinConfig_EF();
long MainId = 0; string CustomNo = string.Empty, MaintenanceNo = string.Empty;
var umodel = new MntMachineMaintenanceOrder();
var uConfig = new PrdWeavingMachinConfig();
try
{
if (model.MaintenanceID > 0)
{
umodel = GenericFactory_MntMachineMaintenanceOrder_EF.GetAll().Where(x => x.MaintenanceID == model.MaintenanceID).FirstOrDefault();
umodel.MachineConfigID = model.MachineConfigID;
umodel.DepartmentID = model.DepartmentID;
umodel.EmployeeID = objcmnParam.loggeduser;
umodel.Reason = model.Reason;
umodel.MaintenanceDate = model.MaintenanceDate;
umodel.CompanyID = objcmnParam.loggedCompany;
umodel.UpdateBy = objcmnParam.loggeduser;
umodel.UpdateOn = DateTime.Now;
umodel.UpdatePc = HostService.GetIP();
}
else
{
MainId = Convert.ToInt16(GenericFactory_MntMachineMaintenanceOrder_EF.getMaxID("MntMachineMaintenanceOrder"));
CustomNo = GenericFactory_MntMachineMaintenanceOrder_EF.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
if (CustomNo == null || CustomNo == "")
{
MaintenanceNo = MainId.ToString();
}
else
{
MaintenanceNo = CustomNo;
}
umodel = new MntMachineMaintenanceOrder()
{
MaintenanceID = (int)MainId,
MaintenanceNo = MaintenanceNo,
MachineConfigID = model.MachineConfigID,
DepartmentID = model.DepartmentID,
EmployeeID = objcmnParam.loggeduser,
Reason = model.Reason,
IsMaintenance = true,
MaintenanceDate = model.MaintenanceDate,
IsDeleted = false,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP()
};
}
uConfig = GenericFactory_WeavingMachinConfig_EF.GetAll().Where(x => x.MachineConfigID == model.MachineConfigID).FirstOrDefault();
uConfig.IsMaintenance = true;
if (model.MaintenanceID > 0)
{
GenericFactory_MntMachineMaintenanceOrder_EF.Update(umodel);
GenericFactory_MntMachineMaintenanceOrder_EF.Save();
}
else
{
GenericFactory_MntMachineMaintenanceOrder_EF.Insert(umodel);
GenericFactory_MntMachineMaintenanceOrder_EF.Save();
GenericFactory_MntMachineMaintenanceOrder_EF.updateMaxID("MntMachineMaintenanceOrder", Convert.ToInt64(MainId));
GenericFactory_MntMachineMaintenanceOrder_EF.updateCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
}
if (uConfig != null)
{
GenericFactory_WeavingMachinConfig_EF.Update(uConfig);
GenericFactory_WeavingMachinConfig_EF.Save();
}
transaction.Complete();
result = umodel.MaintenanceNo;
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
return(result);
}
public string SaveUpdateWeavingMasterDetail(vmPrdWeavingMachineConfigMasterDetail Master, List <vmPrdWeavingMachineConfigMasterDetail> Detail, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (var transaction = new TransactionScope())
{
//*********************************************Start Initialize Variable*****************************************
long MasterId = 0, DetailId = 0, FirstDigit = 0, OtherDigits = 0;
//***************************************End Initialize Variable*************************************************
//**************************Start Initialize Generic Repository Based on table***********************************
GenericFactory_PrdWeavingMachinConfig_EF = new PrdWeavingMachinConfig_EF();
GenericFactory_PrdWeavingMachineConfigDetail_EF = new PrdWeavingMachineConfigDetail_EF();
//****************************End Initialize Generic Repository Based on table***********************************
//**********************************Start Create Related Table Instance to Save**********************************
var MasterItem = new PrdWeavingMachinConfig();
var DetailItem = new List <PrdWeavingMachineConfigDetail>();
var DetailItems = new List <PrdWeavingMachineConfigDetail>();
//************************************End Create Related Table Instance to Save**********************************
//*************************************Start Create Model Instance to get Data***********************************
vmPrdWeavingMachineConfigMasterDetail item = new vmPrdWeavingMachineConfigMasterDetail();
vmPrdWeavingMachineConfigMasterDetail items = new vmPrdWeavingMachineConfigMasterDetail();
PrdWeavingMachineConfigDetail itemdel = new PrdWeavingMachineConfigDetail();
//***************************************End Create Model Instance to get Data***********************************
var SDetail = Detail.Where(x => x.MachineConfigDetailID == 0).ToList();
var UDetail = Detail.Where(x => x.MachineConfigDetailID != 0).ToList();
//**************************************************Start Main Operation************************************************
if (Detail.Count > 0)
{
try
{
if (Master.MachineConfigID == 0)
{
//***************************************************Start Save Operation************************************************
//**********************************************Start Generate Master & Detail ID****************************************
MasterId = Convert.ToInt16(GenericFactory_PrdWeavingMachinConfig_EF.getMaxID("PrdWeavingMachinConfig"));
DetailId = Convert.ToInt64(GenericFactory_PrdWeavingMachineConfigDetail_EF.getMaxID("PrdWeavingMachineConfigDetail"));
FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1));
//***********************************************End Generate Master & Detail ID*****************************************
MasterItem = new PrdWeavingMachinConfig
{
MachineConfigID = (int)MasterId,
MachineConfigNo = Master.MachineConfigNo,
Remarks = Master.Remarks,
DepartmentID = Master.DepartmentID,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false,
IsBook = false,
IsCorrupted = false,
IsMaintenance = false
};
for (int i = 0; i < Detail.Count; i++)
{
item = Detail[i];
var Detailitem = new PrdWeavingMachineConfigDetail
{
MachineConfigDetailID = Convert.ToInt32(FirstDigit + "" + OtherDigits),
MachineConfigID = (int)MasterId,
MachineID = (long)item.MachineID,
Description = item.Description,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
DetailItem.Add(Detailitem);
OtherDigits++;
}
//***************************************************End Save Operation************************************************
}
else
{
//***********************************Start Get Data From Related Table to Update*********************************
var MasterAll = GenericFactory_PrdWeavingMachinConfig_EF.GetAll().Where(x => x.MachineConfigID == Master.MachineConfigID && x.CompanyID == objcmnParam.loggedCompany);
var DetailAll = GenericFactory_PrdWeavingMachineConfigDetail_EF.GetAll().Where(x => x.MachineConfigID == Master.MachineConfigID && x.CompanyID == objcmnParam.loggedCompany).ToArray();
//*************************************End Get Data From Related Table to Update*********************************
//***************************************************Start Update Operation********************************************
MasterItem = MasterAll.First(x => x.MachineConfigID == Master.MachineConfigID);
MasterItem.MachineConfigNo = Master.MachineConfigNo;
MasterItem.DepartmentID = Master.DepartmentID;
MasterItem.Remarks = Master.Remarks;
MasterItem.CompanyID = objcmnParam.loggedCompany;
MasterItem.UpdateBy = objcmnParam.loggeduser;
MasterItem.UpdateOn = DateTime.Now;
MasterItem.UpdatePc = HostService.GetIP();
MasterItem.IsDeleted = false;
for (int i = 0; i < UDetail.Count; i++)
{
item = UDetail[i];
foreach (PrdWeavingMachineConfigDetail d in DetailAll.Where(d => d.MachineConfigID == Master.MachineConfigID && d.MachineConfigDetailID == item.MachineConfigDetailID))
{
d.MachineID = (long)item.MachineID;
d.Description = item.Description;
d.CompanyID = objcmnParam.loggedCompany;
d.UpdateBy = objcmnParam.loggeduser;
d.UpdateOn = DateTime.Now;
d.UpdatePc = HostService.GetIP();
d.IsDeleted = false;
DetailItem.Add(d);
break;
}
}
if (SDetail != null && SDetail.Count != 0)
{
for (int i = 0; i < SDetail.Count; i++)
{
item = SDetail[i];
DetailId = Convert.ToInt64(GenericFactory_PrdWeavingMachineConfigDetail_EF.getMaxID("PrdWeavingMachineConfigDetail"));
FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1));
var Detailitems = new PrdWeavingMachineConfigDetail
{
MachineConfigDetailID = Convert.ToInt32(FirstDigit + "" + OtherDigits),
MachineConfigID = (long)Master.MachineConfigID,
MachineID = (long)item.MachineID,
Description = item.Description,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
DetailItems.Add(Detailitems);
GenericFactory_PrdWeavingMachineConfigDetail_EF.updateMaxID("PrdWeavingMachineConfigDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits)));
}
}
if (UDetail.Count < DetailAll.Count())
{
for (int i = 0; i < DetailAll.Count(); i++)
{
itemdel = DetailAll[i];
var delDetail = (from del in DetailItem.Where(x => x.MachineConfigDetailID == itemdel.MachineConfigDetailID) select del.MachineConfigDetailID).FirstOrDefault();
if (delDetail != itemdel.MachineConfigDetailID)
{
var tem = DetailAll.FirstOrDefault(d => d.MachineConfigID == Master.MachineConfigID && d.MachineConfigDetailID == itemdel.MachineConfigDetailID);
tem.CompanyID = objcmnParam.loggedCompany;
tem.DeleteBy = objcmnParam.loggeduser;
tem.DeleteOn = DateTime.Now;
tem.DeletePc = HostService.GetIP();
tem.IsDeleted = true;
DetailItem.Add(tem);
}
}
}
//***************************************************End Update Operation********************************************
}
if (Master.MachineConfigID > 0)
{
//***************************************************Start Update************************************************
if (MasterItem != null)
{
GenericFactory_PrdWeavingMachinConfig_EF.Update(MasterItem);
GenericFactory_PrdWeavingMachinConfig_EF.Save();
}
if (DetailItem != null && DetailItem.Count != 0)
{
GenericFactory_PrdWeavingMachineConfigDetail_EF.UpdateList(DetailItem.ToList());
GenericFactory_PrdWeavingMachineConfigDetail_EF.Save();
}
if (DetailItems != null && DetailItems.Count != 0)
{
GenericFactory_PrdWeavingMachineConfigDetail_EF.InsertList(DetailItems.ToList());
GenericFactory_PrdWeavingMachineConfigDetail_EF.Save();
}
//***************************************************End Update************************************************
}
else
{
//***************************************************Start Save************************************************
if (MasterItem != null)
{
GenericFactory_PrdWeavingMachinConfig_EF.Insert(MasterItem);
GenericFactory_PrdWeavingMachinConfig_EF.Save();
GenericFactory_PrdWeavingMachinConfig_EF.updateMaxID("PrdWeavingMachinConfig", Convert.ToInt64(MasterId));
}
if (DetailItem != null && DetailItem.Count != 0)
{
GenericFactory_PrdWeavingMachineConfigDetail_EF.InsertList(DetailItem.ToList());
GenericFactory_PrdWeavingMachineConfigDetail_EF.Save();
GenericFactory_PrdWeavingMachineConfigDetail_EF.updateMaxID("PrdWeavingMachineConfigDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
}
//******************************************************End Save************************************************
}
transaction.Complete();
result = MasterItem.MachineConfigNo;
}
catch (Exception e)
{
result = "";
e.ToString();
}
}
else
{
result = "";
}
}
return(result);
//**************************************************End Main Operation************************************************
}
public string SaveWeavingMachineConfi(PrdWeavingMachinConfig model, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (TransactionScope transaction = new TransactionScope())
{
GenericFactory_EFWeavingMachinConfig = new PrdWeavingMachinConfig_EF();
long MainId = 0; string CustomNo = string.Empty, ConfigNo = string.Empty;
var WeavingMachine = new PrdWeavingMachinConfig();
try
{
if (model.MachineConfigID > 0)
{
WeavingMachine = GenericFactory_EFWeavingMachinConfig.GetAll().Where(x => x.MachineConfigID == model.MachineConfigID).FirstOrDefault();
WeavingMachine.MachineConfigNo = model.MachineConfigNo;
WeavingMachine.MachineID = model.MachineID;
WeavingMachine.LineID = model.LineID;
WeavingMachine.DepartmentID = model.DepartmentID;
WeavingMachine.Remarks = model.Remarks;
WeavingMachine.CompanyID = objcmnParam.loggedCompany;
WeavingMachine.UpdateBy = objcmnParam.loggeduser;
WeavingMachine.UpdateOn = DateTime.Now;
WeavingMachine.UpdatePc = HostService.GetIP();
//ConfigNo = WeavingMachine.MachineConfigNo;
}
else
{
MainId = Convert.ToInt16(GenericFactory_EFWeavingMachinConfig.getMaxID("PrdWeavingMachinConfig"));
CustomNo = GenericFactory_EFWeavingMachinConfig.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
//if (CustomNo == null || CustomNo == "")
//{
// ConfigNo = MainId.ToString();
//}
//else
//{
// ConfigNo = CustomNo;
//}
WeavingMachine = new PrdWeavingMachinConfig()
{
MachineConfigID = (int)MainId,
MachineConfigNo = model.MachineConfigNo,//ConfigNo.ToString(),
MachineID = model.MachineID,
DepartmentID = model.DepartmentID,
LineID = model.LineID,
Remarks = model.Remarks,
IsBook = false,
IsCorrupted = false,
IsMaintenance = false,
IsDeleted = false,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP()
};
}
if (model.MachineConfigID > 0)
{
GenericFactory_EFWeavingMachinConfig.Update(WeavingMachine);
GenericFactory_EFWeavingMachinConfig.Save();
}
else
{
GenericFactory_EFWeavingMachinConfig.Insert(WeavingMachine);
GenericFactory_EFWeavingMachinConfig.Save();
GenericFactory_EFWeavingMachinConfig.updateMaxID("PrdWeavingMachinConfig", Convert.ToInt64(MainId));
GenericFactory_EFWeavingMachinConfig.updateCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
}
transaction.Complete();
result = model.MachineConfigNo;
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
return(result);
}
public string SaveUpdateChallanMasterNdetails(InvRChallanMaster chMaster, List <InvRChallanDetail> chDetails, int menuID)
{
_ctxCmn = new ERP_Entities();
GenericFactory_EF_CmnCombo = new CmnCombo_EF();
string result = "";
if (chMaster.CHID > 0)
{
using (TransactionScope transaction = new TransactionScope())
{
try
{
Int64 chID = chMaster.CHID;
IEnumerable <InvRChallanMaster> lstInvRChallanMaster = (from qcm in _ctxCmn.InvRChallanMasters.Where(m => m.CHID == chID) select qcm).ToList();
InvRChallanMaster objInvRChallanMaster = new InvRChallanMaster();
foreach (InvRChallanMaster qcms in lstInvRChallanMaster)
{
qcms.UpdateBy = chMaster.CreateBy;
qcms.UpdateOn = DateTime.Now;
qcms.UpdatePc = HostService.GetIP();
qcms.CHID = chMaster.CHID;
qcms.CurrencyID = chMaster.CurrencyID;
qcms.CompanyID = chMaster.CompanyID;
qcms.CHDate = chMaster.CHDate;
qcms.CHTypeID = chMaster.CHTypeID;
qcms.DepartmentID = chMaster.DepartmentID;
qcms.DischargePortID = chMaster.DischargePortID;
qcms.IsDeleted = false;
qcms.LoadingPortID = chMaster.LoadingPortID;
qcms.PartyID = chMaster.PartyID;
qcms.PIID = chMaster.PIID;
qcms.POID = chMaster.POID;
qcms.RefCHDate = chMaster.RefCHDate;
qcms.RefCHNo = chMaster.RefCHNo;
qcms.Remarks = chMaster.Remarks;
qcms.TransactionTypeID = chMaster.TransactionTypeID;
qcms.TypeID = chMaster.TypeID;
objInvRChallanMaster = qcms;
}
List <InvRChallanDetail> lstInvRChallanDetail = new List <InvRChallanDetail>();
foreach (InvRChallanDetail qcdt in chDetails)
{
InvRChallanDetail objInvRChallanDetail = (from qcdetl in _ctxCmn.InvRChallanDetails.Where(m => m.CHDetailID == qcdt.CHDetailID) select qcdetl).FirstOrDefault();
//start for exist passed n reject qty
// decimal? prePassedRejectQty = objInvMrrQcDetail.PassQty + objInvMrrQcDetail.RejectQty;
//end for exist passed n reject qty
objInvRChallanDetail.AditionalQty = qcdt.AditionalQty;
objInvRChallanDetail.DisAmount = qcdt.DisAmount;
objInvRChallanDetail.IsPercent = qcdt.IsPercent;
objInvRChallanDetail.TotalAmount = qcdt.TotalAmount;
objInvRChallanDetail.Amount = qcdt.Amount;
objInvRChallanDetail.BatchID = qcdt.BatchID;
objInvRChallanDetail.IsDeleted = false;
objInvRChallanDetail.GrossWeight = qcdt.GrossWeight;
objInvRChallanDetail.ItemID = qcdt.ItemID;
objInvRChallanDetail.LotID = qcdt.LotID;
objInvRChallanDetail.NetWeight = qcdt.NetWeight;
objInvRChallanDetail.PackingQty = qcdt.PackingQty;
objInvRChallanDetail.PackingUnitID = qcdt.PackingUnitID;
objInvRChallanDetail.Qty = qcdt.Qty;
objInvRChallanDetail.UnitID = qcdt.UnitID;
objInvRChallanDetail.UnitPrice = qcdt.UnitPrice;
objInvRChallanDetail.WeightUnitID = qcdt.WeightUnitID;
objInvRChallanDetail.UpdateBy = chMaster.CreateBy;
objInvRChallanDetail.UpdateOn = DateTime.Now;
objInvRChallanDetail.UpdatePc = HostService.GetIP();
lstInvRChallanDetail.Add(objInvRChallanDetail);
//InvGrrDetail objInvGrrDetail = (from grrd in _ctxCmn.InvGrrDetails.Where(m => m.GrrID == qcMaster.GrrID && m.ItemID == qcdt.ItemID) select grrd).FirstOrDefault();
//objInvGrrDetail.QcRemainingQty = (objInvGrrDetail.QcRemainingQty + prePassedRejectQty) - (qcdt.PassQty + qcdt.RejectQty);
}
_ctxCmn.SaveChanges();
transaction.Complete();
result = chMaster.CHNo.ToString();
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
}
else
{
using (TransactionScope transaction = new TransactionScope())
{
try
{
//...........START new maxId...............//
long NextId = Convert.ToInt16(GenericFactory_EF_CmnCombo.getMaxID("InvRChallanMaster"));
long FirstDigit = 0;
long OtherDigits = 0;
long nextChDetailId = Convert.ToInt16(GenericFactory_EF_CmnCombo.getMaxID("InvRChallanDetail"));
FirstDigit = Convert.ToInt64(nextChDetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(nextChDetailId.ToString().Substring(1, nextChDetailId.ToString().Length - 1));
//..........END new maxId....................//
//......... START for custom code........... //
string customCode = "";
string CustomNo = GenericFactory_EF_CmnCombo.getCustomCode(menuID, DateTime.Now, chMaster.CompanyID ?? 1, 1, 1);
if (CustomNo != null)
{
customCode = CustomNo;
}
else
{
customCode = NextId.ToString();
}
//.........END for custom code............ //
string newChNo = customCode;
chMaster.CHID = NextId;
chMaster.CreateOn = DateTime.Now;
chMaster.CreatePc = HostService.GetIP();
chMaster.CHNo = newChNo;
chMaster.IsDeleted = false;
// itemMaster.IsHDOCompleted = false;
// itemMaster.IsLcCompleted = false;
List <InvRChallanDetail> lstchDetail = new List <InvRChallanDetail>();
foreach (InvRChallanDetail sdtl in chDetails)
{
InvRChallanDetail objchDetail = new InvRChallanDetail();
objchDetail.CHDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits);//nextQCDetailId;
objchDetail.CHID = NextId;
objchDetail.AditionalQty = sdtl.AditionalQty;
objchDetail.DisAmount = sdtl.DisAmount;
objchDetail.IsPercent = sdtl.IsPercent;
objchDetail.TotalAmount = sdtl.TotalAmount;
objchDetail.ItemID = sdtl.ItemID;
objchDetail.BatchID = sdtl.BatchID;
objchDetail.GrossWeight = sdtl.GrossWeight;
objchDetail.LotID = sdtl.LotID;
objchDetail.NetWeight = sdtl.NetWeight;
objchDetail.PackingQty = sdtl.PackingQty;
objchDetail.PackingUnitID = sdtl.PackingUnitID;
objchDetail.UnitID = sdtl.UnitID;
objchDetail.UnitPrice = sdtl.UnitPrice;
objchDetail.WeightUnitID = sdtl.WeightUnitID;
objchDetail.Qty = sdtl.Qty;
objchDetail.IsDeleted = false;
objchDetail.Amount = sdtl.Amount;
objchDetail.UnitID = sdtl.UnitID;
objchDetail.CreateBy = chMaster.CreateBy;
objchDetail.CreateOn = DateTime.Now;
objchDetail.CreatePc = HostService.GetIP();
// objSalPIDetail.IsCICompleted = false;
lstchDetail.Add(objchDetail);
//nextQCDetailId++;
OtherDigits++;
// InvGrrDetail objInvGrrDetail = (from grrd in _ctxCmn.InvGrrDetails.Where(m => m.GrrID == qcMaster.GrrID && m.ItemID == sdtl.ItemID) select grrd).FirstOrDefault();
// objInvGrrDetail.QcRemainingQty = objInvGrrDetail.QcRemainingQty - (sdtl.PassQty + sdtl.RejectQty);
}
_ctxCmn.InvRChallanMasters.Add(chMaster);
//............Update MaxID.................//
GenericFactory_EF_CmnCombo.updateMaxID("InvRChallanMaster", Convert.ToInt64(NextId));
//............Update CustomCode.............//
GenericFactory_EF_CmnCombo.updateCustomCode(menuID, DateTime.Now, chMaster.CompanyID ?? 1, 1, 1);
_ctxCmn.InvRChallanDetails.AddRange(lstchDetail);
//............Update MaxID.................//
GenericFactory_EF_CmnCombo.updateMaxID("InvRChallanDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
_ctxCmn.SaveChanges();
transaction.Complete();
result = newChNo;
}
catch (Exception e)
{
result = "";
}
}
}
return(result);
}
public string SaveUpdateCountWiseMachineSetup(vmPrdBallMachineSetup model)
{
string result = string.Empty;
using (TransactionScope transaction = new TransactionScope())
{
GFactory_EF_PrdBallMachineSetup = new PrdBallMachineSetup_EF();
int BallMachineSetupID = 0;
var BallMachineSetup = new PrdBallMachineSetup();
var AllMachineSetup = GFactory_EF_PrdBallMachineSetup.GetAll();
try
{
//using (_ctxCmn = new ERP_Entities())
//{
if (model.BallMachineSetupID > 0)
{
BallMachineSetup = AllMachineSetup.FirstOrDefault(x => x.BallMachineSetupID == model.BallMachineSetupID);
if (model.IsDeleted != false)
{
BallMachineSetup.CompanyID = (int)model.LCompanyID;
BallMachineSetup.DeleteBy = (int)model.LUserID;
BallMachineSetup.IsDeleted = model.IsDeleted;
BallMachineSetup.DeleteOn = DateTime.Now;
BallMachineSetup.DeletePc = HostService.GetIP();
}
else
{
BallMachineSetup.Count = (int)model.Count;
BallMachineSetup.Jog = model.Jog;
BallMachineSetup.RFront = model.RFront;
BallMachineSetup.RRear = model.RRear;
BallMachineSetup.Agm = model.Agm;
BallMachineSetup.Empty = model.Empty;
BallMachineSetup.Speed = model.Speed;
BallMachineSetup.CompanyID = (int)model.LCompanyID;
BallMachineSetup.UpdateBy = (int)model.LUserID;
BallMachineSetup.UpdateOn = DateTime.Now;
BallMachineSetup.UpdatePc = HostService.GetIP();
BallMachineSetup.IsDeleted = false;
}
GFactory_EF_PrdBallMachineSetup.Update(BallMachineSetup);
GFactory_EF_PrdBallMachineSetup.Save();
}
else
{
BallMachineSetupID = Convert.ToInt16(GFactory_EF_PrdBallMachineSetup.getMaxID("PrdBallMachineSetup"));
BallMachineSetup = new PrdBallMachineSetup
{
BallMachineSetupID = BallMachineSetupID,
Count = (int)model.Count,
Jog = model.Jog,
RFront = model.RFront,
RRear = model.RRear,
Agm = model.Agm,
Empty = model.Empty,
Speed = model.Speed,
CompanyID = (int)model.LCompanyID,
CreateBy = (int)model.LUserID,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
GFactory_EF_PrdBallMachineSetup.Insert(BallMachineSetup);
GFactory_EF_PrdBallMachineSetup.Save();
GFactory_EF_PrdBallMachineSetup.updateMaxID("PrdBallMachineSetup", Convert.ToInt64(BallMachineSetupID));
}
transaction.Complete();
result = BallMachineSetup.Count.ToString();
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
return(result);
}
