public bool AddNewImage(MetaShopImage identity) { //Common syntax var sqlCmd = @"Shop_AddNewImage"; //For parameters var parameters = new Dictionary <string, object> { { "@Id", identity.Id }, { "@ShopId", identity.ShopId }, { "@Name", identity.Name }, { "@Url", identity.Url } }; try { using (var conn = new SqlConnection(_connectionString)) { MsSqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, sqlCmd, parameters); } } catch (Exception ex) { var strError = "Failed to execute Shop_AddNewImage. Error: " + ex.Message; throw new CustomSQLException(strError); } return(true); }
public List <MetaShopImage> GetListImage(int Id) { //Common syntax var sqlCmd = @"Shop_GetListImage"; //For parameters var parameters = new Dictionary <string, object> { { "@ShopId", Id }, }; List <MetaShopImage> listData = new List <MetaShopImage>(); try { using (var conn = new SqlConnection(_connectionString)) { using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters)) { while (reader.Read()) { var item = new MetaShopImage(); item.Id = reader["Id"].ToString(); item.ShopId = Utils.ConvertToInt32(reader["ShopId"]); item.Name = reader["Name"].ToString(); item.Url = reader["Url"].ToString(); item.CreatedDate = reader["CreatedDate"] == DBNull.Value ? null : (DateTime?)reader["CreatedDate"]; listData.Add(item); } } } } catch (Exception ex) { var strError = "Failed to execute Shop_GetListImage. Error: " + ex.Message; throw new CustomSQLException(strError); } return(listData); }
private List <MetaShopImage> ExtractShopImageData(IDataReader reader) { var myList = new List <MetaShopImage>(); while (reader.Read()) { var record = new MetaShopImage(); //Seperate properties record.Id = reader["Id"].ToString(); record.ShopId = Utils.ConvertToInt32(reader["ShopId"]); record.Name = reader["Name"].ToString(); record.Url = reader["Url"].ToString(); record.CreatedDate = reader["CreatedDate"] == DBNull.Value ? null : (DateTime?)reader["CreatedDate"]; myList.Add(record); } return(myList); }
public bool AddNewImage(MetaShopImage identity) { return(myRepository.AddNewImage(identity)); }