private void UpdateSalesInvoiceMaster(SalSalesInvoiceMaster Master, List <vmLSalesInvoiceDetail> UpdatetList)
{
GFactory_EF_SalSalesInvoiceDetails = new SalSalesInvoiceDetail_EF();
foreach (vmLSalesInvoiceDetail aitem in UpdatetList)
{
SalSalesInvoiceDetail _aitem = GFactory_EF_SalSalesInvoiceDetails.FindBy(x => x.SIDetailID == aitem.SIDetailID).FirstOrDefault();
_aitem.SIID = Master.SIID;
_aitem.ItemID = aitem.ItemID;
_aitem.BatchID = aitem.BatchID;
_aitem.LotID = aitem.LotID;
_aitem.GradeID = aitem.GradeID;
_aitem.SupplierID = aitem.SupplierID;
_aitem.UnitID = aitem.UnitID;
_aitem.UnitPrice = aitem.UnitPrice;
_aitem.Qty = aitem.Qty;
_aitem.Amount = aitem.Amount;
_aitem.Remarks = aitem.Remarks;
_aitem.CompanyID = Master.CompanyID;
_aitem.UpdateBy = Master.CreateBy;
_aitem.UpdateOn = DateTime.Today;
_aitem.UpdatePc = HostService.GetIP();
GFactory_EF_SalSalesInvoiceDetails.Update(_aitem);
GFactory_EF_SalSalesInvoiceDetails.Save();
}
}
private void SaveSalesInvoiceDetails(SalSalesInvoiceMaster Master, List <vmLSalesInvoiceDetail> SalesInvoiceDetails)
{
GFactory_EF_SalSalesInvoiceDetails = new SalSalesInvoiceDetail_EF();
long SIDetailID = Convert.ToInt16(GFactory_EF_SalSalesInvoiceDetails.getMaxID("SalSalesInvoiceDetail"));
foreach (vmLSalesInvoiceDetail aitem in SalesInvoiceDetails)
{
SalSalesInvoiceDetail _aitem = new SalSalesInvoiceDetail();
_aitem.SIDetailID = SIDetailID;
_aitem.SIID = Master.SIID;
_aitem.ItemID = aitem.ItemID;
_aitem.BatchID = aitem.BatchID;
_aitem.LotID = aitem.LotID;
_aitem.GradeID = aitem.GradeID;
_aitem.SupplierID = aitem.SupplierID;
_aitem.UnitID = aitem.UnitID;
_aitem.UnitPrice = aitem.UnitPrice;
_aitem.Qty = aitem.Qty;
_aitem.Amount = aitem.Amount;
_aitem.Remarks = aitem.Remarks;
_aitem.CompanyID = Master.CompanyID;
_aitem.CreateBy = Master.CreateBy;
_aitem.CreateOn = DateTime.Today;
_aitem.CreatePc = HostService.GetIP();
_aitem.IsDeleted = false;
GFactory_EF_SalSalesInvoiceDetails.Insert(_aitem);
GFactory_EF_SalSalesInvoiceDetails.Save();
SIDetailID++;
}
GFactory_EF_SalSalesInvoiceDetails.updateMaxID("SalSalesInvoiceDetail", Convert.ToInt64(SIDetailID));
}
private void UpdateSalSalesInvoiceDetail(SalSalesInvoiceMaster Master, List <vmLSalesInvoiceDetail> SalesInvoiceDetails, List <vmLSalesInvoiceDetail> DeleteSalesInvoiceDetails)
{
List <vmLSalesInvoiceDetail> InsertList = new List <vmLSalesInvoiceDetail>();
List <vmLSalesInvoiceDetail> UpdatetList = new List <vmLSalesInvoiceDetail>();
List <SalSalesInvoiceDetail> DelteList = new List <SalSalesInvoiceDetail>();
try
{
if (DeleteSalesInvoiceDetails.Count > 0)
{
vmCmnParameters _cmnParameters = new vmCmnParameters();
foreach (vmLSalesInvoiceDetail aitem in DeleteSalesInvoiceDetails)
{
SalSalesInvoiceDetail _salesInvocieDetails = new SalSalesInvoiceDetail();
_salesInvocieDetails.SIDetailID = aitem.SIDetailID;
DelteList.Add(_salesInvocieDetails);
_cmnParameters.loggeduser = Master.CreateBy ?? 0;
}
DeleteSalSalesInvoiceDetail(DelteList, _cmnParameters);
}
if (SalesInvoiceDetails.Count > 0)
{
InsertList = SalesInvoiceDetails.Where(x => x.Status == "New").ToList();
UpdatetList = SalesInvoiceDetails.Where(x => x.Status == "Update").ToList();
SaveSalesInvoiceDetails(Master, InsertList);
UpdateSalesInvoiceMaster(Master, UpdatetList);
}
}
catch
{
}
}
private void DeleteSalSalesInvoiceDetail(List <SalSalesInvoiceDetail> _SalesInvoiceDetails, vmCmnParameters objcmnParam)
{
GFactory_EF_SalSalesInvoiceDetails = new SalSalesInvoiceDetail_EF();
List <SalSalesInvoiceDetail> UpdateList = new List <SalSalesInvoiceDetail>();
foreach (SalSalesInvoiceDetail aitem in _SalesInvoiceDetails)
{
SalSalesInvoiceDetail _salesInvoiceDetail = GFactory_EF_SalSalesInvoiceDetails.FindBy(x => x.SIDetailID == aitem.SIDetailID).FirstOrDefault();
_salesInvoiceDetail.DeleteOn = DateTime.Today;
_salesInvoiceDetail.DeleteBy = objcmnParam.loggeduser;
_salesInvoiceDetail.DeletePc = HostService.GetIP();
_salesInvoiceDetail.IsDeleted = true;
UpdateList.Add(_salesInvoiceDetail);
}
GFactory_EF_SalSalesInvoiceDetails.UpdateList(UpdateList);
GFactory_EF_SalSalesInvoiceDetails.Save();
}
