private void butAddPacking_Click(object sender, EventArgs e)
{
string styleId = dgvPackStyle.CurrentRow.Cells["styleid"].Value.GetString();
if (string.IsNullOrEmpty(styleId))
{
MessageBox.Show("Please select pack style.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
SkidPackingModel model = new SkidPackingModel();
model.HeadLineID = HeaderContent.Id;
model.PackStyleId = Convert.ToInt32(styleId);
var seqResult = HeaderContent.SkidPacks.Where(i => i.PackStyleId == Convert.ToInt32(styleId)).ToList();
model.Seq = seqResult.Count + 1;
HeaderContent.SkidPacks = _repo.AddSkidPacking(epiSession, model).ToList();
ListSkidWithinSerial(HeaderContent.SkidPacks.Where(i => i.PackStyleId == Convert.ToInt32(styleId)));
}
private void butRight_Click(object sender, EventArgs e)
{
string id = string.Empty;
try
{
id = dgvSkidNumber.CurrentRow.Cells["id"].Value.GetString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string styleId = dgvPackStyle.CurrentRow.Cells["styleid"].Value.GetString();
string serialId = dgvSkidNumber.CurrentRow.Cells["serialId"].Value.GetString();
int snId = string.IsNullOrEmpty(serialId) ? 0 : Convert.ToInt32(serialId);
Int32 selectedCellCount = dgvCutting.GetCellCount(DataGridViewElementStates.Selected);
string serialCollection = string.Empty;
if (string.IsNullOrEmpty(id))
{
MessageBox.Show("Please select packing design.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (selectedCellCount > 0)
{
for (int i = 0; i < selectedCellCount; i++)
{
if (dgvCutting.SelectedCells[i].OwningColumn.Name.ToString() == "seriallineid")
{
serialCollection += string.Format(@"{0},", dgvCutting.SelectedCells[i].Value.GetString());
}
}
}
if (!string.IsNullOrEmpty(serialCollection))
{
SkidPackingModel model = new SkidPackingModel();
HeaderContent.SkidPacks = _repo.AddSerialToSkid(epiSession, HeaderContent.Id, Convert.ToInt32(id), serialCollection.Substring(0, serialCollection.Length - 1)).ToList();
ListSkidWithinSerial(HeaderContent.SkidPacks.Where(i => i.PackStyleId == Convert.ToInt32(styleId)));
ListSerialCuttingToGrid(HeaderContent.SerialLines.Where(i => i.PackStyleId == Convert.ToInt32(styleId)));
}
}
public IEnumerable<SkidPackingModel> AddSkidPacking(SessionInfo _session, SkidPackingModel pack)
{
string sql = string.Empty;
sql += string.Format(@"INSERT INTO ucc_pkg_SkidDesignPacking
(Plant
,HeadLineID
,PackStyleLineID
,Seq
,SkidNumber
,Description
,CompleteFlag
,CreationDate
,LastUpdateDate
,CreatedBy
,UpdatedBy)
VALUES
(N'{0}' --<Plant, nvarchar(8),>
,{1} --<HeadLineID, int,>
,{2} --<PackStyleLineID, int,>
,{3} --<Seq, int,>
,N'{4}' --<SkidNumber, nvarchar(45),>
,N'{5}' --<Description, nvarchar(100),>
,{6} --<CompleteFlag, int,>
,GETDATE() --<CreationDate, datetime,>
,GETDATE() --<LastUpdateDate, datetime,>
,N'{7}' --<CreatedBy, nvarchar(45),>
,N'{7}' --<UpdatedBy, nvarchar(45),>
)" + Environment.NewLine
, _session.PlantID
, pack.HeadLineID
, pack.PackStyleId
, pack.Seq
, pack.SkidNumber
, pack.Description
, 0
, _session.UserID);
Repository.Instance.ExecuteWithTransaction(sql, "Add Skid");
return GetSkidPackingsByWork(pack.HeadLineID);
}