public Vendor GetVendor(int ID) { Vendor item = new Vendor(); SqlCommand cmd = new SqlCommand("GetVendor") { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@ID", ID); using (SqlDataReader rdr = (SqlDataReader)_repo.ExecuteReader(cmd)) { while (rdr.Read()) { item = new Vendor() { ID = (int)rdr["ID"] , Name = rdr["Name"] != DBNull.Value ? rdr["Name"].ToString() : "" , Description = rdr["Description"] != DBNull.Value ? rdr["Description"].ToString() : "" , ImageID = rdr["ImageID"] != DBNull.Value ? (int)rdr["ImageID"] : 0 , LinkURL = rdr["LinkURL"] != DBNull.Value ? rdr["LinkURL"].ToString() : "" , LinkAltText = rdr["LinkAltText"] != DBNull.Value ? rdr["LinkAltText"].ToString() : "" , DateInserted = (DateTime)rdr["DateInserted"] , DateUpdated = rdr["DateUpdated"] != DBNull.Value ? (DateTime?)rdr["DateUpdated"] : DateTime.MinValue , IsActive = (bool)rdr["IsActive"] }; } } return item; }
public void UpdateVendor(Vendor vendor) { SqlCommand cmd = new SqlCommand("UpdateVendor") { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@ID", vendor.ID); cmd.Parameters.AddWithValue("@Name", vendor.Name); cmd.Parameters.AddWithValue("@Description", vendor.Description); cmd.Parameters.AddWithValue("@ImageID", vendor.ImageID); cmd.Parameters.AddWithValue("@LinkURL", vendor.LinkURL); cmd.Parameters.AddWithValue("@LinkAltText", vendor.LinkAltText); try { _repo.ExecuteNonQuery(cmd); } catch (Exception exc) { throw exc; } }
public int CreateVendor(Vendor vendor) { int id; SqlCommand cmd = new SqlCommand("CreateVendor") { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@Name", vendor.Name); cmd.Parameters.AddWithValue("@Description", vendor.Description); cmd.Parameters.AddWithValue("@ImageID", vendor.ImageID); cmd.Parameters.AddWithValue("@LinkURL", vendor.LinkURL); cmd.Parameters.AddWithValue("@LinkAltText", vendor.LinkAltText); SqlParameter param = new SqlParameter("@ID", SqlDbType.Int); param.Direction = ParameterDirection.Output; cmd.Parameters.Add(param); try { _repo.ExecuteNonQuery(cmd); id = (int)cmd.Parameters["@ID"].Value; } catch (Exception exc) { throw exc; } return id; }