public static bool Authenticate(string EmailID, string Password) { SQLDBAccess db = new SQLDBAccess("CIPMS"); db.AddParameter("@EmailID", EmailID); db.AddParameter("@Password", Password); IDataReader dr = db.ExecuteReader("usp_ValidateLogin"); return(dr.Read()); }
public static Dictionary <string, string> GetFederationByIdOrZipCode(string zipCode, int fedId) { var db = new SQLDBAccess("CIPConnectionString"); db.AddParameter("@Action", "GetFedByZipCode"); if (fedId == 0) { db.AddParameter("@ZipCode", zipCode); } else { db.AddParameter("@FedID", fedId); } var dr = db.ExecuteReader("usprsFederations_Select"); var ret = new Dictionary <string, string>(); if (dr.Read()) { ret.Add("ID", dr["ID"].ToString()); ret.Add("Name", dr["Name"].ToString()); ret.Add("Contact", dr["Contact"].ToString()); ret.Add("Phone", dr["Phone"].ToString()); ret.Add("Email", dr["Email"].ToString()); ret.Add("isActive", dr["isActive"].ToString()); ret.Add("isGrantAvailable", dr["isGrantAvailable"].ToString()); ret.Add("isOnlineProcessing", dr["isOnlineProcessing"].ToString()); ret.Add("isJDSAvailable", dr["isJDSAvailable"].ToString()); ret.Add("isJDSOnline", dr["isJDSOnline"].ToString()); ret.Add("is19DaysOnly", dr["is19DaysOnly"].ToString()); } if (dr.Read()) { if (!ret.ContainsKey("Error")) { ret.Add("Error", "Duplicate"); } ret.Add("NameForSecondProgram", dr["Name"].ToString()); } dr.Close(); return(ret); }
public static int GetPaymentAccessFedID(DateTime myDate) { var db = new SQLDBAccess("CIPConnectionString"); db.AddParameter("@Action", "GetFedIDByDate"); db.AddParameter("@MyDate", myDate); var dr = db.ExecuteReader("usp_PaymentDate_Select"); int ret = 0; if (dr.Read()) { ret = (int)dr[0]; } return(ret); }
public static AppData GetAppLevelData() { SQLDBAccess db = new SQLDBAccess("CIPMS"); db.AddParameter("@Action", "GetAppData"); IDataReader dr = db.ExecuteReader("usprsCampYear_Select"); if (dr.Read()) { var data = new AppData() { CampYear = Convert.ToInt32(dr["CampYear"]), CampYearID = Convert.ToInt32(dr["ID"]) }; return(data); } return(null); }