internal int UpdateData(LC_YarnDetermination aLC_YarnDetermination, int yarnDeterminationId) { try { LC_YarnDetermination LC_YarnDetermination = _Context.LC_YarnDetermination.First(x => x.Id == yarnDeterminationId); LC_YarnDetermination.FebricNatureId = aLC_YarnDetermination.FebricNatureId; LC_YarnDetermination.ColorRangeId = aLC_YarnDetermination.ColorRangeId; LC_YarnDetermination.ConstructionId = aLC_YarnDetermination.ConstructionId; LC_YarnDetermination.GSM = aLC_YarnDetermination.GSM; LC_YarnDetermination.CompositionId = aLC_YarnDetermination.CompositionId; LC_YarnDetermination.Percentage = aLC_YarnDetermination.Percentage; LC_YarnDetermination.YarnCountId = aLC_YarnDetermination.YarnCountId; LC_YarnDetermination.YarnCountTypeId = aLC_YarnDetermination.YarnCountTypeId; LC_YarnDetermination.StichLength = aLC_YarnDetermination.StichLength; LC_YarnDetermination.ProcessLoss = aLC_YarnDetermination.ProcessLoss; LC_YarnDetermination.EditUser = aLC_YarnDetermination.EditUser; LC_YarnDetermination.EditDate = aLC_YarnDetermination.EditDate; LC_YarnDetermination.OCode = aLC_YarnDetermination.OCode; _Context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal int SaveDataOriginal(LC_YarnDetermination aLC_YarnDetermination) { try { _Context.LC_YarnDetermination.AddObject(aLC_YarnDetermination); _Context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
internal int SaveDataOriginal(LC_YarnDetermination aLC_YarnDetermination) { return(aYarnCountDeterminationDAL.SaveDataOriginal(aLC_YarnDetermination)); }
internal int UpdateData(LC_YarnDetermination aLC_YarnDetermination, int yarnDeterminationId) { return(aYarnCountDeterminationDAL.UpdateData(aLC_YarnDetermination, yarnDeterminationId)); }
protected void confirmButton_Click(object sender, EventArgs e) { int uniqueId = GenerateUniqueId(); string ocode = ((SessionUser)Session["SessionUser"]).OCode; Guid userIdEccess = ((SessionUser)Session["SessionUser"]).UserId; List <YarnDeterminationRepo> dataList = aYarnCountDeterminationBLL.LoadDataForGrid(ocode, userIdEccess); try { foreach (YarnDeterminationRepo aYarnDeterminationRepo in dataList) { LC_YarnDetermination aLC_YarnDetermination = new LC_YarnDetermination(); aLC_YarnDetermination.FebricNatureId = aYarnDeterminationRepo.FebricNatureId; aLC_YarnDetermination.ColorRangeId = aYarnDeterminationRepo.ColorRangeId; aLC_YarnDetermination.ConstructionId = aYarnDeterminationRepo.ConstructionId; aLC_YarnDetermination.ProductId = aYarnDeterminationRepo.ProductId; aLC_YarnDetermination.GSM = aYarnDeterminationRepo.GSM; aLC_YarnDetermination.CompositionId = aYarnDeterminationRepo.CompositionId; aLC_YarnDetermination.Percentage = aYarnDeterminationRepo.Percentage; aLC_YarnDetermination.Price = aYarnDeterminationRepo.Price; aLC_YarnDetermination.StichLength = aYarnDeterminationRepo.StichLength; aLC_YarnDetermination.ProcessLoss = aYarnDeterminationRepo.ProcessLoss; aLC_YarnDetermination.UniqueId = uniqueId; aLC_YarnDetermination.CreateUser = ((SessionUser)Session["SessionUser"]).UserId; aLC_YarnDetermination.CreateDate = DateTime.Now; aLC_YarnDetermination.OCode = ((SessionUser)Session["SessionUser"]).OCode; aYarnCountDeterminationBLL.SaveDataOriginal(aLC_YarnDetermination); } foreach (YarnDeterminationRepo aYarnDeterminationRepo in dataList) { int tempEntryId = aYarnDeterminationRepo.YarnDeterminationId; aYarnCountDeterminationBLL.DeleteDataFromTemp(tempEntryId); } LC_DeterminationCost aLC_DeterminationCost = new LC_DeterminationCost(); aLC_DeterminationCost.ConstructionFinishFebric = Convert.ToDecimal(constructionFinishFebricTextBox.Text); aLC_DeterminationCost.KnitingCost = Convert.ToInt32(kinitingCostTextBox.Text); aLC_DeterminationCost.DryingCostOption = dryingCostDropDownList.Text; aLC_DeterminationCost.DryingCost = Convert.ToInt32(dryingCostTextBox.Text); aLC_DeterminationCost.TotalCost = Convert.ToDecimal(totalTextBox.Text); aLC_DeterminationCost.UniqueId = uniqueId; aLC_DeterminationCost.CreateUser = ((SessionUser)Session["SessionUser"]).UserId; aLC_DeterminationCost.CreateDate = DateTime.Now; aLC_DeterminationCost.OCode = ((SessionUser)Session["SessionUser"]).OCode; int result = aYarnCountDeterminationBLL.SaveToDeterminationCost(aLC_DeterminationCost); if (result == 1) { ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "SuccessAlert('Save Successfully!!')", true); } else { ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "notsuccessalert('Not Save!!')", true); return; } } catch (Exception ex) { throw ex; } fabNatureDropDownList.Enabled = true; constructionDropDownList.Enabled = true; colorRangeDropDownList.Enabled = true; gSMTextBox.Enabled = true; //countDropDownList.Text = ""; //typeDropDownList.Text = ""; //UMDropDownList.Text = ""; FillFabricNature(); FillConstruction(); FillComposition(); //FillYarnCount(); //FillYarnCountType(); FillColor(); gSMTextBox.Text = ""; percentageTextBox.Text = ""; priceTextBox.Text = ""; txtStichLength.Text = ""; txtProcessLoss.Text = ""; kinitingCostTextBox.Text = ""; dryingCostDropDownList.Text = ""; dryingCostTextBox.Text = ""; totalTextBox.Text = ""; LoadDataInGrid(); LoadDeterminationDataForLastGrid(); }
//--------------------------------------Add Functions Work Here---------------------------------------------------- protected void addButton_Click(object sender, EventArgs e) { try { //Find The Product Id From Inv_Product Table int groupId = Convert.ToInt32(constructionDropDownList.SelectedValue.ToString()); string productName = "Yarn"; string brandName = countDropDownList.Text; string type = typeDropDownList.Text; int unitId = Convert.ToInt32(UMDropDownList.SelectedValue.ToString()); int productId = aYarnCountDeterminationBLL.GetProductId(groupId, productName, brandName, type, unitId); if (productId != 0) { if (addButton.Text == "Add") { LC_YarnDeterminationTemp aLC_YarnDeterminationTemp = new LC_YarnDeterminationTemp(); aLC_YarnDeterminationTemp.FebricNatureId = Convert.ToInt32(fabNatureDropDownList.SelectedValue.ToString()); aLC_YarnDeterminationTemp.ColorRangeId = Convert.ToInt32(colorRangeDropDownList.SelectedValue.ToString()); aLC_YarnDeterminationTemp.ConstructionId = Convert.ToInt32(constructionDropDownList.SelectedValue.ToString()); aLC_YarnDeterminationTemp.ProductId = productId; aLC_YarnDeterminationTemp.GSM = gSMTextBox.Text; aLC_YarnDeterminationTemp.CompositionId = Convert.ToInt32(compositionDropDownList.SelectedValue.ToString()); aLC_YarnDeterminationTemp.Percentage = percentageTextBox.Text; aLC_YarnDeterminationTemp.Price = Convert.ToDecimal(priceTextBox.Text); aLC_YarnDeterminationTemp.StichLength = txtStichLength.Text; aLC_YarnDeterminationTemp.ProcessLoss = txtProcessLoss.Text; aLC_YarnDeterminationTemp.CreateUser = ((SessionUser)Session["SessionUser"]).UserId; aLC_YarnDeterminationTemp.CreateDate = DateTime.Now; aLC_YarnDeterminationTemp.OCode = ((SessionUser)Session["SessionUser"]).OCode; int result = aYarnCountDeterminationBLL.SaveData(aLC_YarnDeterminationTemp); if (result == 1) { ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "SuccessAlert('Save Successfully!!')", true); } else { ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "notsuccessalert('Not Save!!')", true); } fabNatureDropDownList.Enabled = false; constructionDropDownList.Enabled = false; colorRangeDropDownList.Enabled = false; gSMTextBox.Enabled = false; } else if (addButton.Text == "Update") { LC_YarnDetermination aLC_YarnDetermination = new LC_YarnDetermination(); aLC_YarnDetermination.FebricNatureId = Convert.ToInt32(fabNatureDropDownList.SelectedValue.ToString()); aLC_YarnDetermination.ColorRangeId = Convert.ToInt32(colorRangeDropDownList.SelectedValue.ToString()); aLC_YarnDetermination.ConstructionId = Convert.ToInt32(constructionDropDownList.SelectedValue.ToString()); aLC_YarnDetermination.ProductId = productId; aLC_YarnDetermination.GSM = gSMTextBox.Text; aLC_YarnDetermination.CompositionId = Convert.ToInt32(compositionDropDownList.SelectedValue.ToString()); aLC_YarnDetermination.Percentage = percentageTextBox.Text; aLC_YarnDetermination.Price = Convert.ToDecimal(priceTextBox.Text); aLC_YarnDetermination.StichLength = txtStichLength.Text; aLC_YarnDetermination.ProcessLoss = txtProcessLoss.Text; aLC_YarnDetermination.EditUser = ((SessionUser)Session["SessionUser"]).UserId; aLC_YarnDetermination.EditDate = DateTime.Now; aLC_YarnDetermination.OCode = ((SessionUser)Session["SessionUser"]).OCode; int yarnDeterminationId = Convert.ToInt32(yarnCountTypeIdHiddenField.Value); int result = aYarnCountDeterminationBLL.UpdateData(aLC_YarnDetermination, yarnDeterminationId); if (result == 1) { ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "SuccessAlert('Update Successfully!!')", true); return; } else { ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "notsuccessalert('Not Update!!')", true); return; } } } else { ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "notsuccessalert('Product Id Not Found!!')", true); } } catch (Exception ex) { throw ex; } FillComposition(); LoadDataInGrid(); countDropDownList.DataSource = null; typeDropDownList.DataSource = null; UMDropDownList.DataSource = null; percentageTextBox.Text = ""; priceTextBox.Text = ""; txtStichLength.Text = ""; txtProcessLoss.Text = ""; }