private void GetWeek(int id, int year) { WeeklyProductionCapacityBO objWeeklyProduntionCapacity = new WeeklyProductionCapacityBO(); objWeeklyProduntionCapacity.ID = id; objWeeklyProduntionCapacity.GetObject(); WeekComboBox.Text = year + "/" + objWeeklyProduntionCapacity.WeekNo.ToString(); }
protected void OnShipmentKeyComboBoxSelectionChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e) { var index = RadComboShipmentKey.SelectedIndex; if (index < 0) { return; } var selectedModel = ShipmentKeys[index]; if (selectedModel == null) { return; } var selectedItem = RadComboShipmentKey.SelectedItem; if (selectedItem == null) { return; } EnableOrDisableInvoiceInformationControls(true); LoadBillToAndShipTo(); LoadBanks(); LoadShipmentModes(); LoadStatus(); LoadPorts(); var weeklyCapacityId = int.Parse(WeekComboBox.SelectedItem.Value); var obj = new WeeklyProductionCapacityBO { ID = weeklyCapacityId }; obj.GetObject(); int invoiceId; var invoices = DB.Invoice(weeklyCapacityId, selectedModel.ShipToID, selectedModel.ShipmentDate.GetSQLDateString()); if (invoices.Count == 0) { invoiceId = DB.CreateInvoice(weeklyCapacityId, selectedModel.ShipToID, selectedModel.PortID, obj.WeekendDate.Year + obj.WeekendDate.Month.ToString().PadLeft(2, '0') + obj.WeekendDate.Day.ToString().PadLeft(2, '0'), selectedModel.ShipmentDate.GetSQLDateString(), selectedModel.PriceTermID, selectedModel.ShipmentModeID, LoggedUser.ID); } else { invoiceId = invoices[0].ID; } if (invoiceId != 0) { btnCreateInvoice.Visible = true; dvNewContent.Visible = true; CostSheetButton.Visible = true; ItemsPanel.Visible = true; LoadInvoiceItems(invoiceId); } }
private WeeklyProductionCapacityBO GetWeeklyProductionCapacityDetails(int id) { WeeklyProductionCapacityBO objWeeklyProduntionCapacity = new WeeklyProductionCapacityBO(); objWeeklyProduntionCapacity.ID = id; objWeeklyProduntionCapacity.GetObject(); return(objWeeklyProduntionCapacity); }
protected void linkSave_ServerClick(object sender, EventArgs e) { if (!IsNotRefresh) { return; } try { using (var ts = new TransactionScope()) { foreach (GridDataItem item in this.RadGridProductionCapacities.Items) { var linkSave = (HtmlAnchor)item.FindControl("linkSave"); var txtCapacity = (TextBox)item.FindControl("txtCapacity"); var txtHoliydays = (TextBox)item.FindControl("txtHoliydays"); var txtNotes = (TextBox)item.FindControl("txtNotes"); var txtSalesTarget = (TextBox)item.FindControl("txtSalesTarget"); var id = int.Parse(((System.Web.UI.HtmlControls.HtmlControl)(linkSave)).Attributes["pcid"].ToString()); if (id <= 0) { continue; } var objProductionCapacity = new WeeklyProductionCapacityBO(ObjContext) { ID = id }; objProductionCapacity.GetObject(); objProductionCapacity.Capacity = int.Parse(txtCapacity.Text.Replace(",", string.Empty)); objProductionCapacity.NoOfHolidays = (!string.IsNullOrEmpty(txtHoliydays.Text)) ? int.Parse(txtHoliydays.Text) : 0; objProductionCapacity.Notes = txtNotes.Text; objProductionCapacity.SalesTarget = Convert.ToDecimal(txtSalesTarget.Text); } ObjContext.SaveChanges(); ts.Complete(); } } catch (Exception ex) { IndicoLogging.log.Error("Error occured while updaing Production Capacities Details in ViewProductionCapacities.aspx", ex); } PopulateDataGrid(); }
protected void btnNewCorrectDates_Click(object sender, EventArgs e) { for (int j = 2013; j <= 2018; j++) { bool isLeap = false; string currentYear = j.ToString(); List <WeeklyProductionCapacityBO> lstWeeklyProdCap = (new WeeklyProductionCapacityBO()).SearchObjects(); DateTime dFirst = DateTime.Parse("01 / 01 /" + currentYear); DateTime dLast = DateTime.Parse("31 / 12 /" + currentYear); if ((int.Parse(currentYear) % 4 == 0) && (int.Parse(currentYear) % 100 != 0) || (int.Parse(currentYear) % 400 == 0)) { isLeap = true; } int weekCount = (isLeap == true) ? this.GetWeeksInYear(int.Parse(currentYear), dLast) : int.Parse((dLast.Subtract(dFirst).Days / 7).ToString()); DateTime firstTuesday = dFirst; while (firstTuesday.DayOfWeek != DayOfWeek.Tuesday) { firstTuesday = firstTuesday.AddDays(1); } DateTime firstFriday = dFirst; while (firstFriday.DayOfWeek != DayOfWeek.Friday) { firstFriday = firstFriday.AddDays(1); } for (int i = 1; i <= weekCount; i++) { WeeklyProductionCapacityBO objProductionCapacity = new WeeklyProductionCapacityBO(this.ObjContext); foreach (WeeklyProductionCapacityBO k in objProductionCapacity.GetAllObject()) { if (k.WeekNo == i && k.WeekendDate.Year == firstFriday.Year && k.WeekendDate.Month == firstFriday.Month && k.WeekendDate.Day == firstFriday.Day) { WeeklyProductionCapacityBO update = new WeeklyProductionCapacityBO(this.ObjContext); update.ID = k.ID; update.GetObject(); update.WeekendDate = firstTuesday; this.ObjContext.SaveChanges(); break; } } firstTuesday = firstTuesday.AddDays(7); firstFriday = firstFriday.AddDays(7); } } }
protected void OnlnkEditCapacityClick(object sender, EventArgs e) { try { foreach (GridDataItem item in WeeklyPiecesSummaryRedGrid.Items) { var txtCapacity = (TextBox)item.FindControl("txtCapacity"); var txtHolidays = (TextBox)item.FindControl("txtHolidays"); var txtSalesTarget = (TextBox)item.FindControl("txtSalesTarget"); var linkEditCapacity = (LinkButton)item.FindControl("linkEditCapacity"); var pcid = int.Parse(linkEditCapacity.Attributes["pcid"]); if (pcid <= 0 || txtCapacity == null || txtHolidays == null) { continue; } using (var ts = new TransactionScope()) { var objWeeklyProductionCapacity = new WeeklyProductionCapacityBO(ObjContext) { ID = pcid }; objWeeklyProductionCapacity.GetObject(); var capacity = txtCapacity.Text.Replace(",", ""); objWeeklyProductionCapacity.Capacity = int.Parse(capacity); objWeeklyProductionCapacity.NoOfHolidays = int.Parse(txtHolidays.Text); objWeeklyProductionCapacity.SalesTarget = decimal.Parse(txtSalesTarget.Text); ObjContext.SaveChanges(); ts.Complete(); } } } catch (Exception ex) { IndicoLogging.log.Error("Error occurred while editing weekly capacity and weekly holidays in ViewWeeklyCpacities.aspx", ex); } PopulateDataGrid(); }
protected void btnSaveChanges_Click(object sender, EventArgs e) { int itemId = int.Parse(this.hdnSelectedProductionCapacityID.Value.ToString().Trim()); if (Page.IsValid) { this.ProcessForm(itemId, false); Response.Redirect("/ViewProductionCapacities.aspx"); } else { WeeklyProductionCapacityBO objProductionCapacity = new WeeklyProductionCapacityBO(); objProductionCapacity.ID = itemId; objProductionCapacity.GetObject(); lblWeekNo.Text = objProductionCapacity.WeekNo + "_" + objProductionCapacity.WeekendDate.Year; lblFridayOfWeekPop.Text = objProductionCapacity.WeekendDate.ToString("dd/MM/yyy"); ViewState["IsPageValied"] = (Page.IsValid); this.validationSummary.Visible = !(Page.IsValid); } }
protected void linkEditCapacity_Click(object sender, EventArgs e) { try { foreach (GridDataItem item in RadGridWeeklySummary.Items) { TextBox txtCapacity = (TextBox)item.FindControl("txtCapacity"); TextBox txtHolidays = (TextBox)item.FindControl("txtHolidays"); TextBox txtSalesTarget = (TextBox)item.FindControl("txtSalesTarget"); LinkButton linkEditCapacity = (LinkButton)item.FindControl("linkEditCapacity"); int pcid = int.Parse(linkEditCapacity.Attributes["pcid"].ToString()); if (pcid > 0 && txtCapacity != null && txtHolidays != null) { using (TransactionScope ts = new TransactionScope()) { WeeklyProductionCapacityBO objWeeklyProductionCapacity = new WeeklyProductionCapacityBO(this.ObjContext); objWeeklyProductionCapacity.ID = pcid; objWeeklyProductionCapacity.GetObject(); string capacity = txtCapacity.Text.Replace(",", ""); objWeeklyProductionCapacity.Capacity = int.Parse(capacity); objWeeklyProductionCapacity.NoOfHolidays = int.Parse(txtHolidays.Text); objWeeklyProductionCapacity.SalesTarget = decimal.Parse(txtSalesTarget.Text); this.ObjContext.SaveChanges(); ts.Complete(); } } } } catch (Exception ex) { IndicoLogging.log.Error("Error occured while editing weekly capcity and weekly holidays in ViewWeeklyCpacities.aspx", ex); } this.PopulateDataGrid(); }
private void ProcessForm(int queryId, bool isDelete) { try { using (TransactionScope ts = new TransactionScope()) { WeeklyProductionCapacityBO objProductionCapacity = new WeeklyProductionCapacityBO(this.ObjContext); if (queryId > 0) { objProductionCapacity.ID = queryId; objProductionCapacity.GetObject(); } if (isDelete) { objProductionCapacity.Delete(); } else { //objProductionCapacity.Name = this.txtAttributeName.Text; //objProductionCapacity.Description = this.txtDescription.Text; if (queryId == 0) { objProductionCapacity.Add(); } } this.ObjContext.SaveChanges(); ts.Complete(); } } catch (Exception ex) { // Log the error //IndicoLogging.log("Error occured while Adding the Item", ex); } }
//last modified by - rusith private void PopulateProductionCapacityDetails(int proCapID) { if (IsNotRefresh) { var objProCap = new WeeklyProductionCapacityBO(); objProCap.ID = proCapID; objProCap.GetObject(); lblWeekNo.Text = objProCap.WeekNo + "-" + objProCap.WeekendDate.Year; lblFridayOfWeekPop.Text = objProCap.WeekendDate.ToString("dd MMMM yyyy"); this.txtWorkingDays.Text = objProCap.NoOfHolidays.ToString(); txtWorkingHours.Text = objProCap.HoursPerDay.ToString(); txtOrderCutOffDate.Text = objProCap.OrderCutOffDate.HasValue ? objProCap.OrderCutOffDate.Value.ToString("dd MMMM yyyy") : string.Empty; txtETD.Text = objProCap.EstimatedDateOfDespatch.HasValue ? objProCap.EstimatedDateOfDespatch.Value.ToString("dd MMMM yyyy") : string.Empty; txtETA.Text = objProCap.EstimatedDateOfArrival.HasValue ? objProCap.EstimatedDateOfArrival.Value.ToString("dd MMMM yyyy") : string.Empty; txtNotes.Text = objProCap.Notes; txtSalesTaget.Text = objProCap.SalesTarget.GetValueOrDefault().ToString(); var objCapacity = new WeeklyProductionCapacityDetailsBO { WeeklyProductionCapacity = proCapID }; var lstCapDetails = objCapacity.SearchObjects(); var lstTypes = (new ItemTypeBO()).SearchObjects(); var lstProductCapacityDetails = lstTypes.Select(objType => new KeyValuePair <ItemTypeBO, KeyValuePair <WeeklyProductionCapacityBO, WeeklyProductionCapacityDetailsBO> >(objType, new KeyValuePair <WeeklyProductionCapacityBO, WeeklyProductionCapacityDetailsBO>(objProCap, lstCapDetails.FirstOrDefault(m => m.ItemType == objType.ID)))).ToList(); rptItemTypes.DataSource = lstProductCapacityDetails; rptItemTypes.DataBind(); ViewState["IsPopulateModel"] = true; } else { ViewState["IsPopulateModel"] = false; ViewState["IsPageValid"] = true; } }
private void ProcessForm(int queryId, bool isDelete) { try { using (var ts = new TransactionScope()) { var objProductionCapacity = new WeeklyProductionCapacityBO(ObjContext); if (queryId > 0) { objProductionCapacity.ID = queryId; objProductionCapacity.GetObject(); } if (isDelete) { objProductionCapacity.Delete(); } else { objProductionCapacity.NoOfHolidays = int.Parse(txtWorkingDays.Text); objProductionCapacity.HoursPerDay = decimal.Parse(txtWorkingHours.Text); objProductionCapacity.OrderCutOffDate = DateTime.Parse(txtOrderCutOffDate.Text); objProductionCapacity.EstimatedDateOfDespatch = DateTime.Parse(txtETD.Text); objProductionCapacity.EstimatedDateOfArrival = DateTime.Parse(txtETA.Text); objProductionCapacity.Notes = txtNotes.Text; objProductionCapacity.SalesTarget = decimal.Parse(txtSalesTaget.Text); foreach (RepeaterItem rptItem in rptItemTypes.Items) { var hdnProdCapDetailID = (HiddenField)rptItem.FindControl("hdnProdCapDetailID"); var hdnItemTypeID = (HiddenField)rptItem.FindControl("hdnItemTypeID"); var txtTotalCapacity = (TextBox)rptItem.FindControl("txtTotalCapacity"); var txt5PcsCapacity = (TextBox)rptItem.FindControl("txt5PcsCapacity"); var txtSampleCapacity = (TextBox)rptItem.FindControl("txtSampleCapacity"); var txtWorkers = (TextBox)rptItem.FindControl("txtWorkers"); var txtEfficiency = (TextBox)rptItem.FindControl("txtEfficiency"); var objProdCapDetailBO = new WeeklyProductionCapacityDetailsBO(ObjContext); if (int.Parse(hdnProdCapDetailID.Value) > 0) { objProdCapDetailBO.ID = int.Parse(hdnProdCapDetailID.Value); objProdCapDetailBO.GetObject(); } else { objProdCapDetailBO.WeeklyProductionCapacity = queryId; objProdCapDetailBO.ItemType = int.Parse(hdnItemTypeID.Value); } objProdCapDetailBO.TotalCapacity = int.Parse(txtTotalCapacity.Text) * objProductionCapacity.NoOfHolidays; objProdCapDetailBO.FivePcsCapacity = int.Parse(txt5PcsCapacity.Text) * objProductionCapacity.NoOfHolidays; objProdCapDetailBO.SampleCapacity = int.Parse(txtSampleCapacity.Text) * objProductionCapacity.NoOfHolidays; objProdCapDetailBO.Workers = int.Parse(txtWorkers.Text); objProdCapDetailBO.Efficiency = decimal.Parse(txtEfficiency.Text); } if (queryId == 0) { objProductionCapacity.Add(); } } ObjContext.SaveChanges(); ts.Complete(); } } catch (Exception ex) { IndicoLogging.log.Error("Error occurred while Adding or Editing or Deleting the details in Production Capacity", ex); } }