private void DeleteML(int queryId) { try { using (TransactionScope ts = new TransactionScope()) { MeasurementLocationBO objMeasurementLocation = new MeasurementLocationBO(this.ObjContext); if (queryId > 0) { objMeasurementLocation.ID = queryId; objMeasurementLocation.GetObject(); foreach (SizeChartBO schart in objMeasurementLocation.SizeChartsWhereThisIsMeasurementLocation) { SizeChartBO objSizeChart = new SizeChartBO(this.ObjContext); objSizeChart.ID = schart.ID; objSizeChart.GetObject(); objSizeChart.Delete(); this.ObjContext.SaveChanges(); } objMeasurementLocation.Delete(); } this.ObjContext.SaveChanges(); ts.Complete(); } } catch (Exception ex) { IndicoLogging.log.Error("Error occured while Deleting the Measurement Location", ex); } }
//protected void dgMeasurementLocation_ItemDataBound(object sender, DataGridItemEventArgs e) //{ // DataGridItem item = e.Item; // if (item.ItemIndex > -1 && item.DataItem is ItemBO) // { // ItemBO objItem = (ItemBO)item.DataItem; // Literal lblItem = (Literal)item.FindControl("lblItem"); // lblItem.Text = objItem.Name; // LinkButton linkEdit = (LinkButton)item.FindControl("linkEdit"); // linkEdit.Attributes.Add("qid", objItem.ID.ToString()); // } //} //protected void dgMeasurementLocation_PageIndexChanged(object sender, DataGridPageChangedEventArgs e) //{ // // Set page index // this.dgMeasurementLocation.CurrentPageIndex = e.NewPageIndex; // this.PopulateDataGrid(); //} //protected void dgMeasurementLocation_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.dgMeasurementLocation.Columns) // { // if (col.Visible && col.SortExpression == e.SortExpression) // { // col.HeaderStyle.CssClass = "selected " + ((sortDirection.ToUpper() != " DESC") ? "sortDown" : "sortUp"); // } // else // { // col.HeaderStyle.CssClass = ((col.HeaderStyle.CssClass == "hide") ? "hide" : string.Empty); // } // } //} //protected void dgMeasurementLocation_ItemCommand(object source, DataGridCommandEventArgs e) //{ // if (e.CommandName == "Edit") // { // } //} protected void dgAddEditMLs_ItemDataBound(object sender, DataGridItemEventArgs e) { DataGridItem item = e.Item; if ((item.ItemIndex > -1 && item.DataItem is MeasurementLocationBO) && (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem)) { MeasurementLocationBO objMeasurementLocation = (MeasurementLocationBO)item.DataItem; // bool canDelete = (objMeasurementLocation.SizeChartsWhereThisIsMeasurementLocation.Count == 0); CheckBox chkIsSend = (CheckBox)item.FindControl("chkIsSend"); chkIsSend.Checked = (bool)objMeasurementLocation.IsSend; chkIsSend.Enabled = false; Label lblID = (Label)item.FindControl("lblID"); lblID.Text = objMeasurementLocation.ID.ToString(); Label lblKey = (Label)item.FindControl("lblKey"); lblKey.Text = objMeasurementLocation.Key; Label lblName = (Label)item.FindControl("lblName"); lblName.Text = objMeasurementLocation.Name; LinkButton linkEdit = (LinkButton)item.FindControl("linkEdit"); linkEdit.Attributes.Add("qid", objMeasurementLocation.ID.ToString()); HyperLink linkDelete = (HyperLink)item.FindControl("linkDelete"); linkDelete.Attributes.Add("qid", objMeasurementLocation.ID.ToString()); //linkDelete.Visible = canDelete; } else if ((item.ItemIndex > -1 && item.DataItem is MeasurementLocationBO) && (item.ItemType == ListItemType.EditItem)) { MeasurementLocationBO objMeasurementLocation = (MeasurementLocationBO)item.DataItem; CheckBox chkIsSend = (CheckBox)item.FindControl("chkIsSend"); chkIsSend.Checked = objMeasurementLocation.IsSend ?? false; Label lblID = (Label)item.FindControl("lblID"); lblID.Text = objMeasurementLocation.ID.ToString(); chkIsSend.Enabled = true; TextBox txtKey = (TextBox)item.FindControl("txtKey"); txtKey.Text = objMeasurementLocation.Key; this.hdnKey.Value = txtKey.Text; TextBox txtName = (TextBox)item.FindControl("txtName"); txtName.Text = objMeasurementLocation.Name; this.hdnName.Value = txtName.Text; LinkButton linkSave = (LinkButton)item.FindControl("linkSave"); linkSave.Attributes.Add("qid", objMeasurementLocation.ID.ToString()); linkSave.CommandName = (!string.IsNullOrEmpty(hdnName.Value) || !string.IsNullOrEmpty(this.hdnKey.Value)) ? "Update" : "Save"; } }
private void PopulateDataGrid() { // Hide Controls this.dvEmptyContent.Visible = false; this.dvDataContent.Visible = false; this.dvNoSearchResult.Visible = false; // Search text string searchText = this.txtSearch.Text.ToLower().Trim(); // Populate Items //ItemBO objItem = new ItemBO(); MeasurementLocationBO objMeasurementLocation = new MeasurementLocationBO(); List <ItemBO> lstItems = new List <ItemBO>(); if ((searchText != string.Empty) && (searchText != "search")) { lstItems = objMeasurementLocation.SearchObjects().AsQueryable().OrderBy(SortExpression).GroupBy(o => o.Item).Select(m => m.First().objItem).Where(o => o.Name.ToLower().Contains(searchText)).ToList(); } else { lstItems = objMeasurementLocation.SearchObjects().AsQueryable().OrderBy(SortExpression).GroupBy(o => o.Item).Select(m => m.First().objItem).ToList(); } if (lstItems.Count > 0) { this.RadGridMeasurements.AllowPaging = (lstItems.Count > this.RadGridMeasurements.PageSize); this.RadGridMeasurements.DataSource = lstItems; this.RadGridMeasurements.DataBind(); Session["MeasurementDetails"] = lstItems; this.dvDataContent.Visible = true; } else if ((searchText != string.Empty && searchText != "search")) { this.lblSerchKey.Text = searchText + ((searchText != string.Empty) ? " - " : string.Empty); this.dvDataContent.Visible = true; this.dvNoSearchResult.Visible = true; } else { this.dvEmptyContent.Visible = true; this.btnAddMeasurementLocation.Visible = false; } //this.lblSerchKey.Text = string.Empty; this.RadGridMeasurements.Visible = (lstItems.Count > 0); }
private void PopulateML(bool addNewRecorde, int editItemIndex, int currentPageIndex) { if (this.IsNotRefresh) { this.dgAddEditMLs.CurrentPageIndex = currentPageIndex; this.dgAddEditMLs.EditItemIndex = editItemIndex; MeasurementLocationBO obj = new MeasurementLocationBO(); obj.Item = int.Parse(this.ddlItem.SelectedValue.ToString()); List <MeasurementLocationBO> lstEmptyList = (from o in obj.SearchObjects() orderby o.Key select o).ToList(); if (addNewRecorde || lstEmptyList.Count == 0) { MeasurementLocationBO objMeasurementLocation = new MeasurementLocationBO(); objMeasurementLocation.ID = 0; objMeasurementLocation.Item = int.Parse(this.ddlItem.SelectedValue.ToString()); objMeasurementLocation.Key = string.Empty; objMeasurementLocation.Name = string.Empty; lstEmptyList.Insert(0, objMeasurementLocation); if (dgAddEditMLs.CurrentPageIndex > Math.Floor((double)(lstEmptyList.Count / dgAddEditMLs.PageSize))) { dgAddEditMLs.CurrentPageIndex = Convert.ToInt32(Math.Floor((double)(lstEmptyList.Count / dgAddEditMLs.PageSize))); } this.dgAddEditMLs.EditItemIndex = 0;// lstEmptyList.Count - 1; } this.dgAddEditMLs.DataSource = lstEmptyList; //this.dgAddEditMLs.AllowPaging = (lstEmptyList.Count > dgAddEditMLs.PageSize); this.dgAddEditMLs.DataBind(); ViewState["IsPopulateModel"] = true; } else { ViewState["IsPopulateModel"] = false; } }
private void ProcessML(bool isNewML) { try { using (TransactionScope ts = new TransactionScope()) { MeasurementLocationBO objML = new MeasurementLocationBO(this.ObjContext); if (!isNewML) { objML.ID = int.Parse(this.hdnSelectedMeasurementLocationListID.Value); objML.GetObject(); } objML.IsSend = (int.Parse(this.hdnIsSend.Value.ToString()) > 0) ? true : false; objML.Name = this.hdnName.Value.ToString(); objML.Key = this.hdnKey.Value.ToString(); if (isNewML) { int itemId = int.Parse(this.ddlItem.SelectedValue.ToString()); ItemBO objItem = new ItemBO(this.ObjContext); objItem.ID = itemId; objItem.GetObject(); objItem.MeasurementLocationsWhereThisIsItem.Add(objML); } this.ObjContext.SaveChanges(); ts.Complete(); } } catch (Exception ex) { IndicoLogging.log.Error("Error occured while processing Measurement Locations", ex); } }
protected void rptSpecML_ItemDataBound(object sender, RepeaterItemEventArgs e) { RepeaterItem item = e.Item; if (item.ItemIndex > -1 && item.DataItem is IGrouping <int, SizeChartBO> ) { List <SizeChartBO> lstSizeChart = ((IGrouping <int, SizeChartBO>)item.DataItem).ToList(); MeasurementLocationBO objML = new MeasurementLocationBO(); objML.ID = lstSizeChart[0].MeasurementLocation; objML.GetObject(); Literal litCellHeaderKey = (Literal)item.FindControl("litCellHeaderKey"); litCellHeaderKey.Text = objML.Key; Literal litCellHeaderML = (Literal)item.FindControl("litCellHeaderML"); litCellHeaderML.Text = objML.Name; Repeater rptSpecSizeQty = (Repeater)item.FindControl("rptSpecSizeQty"); rptSpecSizeQty.DataSource = lstSizeChart; rptSpecSizeQty.DataBind(); } }
private void GetDiffrenceGarmentSpec(int original, int compare) { PatternBO objOriPattern = new PatternBO(); objOriPattern.ID = original; objOriPattern.GetObject(); PatternBO objComPattern = new PatternBO(); objComPattern.ID = compare; objComPattern.GetObject(); List <SizeChartBO> lstDiffrence = new List <SizeChartBO>(); List <SizeChartBO> lstOriSizeCharts = objOriPattern.SizeChartsWhereThisIsPattern; List <SizeChartBO> lstCComSizeCharts = objComPattern.SizeChartsWhereThisIsPattern; foreach (SizeChartBO osc in lstOriSizeCharts) { foreach (SizeChartBO csc in lstCComSizeCharts) { if (osc.Size == csc.Size && osc.MeasurementLocation == csc.MeasurementLocation) { decimal difference = (osc.Val - csc.Val); MeasurementLocationBO objM = new MeasurementLocationBO(); objM.ID = csc.MeasurementLocation; objM.GetObject(); SizeBO objSize = new SizeBO(); objSize.ID = csc.Size; objSize.GetObject(); SizeChartBO objSizeChart = new SizeChartBO(); objSizeChart.ID = 0; objSizeChart.Pattern = csc.Pattern;// Not necessary objSizeChart.MeasurementLocation = osc.MeasurementLocation; objSizeChart.objPattern = objComPattern; objSizeChart.Size = csc.Size; objSizeChart.objSize = objSize; objSizeChart.MeasurementLocation = csc.MeasurementLocation; objSizeChart.objMeasurementLocation = objM; objSizeChart.Val = difference; lstDiffrence.Add(objSizeChart); } } } List <IGrouping <int, SizeChartBO> > lstSizeChartGroup = lstDiffrence.OrderBy(o => o.objMeasurementLocation.Key).GroupBy(o => o.MeasurementLocation).ToList(); if (lstSizeChartGroup.Count > 0) { this.rptDiffSpecSizeQtyHeader.DataSource = (List <SizeChartBO>)lstSizeChartGroup[0].ToList(); this.rptDiffSpecSizeQtyHeader.DataBind(); this.rptDiffSpecML.DataSource = lstSizeChartGroup; this.rptDiffSpecML.DataBind(); this.dvDiffrence.Visible = true; } }