private DataTable GetReportTableWIP()
{
DataTable dt = GetDataTableSchema(DataDefine.eTAGCardType.WIP);
ItemBIZ bizItem = new ItemBIZ();
ItemImageBIZ bizImage = new ItemImageBIZ();
int row = shtView.Rows.Count;
if (row == 0)
{
return(null);
}
int rowdt = -1;
for (int i = 0; i < row; i++)
{
// get Item Information for each row
NZString ItemCD = new NZString(null, shtView.Cells[i, (int)eColView.PART_NO].Value);
ItemDTO dtoItem = bizItem.LoadItem(ItemCD);
ItemImageDTO dtoImage = bizImage.LoadImage(ItemCD);
int copyCount = Convert.ToInt32(shtView.Cells[i, (int)eColView.NUM_OF_COPY].Value);
if (dtoItem == null)
{
continue;
}
for (int j = 0; j < copyCount; j++)
{
dt.Rows.Add();
rowdt++;
dt.Rows[rowdt][(int)eTAGCardWIP.BARCODE] = string.Format("{0}{3}{1}{3}{2}"
, shtView.Cells[i, (int)eColView.PART_NO].Value
, shtView.Cells[i, (int)eColView.LOT_NO].Value
, shtView.Cells[i, (int)eColView.LOT_SIZE].Value
, DataDefine.BARCODE_SEPARATER);
// Add by Pichet
dt.Rows[rowdt][(int)eTAGCardWIP.BARCODE] = GenBarcodeEncode((dt.Rows[rowdt][(int)eTAGCardWIP.BARCODE]).ToString(), m_barCodeType);
// Add by Pichet
dt.Rows[rowdt][(int)eTAGCardWIP.IMAGE_BIN] = dtoImage == null ? null : dtoImage.IMAGE.StrongValue;
dt.Rows[rowdt][(int)eTAGCardWIP.ITEM_CD] = dtoItem.ITEM_CD.StrongValue;
dt.Rows[rowdt][(int)eTAGCardWIP.ITEM_DESC] = dtoItem.ITEM_DESC.StrongValue;
//dt.Rows[rowdt][(int)eTAGCardWIP.FOR_CUSTOMER] = dtoItem.FOR_CUSTOMER.StrongValue;
//dt.Rows[rowdt][(int)eTAGCardWIP.PART_8_DIGIT] = dtoItem.ITEM_8_DIGITS.StrongValue;
dt.Rows[rowdt][(int)eTAGCardWIP.LOT_NO] = shtView.Cells[i, (int)eColView.LOT_NO].Value;
//dt.Rows[rowdt][(int)eTAGCardWIP.MAIN_MATTERIAL] = dtoItem.MAIN_MATTERIAL.StrongValue;
if (shtView.Cells[i, (int)eColView.LOT_SIZE].Value.ToString() != string.Empty)
{
dt.Rows[rowdt][(int)eTAGCardWIP.PACK_SIZE] = Convert.ToDecimal(shtView.Cells[i, (int)eColView.LOT_SIZE].Value).ToString();
}
//dt.Rows[rowdt][(int)eTAGCardWIP.INV_UM_CLS] = GetInventoryUMCls(dtoItem.INV_UM_CLS);
}
}
return(dt);
}
/// <summary>
/// Check exist before manipulate data. If found record will update data. Otherwise insert new data.
/// </summary>
/// <param name="database"></param>
/// <param name="data"></param>
/// <returns></returns>
public int AddNewOrUpdate(Database database, ItemImageDTO data)
{
Database db = UseDatabase(database);
if (Exist(database, data.ITEM_CD))
{
return(UpdateWithoutPK(db, data));
}
return(AddNew(db, data));
}
private static ItemImageDTO Populate(SqlDataReader reader)
{
ItemImageDTO obj = new ItemImageDTO()
{
ItemID = reader.GetInt32(reader.GetOrdinal("ItemID")),
ItemImageID = reader.GetInt32(reader.GetOrdinal("ItemImageID")),
DisplayOrder = reader.GetInt32(reader.GetOrdinal("DisplayOrder")),
Caption = reader.GetString(reader.GetOrdinal("Caption")),
ImagePath = reader.GetString(reader.GetOrdinal("ImagePath"))
};
return(obj);
}
internal Image LoadImageForItem(EVOFramework.NZString ItemCD)
{
ItemImageBIZ biz = new ItemImageBIZ();
ItemImageDTO dto = biz.LoadImage(ItemCD);
if (dto == null)
{
return(null);
}
// Convert byte array to Image.
byte[] byteArray = dto.IMAGE.StrongValue;
MemoryStream memoryStream = new MemoryStream(byteArray);
Image img = Image.FromStream(memoryStream);
return(img);
}
public ItemImageDTO UpdateCollectionImage(ItemImageDTO item)
{
using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.DatabaseConnectoin))
{
connection.Open();
using (SqlCommand command = new SqlCommand())
{
command.CommandText = "UPDATE [dbo].[ItemImage] SET [Caption] = @Caption, [DisplayOrder] = @DisplayOrder WHERE [ItemImageID] = @ItemImageID";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@Caption", item.Caption);
command.Parameters.AddWithValue("@DisplayOrder", item.DisplayOrder);
command.Parameters.AddWithValue("@ItemImageID", item.ItemImageID);
command.ExecuteNonQuery();
}
connection.Close();
connection.Dispose();
}
return(item);
}
public ItemImageDTO InsertItemImage(ItemImageDTO item)
{
using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.DatabaseConnectoin))
{
connection.Open();
using (SqlCommand command = new SqlCommand())
{
command.CommandText = "INSERT INTO [dbo].[ItemImage] ([ItemID], [ImagePath], [Caption], [DisplayOrder]) VALUES (@ItemID, @ImagePath, @Caption, @DisplayOrder); SELECT @@IDENTITY AS [ID]";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@ItemID", item.ItemID);
command.Parameters.AddWithValue("@ImagePath", item.ImagePath);
command.Parameters.AddWithValue("@Caption", item.Caption);
command.Parameters.AddWithValue("@DisplayOrder", item.DisplayOrder);
item.ItemImageID = Convert.ToInt32(command.ExecuteScalar());
}
connection.Close();
connection.Dispose();
}
return(item);
}
/// <summary>
/// Update record by using primary key value on the given data variable
/// </summary>
/// <param name="database"></param>
/// <param name="data">Data with primary key value.</param>
/// <returns></returns>
public int UpdateWithoutPK(Database database, ItemImageDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" UPDATE " + data.TableName);
sb.AppendLine(" SET ");
sb.AppendLine(" " + ItemImageDTO.eColumns.IMAGE + "=:IMAGE");
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + ItemImageDTO.eColumns.ITEM_CD + "=:ITEM_CD");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("ITEM_CD", DataType.NVarChar, data.ITEM_CD.Value);
req.Parameters.Add("IMAGE", DataType.Default, data.IMAGE.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
/// <summary>
/// Insert new record into database.
/// </summary>
/// <param name="database"></param>
/// <param name="data"></param>
/// <returns></returns>
public int AddNew(Database database, ItemImageDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" INSERT INTO " + data.TableName + "(");
sb.AppendLine(" " + ItemImageDTO.eColumns.ITEM_CD);
sb.AppendLine(" ," + ItemImageDTO.eColumns.IMAGE);
sb.AppendLine(") VALUES(");
sb.AppendLine(" :ITEM_CD");
sb.AppendLine(" ,:IMAGE");
sb.AppendLine(" )");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("ITEM_CD", DataType.NVarChar, data.ITEM_CD.Value);
req.Parameters.Add("IMAGE", DataType.Default, data.IMAGE.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
public async Task <IActionResult> ChangeThumbnail([FromBody] ItemImageDTO model)
{
await this._itemService.ChangeThumbnailAsync(model.ItemId, model.Link);
return(Ok(new { message = "Item thumbnail changed successfully.", id = model.ItemId }));
}
