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