public static int?EligibilityInsert(EligibiltyTable eligibility, int iUserManagerId) { try { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("iEntitlementTypeId", eligibility.iEntitlementTypeId)); parameters.Add(new SqlParameter("nvEntitlementType", eligibility.nvEntitlementType)); parameters.Add(new SqlParameter("nNumHours", eligibility.nNumHours)); parameters.Add(new SqlParameter("iUserManagerId", iUserManagerId)); DataSet ds = SqlDataAccess.ExecuteDatasetSP("TEntitlement_INS", parameters); return(int.Parse(ds.Tables[0].Rows[0][0].ToString())); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "EligibilityInsert"); return(-1); } }
public static List <EligibiltyTable> GetEligibiltyTable() { try { DataTable dt = SqlDataAccess.ExecuteDatasetSP("TSysEntitlementTable_SLCT").Tables[0]; List <EligibiltyTable> lEligibiltyTable = new List <EligibiltyTable>(); for (int i = 0; i < dt.Rows.Count; i++) { EligibiltyTable eligibiltyTable = new EligibiltyTable(); eligibiltyTable.iEntitlementTypeId = int.Parse(dt.Rows[i]["iEntitlementTypeId"].ToString()); eligibiltyTable.nvEntitlementType = dt.Rows[i]["nvEntitlementType"].ToString(); eligibiltyTable.nNumHours = double.Parse(dt.Rows[i]["nNumHours"].ToString()); lEligibiltyTable.Add(eligibiltyTable); } return(lEligibiltyTable); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "GetEligibiltyTable"); return(null); } }