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