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