public bool SaveUpdatePurchaseInvoice(ITN_BOPCH objiTN_BOVPM)
{
if (objiTN_BOVPM.PIId == null)
{
int insertedRows = this.dbConnection.Execute(@"INSERT INTO ITN_BOVPM(CustVenName,CustVenCode,CustVenFlag,Branch,RefernceNo,Email,DocumentNo,Status,PostingDate,CreditCard,Cash,BankTransfer,TotalAmount,DocumnentOwner,Remarks,CreatedDate,CreatedBy) VALUES(@CustVenName,@CustVenCode,@CustVenFlag,@Branch,@RefernceNo,@Email,@DocumentNo,@Status,GETDATE(),@CreditCard,@Cash,@BankTransfer,@TotalAmount,@DocumnentOwner,@Remarks,GETDATE(),@CreatedBy)", new { objiTN_BOVPM.VendorName, objiTN_BOVPM.VendorCode, objiTN_BOVPM.Branch, objiTN_BOVPM.RefernceNo, objiTN_BOVPM.Email, objiTN_BOVPM.DocumentNo, objiTN_BOVPM.Status, objiTN_BOVPM.TotalAmount, objiTN_BOVPM.DocumnentOwner, objiTN_BOVPM.Remarks, objiTN_BOVPM.CreatedBy });
if (insertedRows > 0)
{
int serialNo = 1;
foreach (var data in objiTN_BOVPM.ITN_BPCH1)
{
this.dbConnection.Execute(@"INSERT INTO ITN_BVPM1(IncPayId,Choose,Invoice,TotalAmount,PaidAmount,BalanceAmount,SERIAL_NO,BATCH_NO,CreatedDate,CreatedBy) VALUES(@IncPayId,@Choose,@Invoice,@TotalAmount,@PaidAmount,@BalanceAmount,@SERIAL_NO,@BATCH_NO,GETDATE(),@CreatedBy)", new { data.PIID, data.TotalAmount, serialNo, data.BATCH_NO, data.CreatedBy });
serialNo++;
}
return(true);
}
return(false);
}
else
{
int updateRows = this.dbConnection.Execute(@"UPDATE ITN_BOVPM SET CustVenName=@CustVenName,CustVenCode=@CustVenCode,CustVenFlag=@CustVenFlag,Branch=@Branch,RefernceNo=@RefernceNo,Email=@Email,DocumentNo=@DocumentNo,Status=@Status,PostingDate=@PostingDate,CreditCard=@CreditCard,Cash=@Cash,BankTransfer=@BankTransfer,TotalAmount=@TotalAmount,DocumnentOwner=@DocumnentOwner,Remarks=@Remarks,UpdatedDate=GET,UpdatedBy=@UpdatedBy", new { objiTN_BOVPM.VendorName, objiTN_BOVPM.VendorCode, objiTN_BOVPM.Branch, objiTN_BOVPM.RefernceNo, objiTN_BOVPM.Email, objiTN_BOVPM.DocumentNo, objiTN_BOVPM.Status, objiTN_BOVPM.TotalAmount, objiTN_BOVPM.DocumnentOwner, objiTN_BOVPM.Remarks, objiTN_BOVPM.CreatedBy });
if (updateRows > 0)
{
int serialNo = 1;
foreach (var data in objiTN_BOVPM.ITN_BPCH1)
{
this.dbConnection.Execute(@"UPDATE ITN_BVPM1 SET IncPayId=@IncPayId,Choose=@Choose,Invoice=@Invoice,TotalAmount=@TotalAmount,PaidAmount=@PaidAmount,BalanceAmount=@BalanceAmount,SERIAL_NO=@SERIAL_NO,BATCH_NO=@BATCH_NO,UpdatedDate=GET,UpdatedBy=@UpdatedBy WHERE IncPayCId= @IncPayCId", new { data.PIID, data.TotalAmount, serialNo, data.BATCH_NO, data.CreatedBy });
serialNo++;
}
return(true);
}
return(false);
}
}
public IActionResult SaveUpdatePurchaseInvoice(ITN_BOPCH objiTN_BOVPM)
{
_iPurchaseInvoiceService.SaveUpdatePurchaseInvoice(objiTN_BOVPM);
return(View());
}
public bool SaveUpdatePurchaseInvoice(ITN_BOPCH objiTN_BOVPM)
{
return(_iPurchaseInvoiceRepository.SaveUpdatePurchaseInvoice(objiTN_BOVPM));
}