public bool ActivateAdmin(string adminID) { bool flag = false; dataAccess database = new dataAccess(); string email = GetAdminEmail(adminID); flag = database.updateData("UPDATE jobsdb_Administrator SET Active = 'True' WHERE ID='" + adminID + "'"); database.updateData("UPDATE aspnet_Membership SET IsLockedOut = 'False' WHERE Email='" + email + "'"); return(flag); }
public bool UpdateOrderActivate(string orderNum) { string updateString = "UPDATE jobsdb_UnitOrder SET Active = 'Y' WHERE OrderNum='" + orderNum + "'"; bool flag = false; dataAccess database = new dataAccess(); flag = database.updateData(updateString); return(flag); }
public bool DepleteUnitsByEmail(int amount, string email) { dataAccess database = new dataAccess(); bool flag = false; DataTable advertiserUnitTbl = database.getTable("SELECT Units FROM jobsdb_Employer WHERE Email='" + email + "'"); Int32 units = Convert.ToInt32(advertiserUnitTbl.Rows[0][0].ToString()); if (amount <= units) { units = units - amount; flag = database.updateData("Update jobsdb_Employer SET Units='" + units + "' WHERE Email='" + email + "'"); } return(flag); }
public bool CreditAdvertiser(string orderNum) { bool flag = false; dataAccess database = new dataAccess(); string selectAdvertiser = "SELECT Employer, UnitQty FROM jobsdb_UnitOrder WHERE OrderNum='" + orderNum + "'"; DataTable advertiser = database.getTable(selectAdvertiser); string advertiserID = advertiser.Rows[0]["Employer"].ToString(); string selectCompanyName = "SELECT CompanyName,Units FROM jobsdb_Employer WHERE ID='" + advertiserID + "'"; DataTable companyRecord = database.getTable(selectCompanyName); SetAdvertiserName(companyRecord.Rows[0]["CompanyName"].ToString()); string unitQty = advertiser.Rows[0]["UnitQty"].ToString(); SetUnitQty(unitQty); Int32 unitValue = Convert.ToInt32(companyRecord.Rows[0]["Units"].ToString()) + Convert.ToInt32(unitQty); string updateString = "UPDATE jobsdb_Employer SET Units='" + unitValue + "' WHERE ID ='" + advertiserID + "'"; flag = database.updateData(updateString); return(flag); }
public void UpdateUnitAmount(string unitAmount) { dataAccess database = new dataAccess(); database.updateData("UPDATE jobsdb_StoredValues SET Value = '" + unitAmount + "' WHERE Description = 'Unit Amount'"); }