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 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 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
{
}
}
public string SaveUpdateSalesInvoice(SalSalesInvoiceMaster Master, List <vmLSalesInvoiceDetail> SalesInvoiceDetails, List <vmLSalesInvoiceDetail> DeleteSalesInvoiceDetails)
{
string result = "";
using (var transaction = new TransactionScope())
{
try
{
if (Master.SIID > 0)
{
UpdateSalesInvoice(Master, SalesInvoiceDetails, DeleteSalesInvoiceDetails);
}
else
{
SaveSalesInvoice(Master, SalesInvoiceDetails);
}
transaction.Complete();
result = "1";
}
catch (Exception)
{
throw;
}
}
return(result);
}
public IHttpActionResult SaveUpdateSalesInvoice(object[] data)
{
objLocalSalesDDDl = new CmnLocalSalesMgt();
string result = string.Empty;
SalSalesInvoiceMaster Master = JsonConvert.DeserializeObject <SalSalesInvoiceMaster>(data[0].ToString());
List <vmLSalesInvoiceDetail> SalesInvoiceDetails = JsonConvert.DeserializeObject <List <vmLSalesInvoiceDetail> >(data[1].ToString());
List <vmLSalesInvoiceDetail> DeleteSalesInvoiceDetails = JsonConvert.DeserializeObject <List <vmLSalesInvoiceDetail> >(data[2].ToString());
try
{
//if (ModelState.IsValid)
//{
result = objLocalSalesDDDl.SaveUpdateSalesInvoice(Master, SalesInvoiceDetails, DeleteSalesInvoiceDetails);
// }
}
catch (Exception e)
{
e.ToString();
result = "0";
}
return(Json(new
{
result
}));
}
private void UpdateSalesInvoice(SalSalesInvoiceMaster Master, List <vmLSalesInvoiceDetail> SalesInvoiceDetails, List <vmLSalesInvoiceDetail> DeleteSalesInvoiceDetails)
{
int Masterresult = UpdateSalPPBillingMaster(Master);
if (Masterresult > 0)
{
UpdateSalSalesInvoiceDetail(Master, SalesInvoiceDetails, DeleteSalesInvoiceDetails);
}
}
private void SaveSalesInvoice(SalSalesInvoiceMaster Master, List <vmLSalesInvoiceDetail> SalesInvoiceDetails)
{
long SIID = SaveSalesInvoiceMaster(Master);
if (SIID > 0)
{
Master.SIID = SIID;
SaveSalesInvoiceDetails(Master, SalesInvoiceDetails);
}
}
private int DeleteSalSalesInvoiceMaster(vmCmnParameters objcmnParam)
{
GFactory_EF_SalSalesInvoiceMaster = new SalSalesInvoiceMaster_EF();
SalSalesInvoiceMaster _SalesInvoiceMaster = GFactory_EF_SalSalesInvoiceMaster.FindBy(x => x.SIID == objcmnParam.id).FirstOrDefault();
_SalesInvoiceMaster.DeleteOn = DateTime.Today;
_SalesInvoiceMaster.DeleteBy = objcmnParam.loggeduser;
_SalesInvoiceMaster.DeletePc = HostService.GetIP();
_SalesInvoiceMaster.IsDeleted = true;
GFactory_EF_SalSalesInvoiceMaster.Update(_SalesInvoiceMaster);
GFactory_EF_SalSalesInvoiceMaster.Save();
return(1);
}
private long SaveSalesInvoiceMaster(SalSalesInvoiceMaster Master)
{
long SIID = 0;
GFactory_EF_SalSalesInvoiceMaster = new SalSalesInvoiceMaster_EF();
SIID = Convert.ToInt16(GFactory_EF_SalSalesInvoiceMaster.getMaxID("SalSalesInvoiceMaster"));
Master.SIID = SIID;
Master.CreateOn = DateTime.Today;
Master.CreatePc = HostService.GetIP();
Master.IsDeleted = false;
GFactory_EF_SalSalesInvoiceMaster.Insert(Master);
GFactory_EF_SalSalesInvoiceMaster.Save();
GFactory_EF_SalSalesInvoiceMaster.updateMaxID("SalSalesInvoiceMaster", Convert.ToInt64(SIID));
return(SIID);
}
private int UpdateSalPPBillingMaster(SalSalesInvoiceMaster Master)
{
int result = 0;
try
{
GFactory_EF_SalSalesInvoiceMaster = new SalSalesInvoiceMaster_EF();
SalSalesInvoiceMaster _salesInvoiceMaster = GFactory_EF_SalSalesInvoiceMaster.FindBy(x => x.SIID == Master.SIID).FirstOrDefault();
_salesInvoiceMaster.UpdateOn = DateTime.Today;
_salesInvoiceMaster.UpdatePc = HostService.GetIP();
_salesInvoiceMaster.UpdateBy = Master.UserID;
GFactory_EF_SalSalesInvoiceMaster.Update(_salesInvoiceMaster);
GFactory_EF_SalSalesInvoiceMaster.Save();
result = 1;
}
catch
{
result = 0;
}
return(result);
}
