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