public static string Insert_parent(CommissionCalc objTransaction, string created_by)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
string chk;
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 3);
param[0] = dbManager.getparam("@AccountNo", objTransaction.AccountNo);
param[1] = dbManager.getparam("@CreatedBy", created_by);
param[2] = dbManager.getparam("@commission_date", objTransaction.CommissionCalcDate);
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "USP_commission_parent_insert", param);
chk = Convert.ToString(dbManager.ExecuteScalar(cmd));
}
catch (Exception ex)
{
return("");
}
finally
{
dbManager.Dispose();
}
return(chk);
}
public static bool Insert_commission_child(CommissionCalc objTransaction)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
Boolean chk = false;
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 6);
param[0] = dbManager.getparam("@CommissionCalcID", objTransaction.CommissionCalcID);
param[1] = dbManager.getparam("@AccountNo", objTransaction.AccountNo);
param[2] = dbManager.getparam("@ProductCode", objTransaction.ProductCode);
param[3] = dbManager.getparam("@ClosingQty", objTransaction.ClossingQty);
param[4] = dbManager.getparam("@CommissionPercent", objTransaction.CommissionPercent);
param[5] = dbManager.getparam("@commission_date", objTransaction.CalcDate);
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "USP_commission_child_insert", param);
chk = dbManager.ExecuteQuery(cmd);
}
catch (Exception ex)
{
return(false);
}
finally
{
dbManager.Dispose();
}
return(chk);
}
