public static bool CommissionSetting(Commission commission)
{
try
{
using (DbManager db = DbManager.GetDbManager())
{
var prams = new SqlParameter[8];
prams[0] = db.MakeInParam("@intcommissionId", SqlDbType.Int, 0, commission.CommissionId);
prams[1] = db.MakeInParam("@intcountryId", SqlDbType.Int, 0, commission.CountryId);
prams[2] = db.MakeInParam("@intorganizationSubTypeId", SqlDbType.Int, 0, commission.OrganizationSubTypeId);
prams[3] = db.MakeInParam("@intStewardshipID", SqlDbType.Int, 0, commission.StewardshipID);
prams[4] = db.MakeInParam("@tntcommissiontype", SqlDbType.Int, 0, commission.TntCommissionType);
prams[5] = db.MakeInParam("@amount", SqlDbType.Decimal, 0, commission.Amount);
prams[6] = db.MakeInParam("@percentage", SqlDbType.Decimal, 0, commission.Percentage);
prams[7] = db.MakeInParam("@intcreatedby", SqlDbType.Int, 0, commission.CreatedById);
int exec = db.RunProc("[up_commission_insert]", prams);
return true;
}
}
catch (Exception ex)
{
new SqlLog().InsertSqlLog(0, "commission.UpdateCommission", ex);
return false;
}
return true;
}
