public static bool InsertSalesReturnPayment(SalesReturnParent objSalesReturnParent)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
bool isSave = true;
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 5);
param[0] = dbManager.getparam("@InvoiceNo", objSalesReturnParent.InvoiceNo);
param[1] = dbManager.getparam("@SalesReturnNo", objSalesReturnParent.SalesReturnNo);
param[2] = dbManager.getparam("@PaidAmount", Convert.ToDouble(objSalesReturnParent.TotalAmount));
param[3] = dbManager.getparam("@TerminalID", objSalesReturnParent.TerminalID);
param[4] = dbManager.getparam("@CreatedBy", Convert.ToInt64(objSalesReturnParent.CreatedBy));
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "[dbo].[USP_SalesReturn_PaymentInfo_Add]", param);
dbManager.ExecuteQuery(cmd);
}
catch (Exception ex)
{
isSave = false;
MessageBox.Show(ex.ToString());
}
finally
{
dbManager.Dispose();
}
return(isSave);
}
public static DataTable InsertSalesReturnParent(SalesReturnParent objSalesReturnParent, string AccountNo)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
DataTable dt = new DataTable();
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 6);
param[0] = dbManager.getparam("@SalesNo", objSalesReturnParent.InvoiceNo);
param[1] = dbManager.getparam("@TotalAmount", Convert.ToDouble(objSalesReturnParent.TotalAmount));
param[2] = dbManager.getparam("@CreatedBy", Convert.ToInt64(objSalesReturnParent.CreatedBy));
param[3] = dbManager.getparam("@TerminalID", objSalesReturnParent.TerminalID);
param[4] = dbManager.getparam("@pk_code", "");
param[5] = dbManager.getparam("@AccountNo", AccountNo);
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "[dbo].[USP_SalesReturnParent_Add]", param);
dt = dbManager.GetDataTable(cmd);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
//return false;
}
finally
{
dbManager.Dispose();
}
return(dt);
}
