public bool UpdateSalesReturn(ITN_ORDN objITN_ORDN)
{
int updateRows = this.dbConnection.Execute($@"UPDATE ITN_ORDN SET InvoiceType='{objITN_ORDN.InvoiceType}',PANVATNumber='{objITN_ORDN.PANVATNumber}' ,CustomerName='{objITN_ORDN.CustomerName}', CustomerCode='{objITN_ORDN.CustomerCode}' , Branch='{objITN_ORDN.Branch}',ReferenceNo='{objITN_ORDN.ReferenceNo}',Email='{objITN_ORDN.Email}',DocumentNo='{objITN_ORDN.DocumentNo}',Status='{objITN_ORDN.Status}',Postingdate={objITN_ORDN.Postingdate},ContactPerson={objITN_ORDN.ContactPerson},DocumentOwner='{objITN_ORDN.DocumentOwner}',TotalBeforeDiscount={objITN_ORDN.TotalBeforeDiscount},DiscountPercent={objITN_ORDN.DiscountPercent},Discount={objITN_ORDN.Discount},TaxAmount={objITN_ORDN.TaxAmount},TotalAmount={objITN_ORDN.TotalAmount},Remarks='{objITN_ORDN.Remarks}',,BaseEntry='{objITN_ORDN.BaseEntry}',UpdatedDate={DateTime.Now},UpdatedBy='ADMIN'");
if (updateRows > 0)
{
int serialNo = 1;
foreach (var data in objITN_ORDN.ITN_RDN1)
{
this.dbConnection.Execute($@"UPDATE ITN_RDN1 SET ItemDescription='{data.ItemDescription}',ItemCode='{data.ItemCode}',Quantity={data.Quantity},ReturnQuantity={data.ReturnQuantity},UnitPrice={data.UnitPrice},DiscountPercent={data.DiscountPercent},TaxCode='{data.TaxCode}',TotalAmount={data.TotalAmount},TaxAmount={data.TotalAmount},Warehouse='{data.Warehouse}',BaseQuantity={data.BaseQuantity},BaseLine={data.BaseLine},UpadtedDate={DateTime.Now},UpdatedBy='ADMIN',DeletedFlag='N',SERIAL_NO={serialNo},BATCH_NO={serialNo}");
serialNo++;
}
return(true);
}
return(false);
}
public bool SaveSalesReturn(ITN_ORDN objITN_ORDN)
{
int insertdata = this.dbConnection.Execute($@"INSERT INTO ITN_ORDN(InvoiceType,PANVATNumber,CustomerName,CustomerCode,Branch,ReferenceNo,Email,DocumentNo,Status,Postingdate,ContactPerson,DocumentOwner,TotalBeforeDiscount,DiscountPercent,Discount,TaxAmount,TotalAmount,Remarks,BaseEntry,CreatedDate,CreatedBy,DeletedFlag) VALUES('{objITN_ORDN.InvoiceType}','{objITN_ORDN.PANVATNumber}','{objITN_ORDN.CustomerName}','{objITN_ORDN.CustomerCode}','{objITN_ORDN.Branch}','{objITN_ORDN.ReferenceNo}','{objITN_ORDN.Email}','{objITN_ORDN.DocumentNo}','{objITN_ORDN.Status}',{objITN_ORDN.Postingdate},'{objITN_ORDN.ContactPerson}','{objITN_ORDN.DocumentOwner}',{objITN_ORDN.TotalBeforeDiscount},{objITN_ORDN.DiscountPercent},{objITN_ORDN.Discount},{objITN_ORDN.TaxAmount},{objITN_ORDN.TotalAmount},'{objITN_ORDN.Remarks}','{objITN_ORDN.BaseEntry}',{DateTime.Now},'ADMIN','N')");
if (insertdata > 0)
{
int serialNo = 1;
foreach (var data in objITN_ORDN.ITN_RDN1)
{
this.dbConnection.Execute($@"INSERT INTO ITN_RPD1(ITN_ORDNID,ItemDescription,ItemCode,Quantity,ReturnQuantity,UnitPrice,DiscountPercent,TaxCode,TotalAmount,TaxAmount,Warehouse,BaseLine,BaseQuantity,CreatedDate,CreatedBy,DeletedFlag,SERIAL_NO,BATCH_NO) VALUES({objITN_ORDN.Id},'{data.ItemDescription}','{data.ItemCode}',{data.Quantity},{data.ReturnQuantity},{data.UnitPrice},{data.DiscountPercent},'{data.TaxCode}',{data.TotalAmount},{data.TaxAmount},'{data.Warehouse}',{data.BaseLine},{data.BaseQuantity},{DateTime.Now},'ADMIN','N',{serialNo},{serialNo})");
serialNo++;
}
return(true);
}
return(false);
}
