public bool UpdateStockReceipt(ITN_OPDN objITN_OPDN)
{
int updateRows = this.dbConnection.Execute($@"UPDATE ITN_OPDN SET VendorName='{objITN_OPDN.VendorName}', VendorCode='{objITN_OPDN.VendorCode}' , Branch='{objITN_OPDN.Branch}',ReferenceNo='{objITN_OPDN.ReferenceNo}',Email='{objITN_OPDN.Email}',DocumentNo='{objITN_OPDN.DocumentNo}',Status='{objITN_OPDN.Status}',PostingDate={objITN_OPDN.PostingDate},ReceivedDate={objITN_OPDN.ReceivedDate},ContactPerson={objITN_OPDN.ContactPerson},DocumentOwner='{objITN_OPDN.DocumentOwner}',TotalBeforeDiscount={objITN_OPDN.TotalBeforeDiscount},DiscountPercent={objITN_OPDN.DiscountPercent},Discount={objITN_OPDN.Discount},TaxAmount={objITN_OPDN.TaxAmount},TotalAmount={objITN_OPDN.TotalAmount},Remarks='{objITN_OPDN.Remarks}',,BaseEntry='{objITN_OPDN.BaseEntry}',UpdatedDate={DateTime.Now},UpdatedBy='ADMIN'");
if (updateRows > 0)
{
int serialNo = 1;
foreach (var data in objITN_OPDN.ITN_PDN1)
{
this.dbConnection.Execute($@"UPDATE ITN_PRO1 SET ItemDescription='{data.ItemDescription}',ItemCode='{data.ItemCode}',Quantity={data.RequestedQuantity},ReceivedQty={data.ReceivedQuantity},DamagedQuantity={data.DamagedQuantity},UnitPrice={data.UnitPrice},DiscountPercent={data.DiscountPercent},TaxCode='{data.TaxCode}',TotalAmount={data.TotalAmount},TaxAmount={data.TotalAmount},Warehouse='{data.Warehouse}',ReturnQuantity={data.ReturnQuantity},SoldQuantity={data.SoldQuantity},UpadtedDate={DateTime.Now},UpdatedBy='ADMIN',DeletedFlag='N',SERIAL_NO={serialNo},BATCH_NO={serialNo}");
serialNo++;
}
return(true);
}
return(false);
}
public bool SaveStockReceipt(ITN_OPDN objITN_OPDN)
{
int insertdata = this.dbConnection.Execute($@"INSERT INTO ITN_OPDN(VendorName,VendorCode,Branch,ReferenceNo,Email,DocumentNo,Status,PostingDate,ReceivedDate,ContactPerson,DocumentOwner,TotalBeforeDiscount,DiscountPercent,Discount,TaxAmount,TotalAmount,Remarks,BaseEntry,CreatedDate,CreatedBy,DeletedFlag) VALUES('{objITN_OPDN.VendorName}','{objITN_OPDN.VendorCode}','{objITN_OPDN.Branch}','{objITN_OPDN.ReferenceNo}','{objITN_OPDN.Email}','{objITN_OPDN.DocumentNo}','{objITN_OPDN.Status}',{objITN_OPDN.PostingDate},{objITN_OPDN.ReceivedDate},'{objITN_OPDN.ContactPerson}','{objITN_OPDN.DocumentOwner}',{objITN_OPDN.TotalBeforeDiscount},{objITN_OPDN.DiscountPercent},{objITN_OPDN.Discount},{objITN_OPDN.TaxAmount},{objITN_OPDN.TotalAmount},'{objITN_OPDN.Remarks}','{objITN_OPDN.BaseEntry}',{DateTime.Now},'ADMIN','N')");
if (insertdata > 0)
{
int serialNo = 1;
foreach (var data in objITN_OPDN.ITN_PDN1)
{
this.dbConnection.Execute($@"INSERT INTO ITN_PRO1(ITN_OPDNID,ItemDescription,ItemCode,RequestedQuantity,ReceivedQuantity,DamagedQuantity,UnitPrice,DiscountPercent,TaxCode,TotalAmount,TaxAmount,Warehouse,ReturnQuantity,SoldQuantity,CreatedDate,CreatedBy,DeletedFlag,SERIAL_NO,BATCH_NO) VALUES({objITN_OPDN.Id},'{data.ItemDescription}','{data.ItemCode}',{data.RequestedQuantity},{data.ReceivedQuantity},{data.DamagedQuantity},{data.UnitPrice},{data.DiscountPercent},'{data.TaxCode}',{data.TotalAmount},{data.TaxAmount},'{data.Warehouse}',{data.ReturnQuantity},{data.SoldQuantity},{DateTime.Now},'ADMIN','N',{serialNo},{serialNo})");
serialNo++;
}
return(true);
}
return(false);
}
