public static SonyCenter getCenterById(int id, string connString) { #region code SonyCenter sonyCenter = new SonyCenter(); using (SqlConnection conn = new SqlConnection(connString)) { try { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sony_sp_get_sony_center_by_id"; cmd.Parameters.AddWithValue("@id", id); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { sonyCenter.Id = (int)reader["id"]; sonyCenter.Name = reader["name"].ToString(); sonyCenter.Address = reader["address"].ToString(); sonyCenter.Phone = reader["phone"].ToString(); sonyCenter.Fax = reader["fax"].ToString(); sonyCenter.Province = reader["province"].ToString(); sonyCenter.Description = reader["description"].ToString(); sonyCenter.RetailLevel = (int)reader["retailLevel"]; sonyCenter.CenterImage = reader["CenterImage"].ToString(); sonyCenter.OpenTime = reader["opentime"].ToString(); sonyCenter.CloseTime = reader["closetime"].ToString(); sonyCenter.Longitude = reader["longitude"].ToString(); sonyCenter.Latitude = reader["latitude"].ToString(); sonyCenter.Created = (DateTime)reader["created"]; sonyCenter.Updated = (DateTime)reader["updated"]; sonyCenter.SonyCenterCover = reader["SonyCenterCover"].ToString(); sonyCenter.ProvinceName = reader["ProvinceName"].ToString(); } } } } catch (Exception ex) { return new SonyCenter(); } } return sonyCenter; #endregion }
public static bool addCenter(SonyCenter sonyCenter, string connString) { #region code bool rs = false; using (SqlConnection conn = new SqlConnection(connString)) { try { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sony_sp_add_sony_center"; cmd.Parameters.AddWithValue("@name", sonyCenter.Name); cmd.Parameters.AddWithValue("@address", sonyCenter.Address); cmd.Parameters.AddWithValue("@phone", sonyCenter.Phone); cmd.Parameters.AddWithValue("@fax", sonyCenter.Fax); cmd.Parameters.AddWithValue("@province", sonyCenter.Province); cmd.Parameters.AddWithValue("@description", sonyCenter.Description); cmd.Parameters.AddWithValue("@retailLevel", sonyCenter.RetailLevel); cmd.Parameters.AddWithValue("@centerImage", sonyCenter.CenterImage); cmd.Parameters.AddWithValue("@opentime", sonyCenter.OpenTime); cmd.Parameters.AddWithValue("@closetime", sonyCenter.CloseTime); cmd.Parameters.AddWithValue("@longitude", sonyCenter.Longitude); cmd.Parameters.AddWithValue("@latitude", sonyCenter.Latitude); SqlParameter returnVal = new SqlParameter("@returnVal", SqlDbType.Int); returnVal.Direction = ParameterDirection.Output; cmd.Parameters.Add(returnVal); cmd.ExecuteNonQuery(); rs = ((int)cmd.Parameters["@returnVal"].Value != 0); } } catch (Exception ex) { return false; } } return rs; #endregion }
public static List<SonyCenter> getListAllCenter(string connString) { #region code List<SonyCenter> lists = new List<SonyCenter>(); using (SqlConnection conn = new SqlConnection(connString)) { try { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sony_sp_get_all_sony_center"; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { SonyCenter sonyCenter = new SonyCenter(); sonyCenter.Id = (int)reader["id"]; sonyCenter.Name = reader["name"].ToString(); sonyCenter.Address = reader["address"].ToString(); sonyCenter.Phone = reader["phone"].ToString(); sonyCenter.Fax = reader["fax"].ToString(); sonyCenter.Province = reader["province"].ToString(); sonyCenter.Description = reader["description"].ToString(); sonyCenter.RetailLevel = (int)reader["retailLevel"]; sonyCenter.CenterImage = reader["CenterImage"].ToString(); sonyCenter.OpenTime = reader["opentime"].ToString(); sonyCenter.CloseTime = reader["closetime"].ToString(); sonyCenter.Longitude = reader["longitude"].ToString(); sonyCenter.Latitude = reader["latitude"].ToString(); sonyCenter.Created = (DateTime)reader["created"]; sonyCenter.Updated = (DateTime)reader["updated"]; sonyCenter.SonyCenterCover = reader["SonyCenterCover"].ToString(); sonyCenter.ProvinceName = reader["ProvinceName"].ToString(); lists.Add(sonyCenter); } } } } catch (Exception ex) { return new List<SonyCenter>(); } } return lists; #endregion }