public static void DeleteZipCode(int ID) { if (ID > 0) { var db = new SQLDBAccess("CIPConnectionString"); db.AddParameter("@Action", "ByZipCodeID"); db.AddParameter("@ZipCodeID", ID); db.ExecuteNonQuery("usp_FedZipCodes_Delete"); } }
public static void SaveFederationContact(int fedId, string contactName, string phone, string email) { var db = new SQLDBAccess("CIPConnectionString"); db.AddParameter("@Action", "UpdateContactInfo"); db.AddParameter("@FedID", fedId); db.AddParameter("@Contact", contactName); db.AddParameter("@Phone", phone); db.AddParameter("@Email", email); db.ExecuteNonQuery("usp_Federation_Update"); }
public static bool BulkUpdateStatus(int campYearId, int fedId, string campIdList, int userId, int fromStatusId, int toStatusId) { var db = new SQLDBAccess("CIPConnectionString"); db.AddParameter("@Action", "BulkUpdateStatus"); db.AddParameter("@CampYearID", campYearId); db.AddParameter("@FedID", fedId); db.AddParameter("@CampIds", campIdList); db.AddParameter("@UserID", userId); db.AddParameter("@FromStatusID", fromStatusId); db.AddParameter("@ToStatusID", toStatusId); int ret = db.ExecuteNonQuery("usp_CamperApplication_Update"); return(true); }
public static bool InsertZipCode(int fedId, string zipCode) { if (fedId > 0 && zipCode != "") { var dt = GetZipCodes(zipCode); if (dt.Rows.Count > 0) { return(false); } var db = new SQLDBAccess("CIPConnectionString"); db.AddParameter("@Action", "Single"); db.AddParameter("@FedID", fedId); db.AddParameter("@ZipCode", zipCode); db.ExecuteNonQuery("usp_FedZipCodes_Insert"); return(true); } return(true); }