private List <PackingListBO> GetCartonData()
{
var PackingLists = new List <PackingListBO>();
if (Source != null)
{
PackingLists = Source;
}
else
{
OrderDetailQtyBO obj = new OrderDetailQtyBO();
obj.ID = this.OrderDetailQtyID;
obj.GetObject();
this.SizeID = obj.Size;
var objPack = new PackingListBO();
objPack.WeeklyProductionCapacity = WeekendCapacityID;
// objPack.OrderDetail = obj.OrderDetail;
objPack.CartonNo = CartonNo;
PackingLists = objPack.SearchObjects().ToList();
}
Source = PackingLists;
return(PackingLists);
}
protected void rptSizeQty_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
RepeaterItem item = e.Item;
if (item.ItemIndex > -1 && item.DataItem is OrderDetailQtyBO)
{
OrderDetailQtyBO objClientOrderQty = (OrderDetailQtyBO)item.DataItem;
Literal litHeading = (Literal)item.FindControl("litHeading");
litHeading.Text = objClientOrderQty.objSize.SizeName;
Label lblQty = (Label)item.FindControl("lblQty");
lblQty.Text = objClientOrderQty.Qty.ToString();
lblQty.Attributes.Add("Size", objClientOrderQty.Size.ToString());
}
}
private void AddItem(int orderDetailQtyID, int cartonNo)
{
OrderDetailQtyBO objOrderDetailQty = new OrderDetailQtyBO();
objOrderDetailQty.ID = orderDetailQtyID;
objOrderDetailQty.GetObject();
List <PackingListBO> lstPackingList = Source.Where(m => m.OrderDetail == objOrderDetailQty.OrderDetail && m.CartonNo == cartonNo).ToList();
if (lstPackingList.Any())
{
using (TransactionScope ts = new TransactionScope())
{
//PackingListCartonItemBO objPackListCartonItem = new PackingListCartonItemBO();
//objPackListCartonItem.PackingList = lstPackingList.SingleOrDefault().ID;
//objPackListCartonItem.Size = objOrderDetailQty.Size;
//List<PackingListCartonItemBO> lstCartonItem = objPackListCartonItem.SearchObjects();
////PackingListSizeQtyBO objPackingListSizeQty = new PackingListSizeQtyBO();
////objPackingListSizeQty.PackingList = lstPackingList.SingleOrDefault().ID;
////objPackingListSizeQty.Size = objOrderDetailQty.Size;
////List<PackingListSizeQtyBO> lstSizeQty = objPackingListSizeQty.SearchObjects();
//if (!lstCartonItem.Any())
//{
// // no records
// PackingListCartonItemBO objPackListCartonItemToSave = new PackingListCartonItemBO(this.ObjContext);
// objPackListCartonItemToSave.PackingList = objPackListCartonItem.PackingList;
// objPackListCartonItemToSave.Size = objPackListCartonItem.Size;
// objPackListCartonItemToSave.Count = 1; // objPackListCartonItem.Count + 1;
// addedSizeID = objPackListCartonItem.Size;
//}
//else if (lstCartonItem.Any() && (lstCartonItem.SingleOrDefault().Count < objOrderDetailQty.Qty))
//{
// //update
// PackingListCartonItemBO objPackListCartonItemToSave = new PackingListCartonItemBO(this.ObjContext);
// objPackListCartonItemToSave.ID = lstCartonItem.SingleOrDefault().ID;
// objPackListCartonItemToSave.GetObject();
// objPackListCartonItemToSave.Count++;
// addedSizeID = objPackListCartonItem.Size;
//}
////else if (lstCartonItem.Any() && (lstCartonItem.SingleOrDefault().Count == lstSizeQty.SingleOrDefault().Qty))
////{
//// //filled
////}
PackingListCartonItemBO objPackListCartonItem = new PackingListCartonItemBO(this.ObjContext);
objPackListCartonItem.PackingList = lstPackingList.SingleOrDefault().ID;
objPackListCartonItem.Size = objOrderDetailQty.Size;
objPackListCartonItem.Count = this.ItemNo; // objPackListCartonItem.Count + 1;
addedSizeID = objPackListCartonItem.Size;
this.ObjContext.SaveChanges();
ts.Complete();
}
DisplaySuccessMessage(cartonNo);
}
else // wrong poly bag
{
DisplayCartonErrorMessage("ස්කෑන් කරන ලද පොලි බෑගය මෙම පෙට්ටියට අදාළ නොවේ. <br/><br/>නැවත නිවැරදි පෙට්ටිය ස්කෑන් කරන්න.<br/><br/>Scanned Poly bag should not go to this Carton.<br/><br/>Please scan the correct Carton.");
}
}
private List <PackingListBO> GetPolyBagData()
{
List <PackingListBO> PackingLists = new List <PackingListBO>();
List <PackingListCartonItemBO> lstCartonItems = new List <PackingListCartonItemBO>();
PackingListBO objPacking = new PackingListBO();
if (Source != null)
{
PackingLists = Source;
}
else
{
OrderDetailQtyBO obj = new OrderDetailQtyBO();
obj.ID = this.OrderDetailQtyID;
obj.GetObject();
this.SizeID = obj.Size;
var objPack = new PackingListBO();
//objPack.WeeklyProductionCapacity = WeekendCapacityID;
objPack.OrderDetail = obj.OrderDetail;
//objPack.CartonNo = CartonNo;
DateTime monday = WeekEndDate.AddDays(-(int)WeekEndDate.DayOfWeek - 6);
// List<PackingListBO> loadedPackingLists = objPack.SearchObjects().Where(m => m.PackingListSizeQtysWhereThisIsPackingList.Where(o => o.Qty > 0).Select(s => s.Size).Contains(this.SizeID) && m.objWeeklyProductionCapacity.WeekendDate.Date == WeekEndDate.Date && m.CartonNo > 0).ToList(); //.Where(m => m.PackingListCartonItemsWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Count < m.PackingListSizeQtysWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Qty).ToList();
List <PackingListBO> loadedPackingLists = objPack.SearchObjects().Where(m => m.PackingListSizeQtysWhereThisIsPackingList.Where(s => s.Qty > 0).Select(s => s.Size).Contains(this.SizeID) && (DateTime.Compare(m.objWeeklyProductionCapacity.WeekendDate.Date, monday.Date) > -1) && m.CartonNo > 0).ToList(); //.Where(m => m.PackingListCartonItemsWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Count < m.PackingListSizeQtysWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Qty).ToList();
foreach (PackingListBO objPackingList in loadedPackingLists)
{
PackingListCartonItemBO objCartonItem = new PackingListCartonItemBO();
objCartonItem.Size = this.SizeID;
objCartonItem.PackingList = objPackingList.ID;
objCartonItem.Count = this.ItemNo;
lstCartonItems = objCartonItem.SearchObjects();
if (lstCartonItems.Any() && lstCartonItems.Count == 1)
{
this.polyBagStatus = PolyBagFillingStatus.Filled;
break;
}
else
{
PackingLists.Add(objPackingList);
this.polyBagStatus = PolyBagFillingStatus.Available;
}
}
}
if (this.polyBagStatus == PolyBagFillingStatus.Filled)
{
PackingLists.Clear();
}
Source = PackingLists;
return(PackingLists);
}
//protected void dataGridSizeSets_ItemDataBound(object sender, DataGridItemEventArgs e)
//{
// DataGridItem item = e.Item;
// if (item.ItemIndex > -1 && item.DataItem is SizeSetBO)
// {
// SizeSetBO objSizeSets = (SizeSetBO)item.DataItem;
// LinkButton linkEdit = (LinkButton)item.FindControl("linkEdit");
// linkEdit.Attributes.Add("qid", objSizeSets.ID.ToString());
// }
//}
//protected void dataGridSizeSets_SortCommand(object source, DataGridSortCommandEventArgs e)
//{
// string sortDirection = String.Empty;
// if (!SortExpression.ToUpper().StartsWith(e.SortExpression) && !SortExpression.ToUpper().Trim().EndsWith("ASC"))
// {
// sortDirection = " asc";
// }
// else
// {
// sortDirection = (SortExpression.ToUpper().EndsWith("DESC")) ? " asc" : " desc";
// }
// this.SortExpression = e.SortExpression + sortDirection;
// this.PopulateDataGrid();
// foreach (DataGridColumn col in this.dataGridSizeSets.Columns)
// {
// if (col.Visible && col.SortExpression == e.SortExpression)
// {
// col.HeaderStyle.CssClass = "selected " + ((sortDirection.ToUpper() != " DESC") ? "sortDown" : "sortUp");
// }
// else
// {
// col.HeaderStyle.CssClass = "";
// }
// }
//}
//protected void dataGridSizeSets_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
//{
// Set page index
// this.dataGridSizeSets.CurrentPageIndex = e.NewPageIndex;
// this.PopulateDataGrid();
//}
//protected void dataGridSizeSets_ItemCommand(object sender, DataGridCommandEventArgs e)
//{
// if (e.CommandName == "Edit")
// {
// List<SizeSetBO> lstExistingItems = (new SizeBO()).SearchObjects().GroupBy(o => o.SizeSet).Select(m => m.First().objSizeSet).ToList();
// this.ddlSizeSet.Items.Clear();
// this.ddlSizeSet.Items.Add(new ListItem("Select Size Set", "0"));
// foreach (SizeSetBO item in lstExistingItems)
// {
// this.ddlSizeSet.Items.Add(new ListItem(item.Name, item.ID.ToString()));
// }
// this.ddlSizeSet.Items.FindByValue(((System.Web.UI.WebControls.TableRow)(e.Item)).Cells[0].Text).Selected = true;
// this.linkAddNew.Visible = true;
// this.PopulateSizeSet(false);
// this.hdnIsNewSizeSet.Value = "0";
// }
//}
protected void dgAddEditSizes_ItemDataBound(object sender, DataGridItemEventArgs e)
{
DataGridItem item = e.Item;
//if ((item.ItemIndex > -1 && item.DataItem is SizeBO) && (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem))
if (item.ItemIndex > -1 && item.DataItem is KeyValuePair <int, SizeBO> )
{
KeyValuePair <int, SizeBO> objSize = (KeyValuePair <int, SizeBO>)item.DataItem;
bool canDelete = true;
if (objSize.Key > 0)
{
//bool canDelete = (objSize.OrderDetailQtysWhereThisIsSize.Count == 0 && objSize.SizeChartsWhereThisIsSize.Count == 0);
OrderDetailQtyBO objODQ = new OrderDetailQtyBO();
objODQ.Size = objSize.Key;
SizeChartBO objSC = new SizeChartBO();
objSC.Size = objSize.Key;
canDelete = !(objSC.SearchObjects().Any() || objODQ.SearchObjects().Any());
}
/*CheckBox chkIsDefault = (CheckBox)item.FindControl("chkIsDefault");
* chkIsDefault.Checked = objSize.IsDefault;
* chkIsDefault.Enabled = false;
*
* Literal lblID = (Literal)item.FindControl("lblID");
* lblID.Text = objSize.ID.ToString();
*
* Literal lblSeqNo = (Literal)item.FindControl("lblSeqNo");
* lblSeqNo.Text = objSize.SeqNo.ToString();
*
* Literal lblSizeName = (Literal)item.FindControl("lblSizeName");
* lblSizeName.Text = objSize.SizeName;
*
* LinkButton linkEdit = (LinkButton)item.FindControl("linkEdit");
* linkEdit.Attributes.Add("qid", objSize.ID.ToString());*/
HyperLink linkDelete = (HyperLink)item.FindControl("linkDelete");
linkDelete.Attributes.Add("qid", objSize.Key.ToString());
linkDelete.Visible = canDelete;
/*}
* else if ((item.ItemIndex > -1 && item.DataItem is SizeBO) && (item.ItemType == ListItemType.EditItem))
* {
* SizeBO objSize = (SizeBO)item.DataItem;*/
CheckBox chkIsDefault = (CheckBox)item.FindControl("chkIsDefault");
chkIsDefault.Checked = objSize.Value.IsDefault;
chkIsDefault.Enabled = true;
Literal lblID = (Literal)item.FindControl("lblID");
lblID.Text = objSize.Key.ToString();
TextBox txtSeqNo = (TextBox)item.FindControl("txtSeqNo");
txtSeqNo.Text = objSize.Value.SeqNo.ToString();
this.hdnSeqNo.Value = txtSeqNo.Text;
TextBox txtSizeName = (TextBox)item.FindControl("txtSizeName");
txtSizeName.Text = objSize.Value.SizeName;
this.hdnSizeName.Value = txtSizeName.Text;
//LinkButton linkSave = (LinkButton)item.FindControl("linkSave");
//linkSave.Attributes.Add("qid", objSize.ID.ToString());
//linkSave.CommandName = (!string.IsNullOrEmpty(hdnSizeName.Value) || (int.Parse(this.hdnSeqNo.Value) > 0)) ? "Update" : "Save";
}
}
private void ChangeOrderDetails(int orderdetail, int invoiceorder)
{
try
{
if (orderdetail > 0)
{
InvoiceOrderBO objInvoiceOrder = new InvoiceOrderBO(this.ObjContext);
objInvoiceOrder.ID = invoiceorder;
objInvoiceOrder.GetObject();
DateTime nextmonday = objInvoiceOrder.objOrderDetail.SheduledDate.AddDays(7 - objInvoiceOrder.objOrderDetail.SheduledDate.DayOfWeek == DayOfWeek.Monday ? 7 : (int)objInvoiceOrder.objOrderDetail.SheduledDate.DayOfWeek);
using (TransactionScope ts = new TransactionScope())
{
PackingListBO objPList = new PackingListBO();
objPList.OrderDetail = orderdetail;
List <PackingListBO> lstPackingLists = objPList.SearchObjects();
foreach (PackingListBO objpl in lstPackingLists)
{
PackingListSizeQtyBO objPlsq = new PackingListSizeQtyBO();
objPlsq.PackingList = objpl.ID;
List <PackingListSizeQtyBO> lstPackingListSizeQty = objPlsq.SearchObjects();
// delete the PackingListSizeQtyBO details
foreach (PackingListSizeQtyBO objplsqi in lstPackingListSizeQty)
{
PackingListSizeQtyBO objPackingListSizeQtyItem = new PackingListSizeQtyBO(this.ObjContext);
objPackingListSizeQtyItem.ID = objplsqi.ID;
objPackingListSizeQtyItem.GetObject();
objPackingListSizeQtyItem.Delete();
}
//this.ObjContext.SaveChanges();
PackingListCartonItemBO objPLCI = new PackingListCartonItemBO();
objPLCI.PackingList = objpl.ID;
List <PackingListCartonItemBO> lstPackingListCartonItems = objPLCI.SearchObjects();
// delete the PackingListCartonItemBO details
foreach (PackingListCartonItemBO objplci in lstPackingListCartonItems)
{
PackingListCartonItemBO objPackingListCartonItem = new PackingListCartonItemBO(this.ObjContext);
objPackingListCartonItem.ID = objplci.ID;
objPackingListCartonItem.GetObject();
objPackingListCartonItem.Delete();
}
//this.ObjContext.SaveChanges();
// delete the PackingListBO details
PackingListBO objPackingList = new PackingListBO(this.ObjContext);
objPackingList.ID = objpl.ID;
objPackingList.GetObject();
objPackingList.Delete();
}
//Creating new packing list record for next week
List <WeeklyProductionCapacityBO> lstwpc = (new WeeklyProductionCapacityBO()).SearchObjects().Where(o => o.WeekendDate >= nextmonday && o.WeekendDate <= nextmonday.AddDays(7)).ToList();
PackingListBO objp = new PackingListBO();
objp.WeeklyProductionCapacity = lstwpc[0].ID;
List <PackingListBO> lst = objp.SearchObjects();
if (lst.Count > 0)
{
PackingListBO objNewPl = new PackingListBO(this.ObjContext);
objNewPl.Carton = 1;
objNewPl.CartonNo = 0;
objNewPl.CreatedDate = objNewPl.ModifiedDate = DateTime.Now;
objNewPl.Creator = objNewPl.Modifier = this.LoggedUser.ID;
objNewPl.OrderDetail = orderdetail;
objNewPl.WeeklyProductionCapacity = lstwpc[0].ID;
objNewPl.PackingQty = 0;
this.ObjContext.SaveChanges();
int Newplid = objNewPl.ID;
OrderDetailQtyBO objOrderDetailqty = new OrderDetailQtyBO();
objOrderDetailqty.OrderDetail = orderdetail;
List <OrderDetailQtyBO> lstOrderDetailsQty = objOrderDetailqty.SearchObjects();
foreach (OrderDetailQtyBO objOdq in lstOrderDetailsQty)
{
if (objOdq.Qty > 0)
{
PackingListSizeQtyBO objPackingListSizeQty = new PackingListSizeQtyBO(this.ObjContext);
objPackingListSizeQty.PackingList = Newplid;
objPackingListSizeQty.Size = objOdq.Size;
}
}
}
//this.ObjContext.SaveChanges();
//change the shipment date, scheduled date
OrderDetailBO objOrderDetail = new OrderDetailBO(this.ObjContext);
objOrderDetail.ID = orderdetail;
objOrderDetail.GetObject();
objOrderDetail.SheduledDate = nextmonday;
objOrderDetail.ShipmentDate = nextmonday;
this.ObjContext.SaveChanges();
ts.Complete();
}
}
}
catch (Exception ex)
{
IndicoLogging.log.Error("Error occured while deleting or adding packing list details and changing the shipment date and scheduled date from the AddEditInvoce.aspx", ex);
}
}
