private static StockImage PopulateFromDBDetailsObject(StockImageDetails obj)
{
StockImage objNew = new StockImage();
objNew.StockImageId = obj.StockImageId;
objNew.StockNo = obj.StockNo;
objNew.Caption = obj.Caption;
objNew.ThumbnailImage = obj.ThumbnailImage;
objNew.ThumbnailImageContentType = obj.ThumbnailImageContentType;
objNew.MediumImage = obj.MediumImage;
objNew.MediumImageContentType = obj.MediumImageContentType;
objNew.FullsizeImage = obj.FullsizeImage;
objNew.FullsizeImageContentType = obj.FullsizeImageContentType;
objNew.UpdatedBy = obj.UpdatedBy;
objNew.DLUP = obj.DLUP;
return(objNew);
}
// [001] code start
/// <summary>
/// Get Stock Image
/// Calls [usp_selectAll_Image_for_QuoteToClient]
/// </summary>
public override List <StockImageDetails> GetImageListForReq(System.Int32?sourcingResultNo, System.String fileType)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_selectAll_Image_for_QuoteToClient", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@SourcingResultNo", SqlDbType.Int).Value = sourcingResultNo;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <StockImageDetails> lstPDF = new List <StockImageDetails>();
while (reader.Read())
{
StockImageDetails obj = new StockImageDetails();
obj.StockImageId = GetReaderValue_Int32(reader, "SourcingImageId", 0);
obj.ImageDocumentRefNo = GetReaderValue_Int32(reader, "SourcingResultNo", 0);
obj.Caption = GetReaderValue_String(reader, "Caption", "");
obj.ImageName = GetReaderValue_String(reader, "ImageName", "");
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_NullableDateTime(reader, "DLUP", null);
obj.UpdatedByName = GetReaderValue_String(reader, "ImageName", "");
lstPDF.Add(obj);
obj = null;
}
return(lstPDF);
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get Image list", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
//[001] code start
/// <summary>
/// GetListForStock
/// Calls [usp_selectAll_StockImage_for_Stock]
/// </summary>
public override List <StockImageDetails> GetListForStockSAN(System.Int32?stockId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(Globals.Settings.StockImages.ConnectionString);
cmd = new SqlCommand("usp_selectAll_StockImage_for_Stock", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@StockId", SqlDbType.Int).Value = stockId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <StockImageDetails> lst = new List <StockImageDetails>();
while (reader.Read())
{
StockImageDetails obj = new StockImageDetails();
obj.StockImageId = GetReaderValue_Int32(reader, "StockImageId", 0);
obj.StockNo = GetReaderValue_Int32(reader, "StockNo", 0);
obj.Caption = GetReaderValue_String(reader, "Caption", "");
obj.ImageName = GetReaderValue_String(reader, "ImageName", "");
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_NullableDateTime(reader, "DLUP", null);
lst.Add(obj);
obj = null;
}
return(lst);
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get StockImages", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// Get
/// Calls [usp_select_StockImage]
/// </summary>
public override StockImageDetails Get(System.Int32?stockImageId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_StockImage", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@StockImageId", SqlDbType.Int).Value = stockImageId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetStockImageFromReader(reader);
StockImageDetails obj = new StockImageDetails();
obj.StockImageId = GetReaderValue_Int32(reader, "StockImageId", 0);
obj.StockNo = GetReaderValue_Int32(reader, "StockNo", 0);
obj.Caption = GetReaderValue_String(reader, "Caption", "");
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_NullableDateTime(reader, "DLUP", null);
return(obj);
}
else
{
return(null);
}
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get StockImage", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// GetThumbnailImage
/// Calls [usp_select_StockImage_ThumbnailImage]
/// </summary>
public override StockImageDetails GetThumbnailImage(System.Int32?stockImageId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(Globals.Settings.StockImages.MediaConnectionString);
cmd = new SqlCommand("usp_select_StockImage_ThumbnailImage", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@StockImageId", SqlDbType.Int).Value = stockImageId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetStockImageFromReader(reader);
StockImageDetails obj = new StockImageDetails();
obj.StockImageId = GetReaderValue_Int32(reader, "StockImageId", 0);
obj.StockNo = GetReaderValue_Int32(reader, "StockNo", 0);
obj.ThumbnailImage = GetReaderValue_ByteArray(reader, "ThumbnailImage", null);
obj.ThumbnailImageContentType = GetReaderValue_String(reader, "ThumbnailImageContentType", "");
return(obj);
}
else
{
return(null);
}
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get StockImage", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
