protected void btnDelete_Click(object sender, EventArgs e)
{
//NNM
int id = int.Parse(this.hdnSelectedID.Value);
int indexid = int.Parse(this.hdnIndexID.Value);
int orderdetail = int.Parse(this.hdnOrderDetail.Value);
try
{
if (id > 0)
{
using (TransactionScope ts = new TransactionScope())
{
InvoiceOrderBO objInvoiceOrder = new InvoiceOrderBO(this.ObjContext);
objInvoiceOrder.ID = id;
objInvoiceOrder.GetObject();
objInvoiceOrder.Delete();
this.ObjContext.SaveChanges();
ts.Complete();
}
this.populateInvoiceOrders(this.QueryID, this.DistributorClientAddress, false, this.ShipmentModeID, false);
}
else
{
if (indexid > -1)
{
List <ReturnInvoiceOrderDetailViewBO> lstInvoiceOrderDetailView = (List <ReturnInvoiceOrderDetailViewBO>)Session["InvoiceOrderDetails"];
lstInvoiceOrderDetailView.RemoveAt(indexid);
Session["InvoiceOrderDetails"] = lstInvoiceOrderDetailView;
this.RadInvoice.DataSource = lstInvoiceOrderDetailView;
this.RadInvoice.DataBind();
}
}
// changing the orderdetail shipment date and scheduled date and delete the packing list details
//this.ChangeOrderDetails(orderdetail, id);
}
catch (Exception ex)
{
IndicoLogging.log.Error("Error occured while deleting or removing order details from the AddEditInvoicePage.aspx", ex);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int invoiceID = int.Parse(hdnSelectedID.Value.Trim());
if (invoiceID > 0)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
InvoiceBO objInvoice = new InvoiceBO(this.ObjContext);
objInvoice.ID = invoiceID;
objInvoice.GetObject();
List <InvoiceOrderBO> lstInvoiceOrder = (new InvoiceOrderBO()).GetAllObject().Where(o => o.Invoice == objInvoice.ID).ToList();
foreach (InvoiceOrderBO objDelInvoiceOrder in lstInvoiceOrder)
{
InvoiceOrderBO objInvoiceOrder = new InvoiceOrderBO(this.ObjContext);
objInvoiceOrder.ID = objDelInvoiceOrder.ID;
objInvoiceOrder.GetObject();
objInvoiceOrder.Delete();
}
objInvoice.Delete();
this.ObjContext.SaveChanges();
ts.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
this.PopulateDataGrid();
}
}
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);
}
}
private void ProcessForm()
{
//NNM
try
{
using (TransactionScope ts = new TransactionScope())
{
#region Create InvoiceHeader
InvoiceBO objInvoice = new InvoiceBO(this.ObjContext);
if (QueryID > 0)
{
objInvoice.ID = this.QueryID;
objInvoice.GetObject();
}
else
{
objInvoice.Creator = this.LoggedUser.ID;
objInvoice.CreatedDate = DateTime.Now;
}
objInvoice.InvoiceNo = this.txtInvoiceNo.Text;
objInvoice.InvoiceDate = Convert.ToDateTime(this.txtInvoiceDate.Text);
objInvoice.ShipTo = this.DistributorClientAddress;
objInvoice.AWBNo = this.txtAwbNo.Text;
objInvoice.WeeklyProductionCapacity = int.Parse(this.RadComboWeek.SelectedValue);
objInvoice.ShipmentMode = this.ShipmentModeID;
objInvoice.IndimanInvoiceNo = (this.LoggedUserRoleName == UserRole.IndimanAdministrator) ? this.txtIndimanInvoiceNo.Text : string.Empty;
objInvoice.IsBillTo = this.chkIsBillTo.Checked;
objInvoice.BillTo = (this.chkIsBillTo.Checked) ? int.Parse(this.ddlBillTo.SelectedValue) : 22;
objInvoice.Bank = int.Parse(this.ddlBank.SelectedValue);
if (this.LoggedUserRoleName == UserRole.IndimanAdministrator)
{
objInvoice.IndimanInvoiceDate = Convert.ToDateTime(this.txtIndimanInvoiceDate.Text);
}
objInvoice.Modifier = this.LoggedUser.ID;
objInvoice.ModifiedDate = DateTime.Now;
this.ObjContext.SaveChanges();
ViewState["InvoiceId"] = objInvoice.ID;
#endregion
#region InvoiceOrderDetail
foreach (GridDataItem item in RadInvoice.Items)
{
TextBox txtRate = (TextBox)item.FindControl("txtRate");
int id = int.Parse(((System.Web.UI.WebControls.WebControl)(txtRate)).Attributes["invoiceorder"].ToString());
int orderdetail = int.Parse(((System.Web.UI.WebControls.WebControl)(txtRate)).Attributes["orderdetail"].ToString());
TextBox txtIndimanRate = (TextBox)item.FindControl("txtIndimanRate");
InvoiceOrderBO objInvoiceOrder = new InvoiceOrderBO(this.ObjContext);
if (id > 0)
{
objInvoiceOrder.ID = id;
objInvoiceOrder.GetObject();
}
objInvoiceOrder.Invoice = int.Parse(ViewState["InvoiceId"].ToString());
objInvoiceOrder.OrderDetail = orderdetail;
objInvoiceOrder.FactoryPrice = Convert.ToDecimal(txtRate.Text);
objInvoiceOrder.IndimanPrice = (this.LoggedUserRoleName == UserRole.IndimanAdministrator) ? Convert.ToDecimal(txtIndimanRate.Text) : Convert.ToDecimal("0");
}
this.ObjContext.SaveChanges();
#endregion
#region Change Order Detail Status
List <int> lstOrders = new List <int>();
int orderid = 0;
if (this.ddlStatus.SelectedItem.Text == "Shipped")
{
foreach (GridDataItem item in RadInvoice.Items)
{
TextBox txtRate = (TextBox)item.FindControl("txtRate");
int orderdetail = int.Parse(((System.Web.UI.WebControls.WebControl)(txtRate)).Attributes["orderdetail"].ToString());
OrderDetailBO objOrderDetail = new OrderDetailBO(this.ObjContext);
objOrderDetail.ID = orderdetail;
objOrderDetail.GetObject();
if (objOrderDetail.Order != orderid)
{
lstOrders.Add(objOrderDetail.Order);
orderid = objOrderDetail.Order;
}
objOrderDetail.Status = 16;
}
this.ObjContext.SaveChanges();
}
#endregion
#region Change Order Status
if (lstOrders.Count > 0)
{
foreach (int order in lstOrders)
{
OrderBO objOrder = new OrderBO(this.ObjContext);
objOrder.ID = order;
objOrder.GetObject();
objOrder.Status = 21;
}
this.ObjContext.SaveChanges();
}
#endregion
ts.Complete();
}
}
catch (Exception ex)
{
// Log the error
IndicoLogging.log.Error("Error occured while Adding or Updating Invoicing", ex);
}
}
