public void LoadData(int Id) { DataTable dt = null; SmvBLL smv = new SmvBLL(); try { dt = smv.GetOptionInformationForUpdate(Id); if (dt.Rows.Count > 0) { buyerTextBox.Text = Convert.ToString(dt.Rows[0]["BuyerName"]); sampleStageTextBox.Text = Convert.ToString(dt.Rows[0]["SampleStageName"]); styleTextBox.Text = Convert.ToString(dt.Rows[0]["StyleNumber"]); designTextBox.Text = Convert.ToString(dt.Rows[0]["DesignNumber"]); optionNumberTextBox.Text = Convert.ToString(dt.Rows[0]["OptionNumber"]); reductionTextBox.Text = Convert.ToString(dt.Rows[0]["OptionReduction"]); additionTextBox.Text = Convert.ToString(dt.Rows[0]["OptionAddition"]); descriptionTextBox.Text = Convert.ToString(dt.Rows[0]["OptionDescription"]); remarksTextBox.Text = Convert.ToString(dt.Rows[0]["OptionRemarks"]); } } catch (Exception ex) { } }
public void loadFromCostingPanel(int smvId) { int buyerIdForLoad = 0; try { SmvBLL smvBll = new SmvBLL(); DataTable dt = smvBll.LoadCostingInfoInfoForUpdate(smvId); { buyerNameDropDownList.SelectedValue = Convert.ToString(dt.Rows[0]["BuyerId"]); buyerIdForLoad = Convert.ToInt32(dt.Rows[0]["BuyerId"]); string value = Convert.ToString(dt.Rows[0]["SampleStageId"]); sampleStageHiddenField.Value = value; loadSampleStageForUpdate(buyerIdForLoad); sampleStageDropDownList.SelectedValue = sampleStageHiddenField.Value; fabricDropDownList.SelectedValue = Convert.ToString(dt.Rows[0]["FabricId"]); //styleDropDownList.SelectedValue = Convert.ToString(dt.Rows[0]["StyleId"]); styleNumberTextBox.Text = Convert.ToString(dt.Rows[0]["StyleNumber"]); styleDescriptionTextBox.Text = Convert.ToString(dt.Rows[0]["StyleDescription"]); ProductDropDownList.SelectedValue = Convert.ToString(dt.Rows[0]["ProductCategoryId"]); valueAddedSmvHiddenField.Value = Convert.ToString(dt.Rows[0]["SmvId"]); //SeasonDropDownList.SelectedValue= Convert.ToString(dt.Rows[0]["SeasonId"]); seasonTextBox.Text = Convert.ToString(dt.Rows[0]["SeasonId"]); } } catch (Exception ex) { } }
protected string LoadCostingInfo(int SmvId) { string infoTable = null; try { SmvBLL smv = new SmvBLL(); infoTable = smv.LoadCostingOptionForUpdate(SmvId); } catch (Exception ex) { } return(infoTable); }
public string LoadCombineStyleReports(int BuyerId, string StyleNumber) { SmvBLL smvBll = new SmvBLL(); //buyerId = Convert.ToInt32(seatchDropDownList.SelectedValue); try { smvtable = smvBll.LoadCombineStyleReports(BuyerId, StyleNumber); } catch (Exception ex) { } return(smvtable); }
public string loadCostingSmvinformation(int buyerId, string StyleNumber) { SmvBLL smvBll = new SmvBLL(); //buyerId = Convert.ToInt32(seatchDropDownList.SelectedValue); try { smvtable = smvBll.LoadCostingSmvInfoRevised(buyerId, StyleNumber); } catch (Exception ex) { } return(smvtable); }
public string loadCostingSmvinformation(int BuyerId, string StyleNumber) { SmvBLL smvBll = new SmvBLL(); //buyerId = Convert.ToInt32(seatchDropDownList.SelectedValue); try { smvtable = smvBll.DetailsCostingSmvInfo(BuyerId, StyleNumber); return(smvtable); } catch (Exception ex) { throw ex; } }
protected void updateButton_Click(object sender, EventArgs e) { UpdateOptionModel costingOption = new UpdateOptionModel(); SmvBLL smv = new SmvBLL(); int action = 0; try { if (optionId > 0) { costingOption.OptionId = optionId; costingOption.OptionNumber = optionNumberTextBox.Text; costingOption.OptionReduction = reductionTextBox.Text; costingOption.OptionAddition = additionTextBox.Text; costingOption.OptionDescription = descriptionTextBox.Text; costingOption.OptionRemarks = remarksTextBox.Text; action = smv.UpdateCostingOption(costingOption); if (action > 0) { massageSpan.InnerText = "Costing Option has Been Updated"; table = LoadCostingInfo(smvId); Clear(); //Response.Redirect("CostingOption.aspx"); } else { massageSpan.InnerText = "Faield"; } } else { massageSpan.InnerText = "This Data Not Found In Our Store"; } } catch (Exception ex) { throw ex; } }
public DataTable LoadProductCategory() { DataTable dt = null; try { SmvBLL smvBLL = new SmvBLL(); dt = smvBLL.LoadProductCategory(); if (dt.Rows.Count > 0) { productDropDownList.DataSource = dt; productDropDownList.DataValueField = "ProductId"; productDropDownList.DataTextField = "ProductName"; productDropDownList.DataBind(); productDropDownList.Items.Insert(0, new ListItem("Please Select Product Category", "0")); } } catch (Exception ex) { } return(dt); }
public DataTable LoadFabricType() { DataTable dt = null; try { SmvBLL smvBLL = new SmvBLL(); dt = smvBLL.LoadFabricType(); if (dt.Rows.Count > 0) { fabricDropDownList.DataSource = dt; fabricDropDownList.DataValueField = "FabricId"; fabricDropDownList.DataTextField = "FabricType"; fabricDropDownList.DataBind(); fabricDropDownList.Items.Insert(0, new ListItem("Please Select Fabric Type", "0")); } } catch (Exception ex) { } return(dt); }
protected void updateButton_Click(object sender, EventArgs e) { string listOfOption = string.Empty; //if (Session["ListOfOption"].ToString() != "[]" || Session["ListOfOption"] != null) //{ // listOfOption = Session["ListOfOption"].ToString(); //} try { if (Session["ListOfOption"].ToString() != "[]" || Session["ListOfOption"] != null) { listOfOption = Session["ListOfOption"].ToString(); } } catch { listOfOption = "[]"; } List <CostingOptionModel> dataList = new List <CostingOptionModel>(); List <CostingOptionModel> listOfCostingOption = JsonConvert.DeserializeObject <List <CostingOptionModel> >(listOfOption); foreach (var optionModel in listOfCostingOption) { CostingOptionModel costingOption = new CostingOptionModel(); costingOption.OptionNumber = optionModel.OptionNumber; if (optionModel.OptionReduction == null || optionModel.OptionReduction == "") { costingOption.OptionReduction = "0.00"; } else { costingOption.OptionReduction = optionModel.OptionReduction; } if (optionModel.OptionAddition == null || optionModel.OptionAddition == "") { costingOption.OptionAddition = "0.00"; } else { costingOption.OptionAddition = optionModel.OptionAddition; } costingOption.OptionDescription = optionModel.OptionDescription; costingOption.OptionRemarks = optionModel.OptionRemarks; dataList.Add(costingOption); } DataTable data = ToDataTable(dataList); DataTable dt = new DataTable(); try { if (UpId != 0) { int value = 0; CostingSmv smv = new CostingSmv(); SmvBLL smvBLL = new SmvBLL(); MailClass mailClass = new MailClass(); smv.BuyerId = Convert.ToInt32(buyerNameDropDownList.SelectedValue); value = Convert.ToInt32(sampleStageHiddenField.Value); smv.SampleStageId = value; smv.StyleNumber = styleNumberTextBox.Text.Trim(); smv.DesignNumber = designTextBox.Text.Trim(); smv.StyleDescription = styleDescriptionTextBox.Text; smv.FabricId = Convert.ToInt32(fabricDropDownList.SelectedValue); smv.ProductCategory = Convert.ToInt32(ProductDropDownList.SelectedValue); //smv.SeasonId = Convert.ToInt32(SeasonDropDownList.SelectedValue); smv.Season = seasonTextBox.Text.Trim(); smv.Department = ""; //smv.SampleDate = sampleDateTextBox.Text; if (sampleDateTextBox.Text == "1900-01-01") { smv.SampleDate = Convert.ToString(""); } else { smv.SampleDate = Convert.ToString(sampleDateTextBox.Text); } if (sewingTextBox.Text == "" || sewingTextBox.Text == null) { smv.SewingSmv = Convert.ToDecimal("0.00"); } else { smv.SewingSmv = Convert.ToDecimal(sewingTextBox.Text); } if (pleatingTextBox.Text == "" || pleatingTextBox.Text == null) { smv.PleatingSmv = Convert.ToDecimal("0.00"); } else { smv.PleatingSmv = Convert.ToDecimal(pleatingTextBox.Text); } if (permanentCreaseTextBox.Text == "" || permanentCreaseTextBox.Text == null) { smv.PermanentCrease = Convert.ToDecimal("0.00"); } else { smv.PermanentCrease = Convert.ToDecimal(permanentCreaseTextBox.Text); } if (supperCreaseTextBox.Text == "" || supperCreaseTextBox.Text == null) { smv.SupperCrease = Convert.ToDecimal("0.00"); } else { smv.SupperCrease = Convert.ToDecimal(supperCreaseTextBox.Text); } if (heatSealTextBox.Text == "" || heatSealTextBox.Text == null) { smv.HeatSeal = Convert.ToDecimal("0.00"); } else { smv.HeatSeal = Convert.ToDecimal(heatSealTextBox.Text); } if (overlayTextBox.Text == "" || overlayTextBox.Text == null) { smv.OverlayFilm = Convert.ToDecimal("0.00"); } else { smv.OverlayFilm = Convert.ToDecimal(overlayTextBox.Text); } if (plkTextBox.Text == "" || plkTextBox.Text == null) { smv.PLKQuilting = Convert.ToDecimal("0.00"); } else { smv.PLKQuilting = Convert.ToDecimal(plkTextBox.Text); } if (autoTextBox.Text == "" || autoTextBox.Text == null) { smv.AutoQuilting = Convert.ToDecimal("0.00"); } else { smv.AutoQuilting = Convert.ToDecimal(autoTextBox.Text); } if (quiltingManualTextBox.Text == "" || quiltingManualTextBox.Text == null) { smv.ManualQuilting = Convert.ToDecimal("0.00"); } else { smv.ManualQuilting = Convert.ToDecimal(quiltingManualTextBox.Text); } if (downManualTextBox.Text == "" || downManualTextBox.Text == null) { smv.ManualDownFill = Convert.ToDecimal("0.00"); } else { smv.ManualDownFill = Convert.ToDecimal(downManualTextBox.Text); } if (downMachineTextBox.Text == "" || downMachineTextBox.Text == null) { smv.MachineDownFill = Convert.ToDecimal("0.00"); } else { smv.MachineDownFill = Convert.ToDecimal(downMachineTextBox.Text); } if (seamTextBox.Text == "" || seamTextBox.Text == null) { smv.SeamSeal = Convert.ToDecimal("0.00"); } else { smv.SeamSeal = Convert.ToDecimal(seamTextBox.Text); } if (bondingTextBox.Text == "" || bondingTextBox.Text == null) { smv.Bonding = Convert.ToDecimal("0.00"); } else { smv.Bonding = Convert.ToDecimal(bondingTextBox.Text); } if (cuttingTextBox.Text == "" || cuttingTextBox.Text == null) { smv.CuttingSMV = Convert.ToDecimal("0.00"); } else { smv.CuttingSMV = Convert.ToDecimal(cuttingTextBox.Text); } if (finisingTextBox.Text == "" || finisingTextBox.Text == null) { smv.FinishingSmv = Convert.ToDecimal("0.00"); } else { smv.FinishingSmv = Convert.ToDecimal(finisingTextBox.Text); } if (otherValueTextBox.Text == "" || otherValueTextBox.Text == null) { smv.OthersValue = Convert.ToDecimal("0.00"); } else { smv.OthersValue = Convert.ToDecimal(otherValueTextBox.Text); } smv.OthersDescription = otherDescriptionTextBox.Text; smv.OptionValue = Convert.ToDecimal("0.00"); smv.OptionAdditionalValue = Convert.ToDecimal("0.00"); smv.OptionNumber = ""; smv.OptionDescription = ""; smv.OptionRemarks = ""; smv.ReviewBy = Convert.ToInt32(reviewDropDownList.SelectedValue); smv.ApprovedBy = Convert.ToInt32(approvedDropDownList.SelectedValue); smv.Remarks = descriptionTextarea.InnerText; smv.MachineDescription = machineDetailsTextarea.InnerText; smv.SmvId = UpId; smv.UpdatedBy = Convert.ToInt32(userId); actionResult = smvBLL.UpdateCostingSmv(smv, data); if (actionResult >= 1) { messageLabel.Text = "<p Style ='font-size:20px;color:Green; margin-top:20px;'> Information Successfully Updated</p>"; if (smv.ApprovedBy == 0) { mailClass.SendMailForApprovedByNotSet(smv); } ClearAllData(); Page.Response.Redirect(url.ToString(), true); } else { messageLabel.Text = "<p Style ='font-size:20px;color:Red; margin-top:20px;'>Already Exists...</p>"; } } } catch (Exception ex) { } table = loadCostingSmvinformation(buyerId, styleNumber); mainBody.Visible = false; }
public void LoadSmvInfoForUpdate(int smvId) { int buyerIdForLoad = 0; try { SmvBLL smvBll = new SmvBLL(); DataTable dt = smvBll.LoadCostingInfoInfoForUpdate(smvId); if (dt.Rows.Count > 0) { buyerNameDropDownList.SelectedValue = Convert.ToString(dt.Rows[0]["BuyerId"]); buyerIdForLoad = Convert.ToInt32(dt.Rows[0]["BuyerId"]); string value = Convert.ToString(dt.Rows[0]["SampleStageId"]); sampleStageHiddenField.Value = value; loadSampleStageForUpdate(buyerIdForLoad); sampleStageDropDownList.SelectedValue = sampleStageHiddenField.Value; fabricDropDownList.SelectedValue = Convert.ToString(dt.Rows[0]["FabricId"]); styleDescriptionTextBox.Text = Convert.ToString(dt.Rows[0]["StyleDescription"]); styleNumberTextBox.Text = Convert.ToString(dt.Rows[0]["StyleNumber"]); designTextBox.Text = Convert.ToString(dt.Rows[0]["DesignNumber"]); ProductDropDownList.SelectedValue = Convert.ToString(dt.Rows[0]["ProductCategoryId"]); //SeasonDropDownList.SelectedValue= Convert.ToString(dt.Rows[0]["SeasonId"]); seasonTextBox.Text = Convert.ToString(dt.Rows[0]["SeasonId"]); DateTime date = Convert.ToDateTime(dt.Rows[0]["SampleDate"]); if (date.ToString("yyyy-MM-dd") == "1900-01-01") { sampleDateTextBox.Text = ""; } else { sampleDateTextBox.Text = date.ToString("yyyy-MM-dd"); } sewingTextBox.Text = Convert.ToString(dt.Rows[0]["SwingSmv"]); pleatingTextBox.Text = Convert.ToString(dt.Rows[0]["PleatingSmv"]); permanentCreaseTextBox.Text = Convert.ToString(dt.Rows[0]["PermanentCrease"]); supperCreaseTextBox.Text = Convert.ToString(dt.Rows[0]["SupperCrease"]); heatSealTextBox.Text = Convert.ToString(dt.Rows[0]["HeatSealHeatSmv"]); overlayTextBox.Text = Convert.ToString(dt.Rows[0]["OverlayFilmHeatSmv"]); plkTextBox.Text = Convert.ToString(dt.Rows[0]["PLKQuiltingSmv"]); autoTextBox.Text = Convert.ToString(dt.Rows[0]["AutoQuiltingSmv"]); quiltingManualTextBox.Text = Convert.ToString(dt.Rows[0]["ManualQuiltingSmv"]); downManualTextBox.Text = Convert.ToString(dt.Rows[0]["ManualDownFill"]); downMachineTextBox.Text = Convert.ToString(dt.Rows[0]["MachineDownFill"]); seamTextBox.Text = Convert.ToString(dt.Rows[0]["SeamSeal"]); bondingTextBox.Text = Convert.ToString(dt.Rows[0]["Bonding"]); cuttingTextBox.Text = Convert.ToString(dt.Rows[0]["CuttingSMV"]); finisingTextBox.Text = Convert.ToString(dt.Rows[0]["FinisingSmv"]); otherDescriptionTextBox.Text = Convert.ToString(dt.Rows[0]["OthersDescription"]); otherValueTextBox.Text = Convert.ToString(dt.Rows[0]["OthersValue"]); //optionDescriptionTextBox.Text = Convert.ToString(dt.Rows[0]["OptionDescription"]); //optionValueTextBox.Text = Convert.ToString(dt.Rows[0]["OptionValue"]); //optionNumberTextBox.Text = Convert.ToString(dt.Rows[0]["OptionNumber"]); //optionRemarksTextBox.Text = Convert.ToString(dt.Rows[0]["OptionRemarks"]); //optionAdditionalTextBox.Text = Convert.ToString(dt.Rows[0]["OptionAdditionalValuee"]); machineDetailsTextarea.InnerText = Convert.ToString(dt.Rows[0]["MachineWork"]); descriptionTextarea.InnerText = Convert.ToString(dt.Rows[0]["Remarks"]); approvedDropDownList.SelectedValue = Convert.ToString(dt.Rows[0]["ApprovedBy"]); reviewDropDownList.SelectedValue = Convert.ToString(dt.Rows[0]["ReviewBy"]); } } catch (Exception ex) { } }