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