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); }