public static int Insert(Company c)
{
DBAccess db = new DBAccess();
SqlParameter objParam = new SqlParameter("@iCompanyID",0);
objParam.Direction = ParameterDirection.Output;
db.Parameters.Add(new SqlParameter("@sUserName", c.UserName));
db.Parameters.Add(new SqlParameter("@sCompanyName", c.CompanyName));
db.Parameters.Add(new SqlParameter("@sAddress1", c.Address1));
db.Parameters.Add(new SqlParameter("@sAddress2", c.Address2));
db.Parameters.Add(new SqlParameter("@sCity", c.City));
db.Parameters.Add(new SqlParameter("@iStateID", c.StateID));
db.Parameters.Add(new SqlParameter("@iCountryID", c.CountryID));
db.Parameters.Add(new SqlParameter("@sZip", c.ZIP));
db.Parameters.Add(new SqlParameter("@sPhone", c.Phone));
db.Parameters.Add(new SqlParameter("@sFax", c.Fax));
db.Parameters.Add(new SqlParameter("@sCompanyEmail", c.Email));
db.Parameters.Add(new SqlParameter("@sWebSiteUrl", c.WebSiteUrl));
db.Parameters.Add(new SqlParameter("@sCompanyProfile", c.BriefProfile));
db.Parameters.Add(objParam);
int retval = db.ExecuteNonQuery("JobsDb_Companies_Insert");
if (retval == 1)
{
return int.Parse(objParam.Value.ToString());
}
else
{
return -1;
}
}
public static int Update(Company c)
{
DBAccess db = new DBAccess();
db.Parameters.Add(new SqlParameter("@iCompanyID", c.CompanyID));
db.Parameters.Add(new SqlParameter("@sUserName", c.UserName));
db.Parameters.Add(new SqlParameter("@sCompanyName", c.CompanyName));
db.Parameters.Add(new SqlParameter("@sAddress1", c.Address1));
db.Parameters.Add(new SqlParameter("@sAddress2", c.Address2));
db.Parameters.Add(new SqlParameter("@sCity", c.City));
db.Parameters.Add(new SqlParameter("@iStateID", c.StateID));
db.Parameters.Add(new SqlParameter("@iCountryID", c.CountryID));
db.Parameters.Add(new SqlParameter("@sZip", c.ZIP));
db.Parameters.Add(new SqlParameter("@sPhone", c.Phone));
db.Parameters.Add(new SqlParameter("@sFax", c.Fax));
db.Parameters.Add(new SqlParameter("@sCompanyEmail", c.Email));
db.Parameters.Add(new SqlParameter("@sWebSiteUrl", c.WebSiteUrl));
db.Parameters.Add(new SqlParameter("@sCompanyProfile", c.BriefProfile));
int retval = db.ExecuteNonQuery("JobsDb_Companies_Update");
return retval;
}
public static Company GetCompany(int companyid)
{
DBAccess db = new DBAccess();
db.Parameters.Add(new SqlParameter("@iCompanyID", companyid));
SqlDataReader dr = (SqlDataReader)db.ExecuteReader("JobsDb_Companies_SelectOne");
if (dr.HasRows)
{
Company c = new Company();
while (dr.Read())
{
c.CompanyID = dr.GetInt32(dr.GetOrdinal("companyid"));
c.CompanyName = dr.GetString(dr.GetOrdinal("CompanyName"));
c.BriefProfile = dr.GetString(dr.GetOrdinal("CompanyProfile"));
c.WebSiteUrl = dr.GetString(dr.GetOrdinal("WebSiteUrl"));
c.Address1 = dr.GetString(dr.GetOrdinal("Address1"));
c.Address2 = dr.GetString(dr.GetOrdinal("Address2"));
c.City = dr.GetString(dr.GetOrdinal("City"));
c.StateID = dr.GetInt32(dr.GetOrdinal("StateID"));
c.CountryID = dr.GetInt32(dr.GetOrdinal("CountryID"));
c.ZIP = dr.GetString(dr.GetOrdinal("ZIP"));
c.Phone = dr.GetString(dr.GetOrdinal("Phone"));
c.Fax = dr.GetString(dr.GetOrdinal("Fax"));
c.Email = dr.GetString(dr.GetOrdinal("CompanyEmail"));
c.UserName = dr.GetString(dr.GetOrdinal("UserName"));
}
dr.Close();
return c;
}
else
{
dr.Close();
return null;
}
}
