protected void gvExchangeRequestData_SelectedIndexChanged(object sender, EventArgs e) { try { DropDownList ddlSalsType = gvExchangeRequestData.SelectedRow.FindControl("ddlSalsType") as DropDownList; if (ddlSalsType.SelectedValue == "0") { Response.Write("<script>alert('من فضلك أدخل نوع السعر')</script>"); return; } ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.ExchangeRequestDetailsData ddr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(gvExchangeRequestData.SelectedDataKey.Value.ToString())); var Rows = from a in mdb.ExchangeRequestPricings where a.ExchangeRequestDetailsId == ddr.Id select a; if (Rows.Count() > 0) { Response.Write("<script>alert('لقد تم التسعير من قبل')</script>"); return; } ADAM.DataBase.ExchangeRequestPricing dr = new DataBase.ExchangeRequestPricing(); dr.DiscPresent = 0; dr.DiscQty = 0; dr.ExchangeRequestDetailsId = ddr.Id; dr.Note = ""; long ItemPriceId = long.Parse(gvExchangeRequestData.SelectedDataKey[1].ToString()); ADAM.DataBase.ItemPrice itmpricdr = mdb.ItemPrices.Single(a => a.Id == ItemPriceId); dr.MainClausePrice = itmpricdr.MainClausePrice; dr.MainSalesPrice = itmpricdr.MainSalesPrice; dr.MainShowsPrice = itmpricdr.MainShowsPrice; dr.TesterClausePrice = itmpricdr.TesterClausePrice; dr.TesterSalesPrice = itmpricdr.TesterSalesPrice; dr.TesterShowsPrice = itmpricdr.TesterShowsPrice; if (ddlSalsType.SelectedValue == "1") { dr.TInvoicePrice = itmpricdr.TesterSalesPrice; dr.InvoicePrice = itmpricdr.MainSalesPrice; } if (ddlSalsType.SelectedValue == "2") { dr.InvoicePrice = itmpricdr.MainClausePrice; dr.TInvoicePrice = itmpricdr.TesterClausePrice; } mdb.ExchangeRequestPricings.Add(dr); mdb.SaveChanges(); Response.Write("<script>alert('تم التسعير بنجاح')</script>"); } catch { return; } }
protected void gvItemPrice_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowIndex != -1) { TextBox txtMainClausePrice = e.Row.FindControl("txtMainClausePrice") as TextBox; TextBox txtMainSalesPrice = e.Row.FindControl("txtMainSalesPrice") as TextBox; TextBox txtMainShowsPrice = e.Row.FindControl("txtMainShowsPrice") as TextBox; TextBox txtTesterClausePrice = e.Row.FindControl("txtTesterClausePrice") as TextBox; TextBox txtTesterSalesPrice = e.Row.FindControl("txtTesterSalesPrice") as TextBox; TextBox txtTesterShowsPrice = e.Row.FindControl("txtTesterShowsPrice") as TextBox; ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString(); long ItemColorSelectedId = long.Parse(gvItemPrice.DataKeys[e.Row.RowIndex].Value.ToString()); ADAM.DataBase.ItemColorSelected itmcolordr = mdb.ItemColorSelecteds.Single(a => a.Id == ItemColorSelectedId); var Rows = from a in mdb.ItemPrices where a.ItemColorId == itmcolordr.ItemColorId && a.ItemId == itmcolordr.ItemId select a; if (Rows.Count() > 0) { ADAM.DataBase.ItemPrice itmpricedr = mdb.ItemPrices.Single(a => a.ItemId == itmcolordr.ItemId && a.ItemColorId == itmcolordr.ItemColorId); txtMainClausePrice.Text = itmpricedr.MainClausePrice.ToString(); txtMainSalesPrice.Text = itmpricedr.MainSalesPrice.ToString(); txtMainShowsPrice.Text = itmpricedr.MainShowsPrice.ToString(); txtTesterClausePrice.Text = itmpricedr.TesterClausePrice.ToString(); txtTesterSalesPrice.Text = itmpricedr.TesterSalesPrice.ToString(); txtTesterShowsPrice.Text = itmpricedr.TesterShowsPrice.ToString(); } else { txtMainClausePrice.Text = txtMainSalesPrice.Text = txtMainShowsPrice.Text = "0"; txtTesterClausePrice.Text = txtTesterSalesPrice.Text = txtTesterShowsPrice.Text = "0"; } } } catch { } }
protected void gvExchangeRequestData_SelectedIndexChanged(object sender, EventArgs e) { try { TextBox txtQtyPrice = gvExchangeRequestData.SelectedRow.FindControl("txtQtyPrice") as TextBox; TextBox txtTesterPrice = gvExchangeRequestData.SelectedRow.FindControl("txtTesterPrice") as TextBox; DropDownList ddlSalsType = gvExchangeRequestData.SelectedRow.FindControl("ddlSalsType") as DropDownList; if (ddlSalsType.SelectedValue == "0") { Response.Write("<script>alert('من فضلك أدخل نوع السعر')</script>"); return; } if (string.IsNullOrEmpty(txtQtyPrice.Text) || decimal.Parse(txtQtyPrice.Text) < 1) { Response.Write("<script>alert('من فضلك أدخل السعر بشكل صحيح بحيث يكون اكبر من الصفر')</script>"); return; } if ((string.IsNullOrEmpty(txtTesterPrice.Text) || decimal.Parse(txtTesterPrice.Text) < 1) && decimal.Parse(gvExchangeRequestData.SelectedRow.Cells[7].Text) > 0) { Response.Write("<script>alert('من فضلك أدخل سعر الـ Tester بشكل صحيح بحيث يكون اكبر من الصفر')</script>"); return; } if (decimal.Parse(gvExchangeRequestData.SelectedRow.Cells[7].Text) <= 0 && decimal.Parse(txtTesterPrice.Text) > 1) { Response.Write("<script>alert('لا يمكن تسعير ال Tester لان قيمة 0')</script>"); return; } ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.ExchangeRequestDetailsData ddr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(gvExchangeRequestData.SelectedDataKey.Value.ToString())); var Rows = from a in mdb.ExchangeRequestPricings where a.ExchangeRequestDetailsId == ddr.Id select a; if (Rows.Count() > 0) { Response.Write("<script>alert('لقد تم التسعير من قبل')</script>"); return; } ADAM.DataBase.ExchangeRequestPricing dr = new DataBase.ExchangeRequestPricing(); dr.DiscPresent = 0; dr.DiscQty = 0; dr.ExchangeRequestDetailsId = ddr.Id; dr.Note = ""; long ItemPriceId = long.Parse(gvExchangeRequestData.SelectedDataKey[1].ToString()); ADAM.DataBase.ItemPrice itmpricdr = mdb.ItemPrices.Single(a => a.Id == ItemPriceId); dr.MainClausePrice = itmpricdr.MainClausePrice; dr.MainSalesPrice = itmpricdr.MainSalesPrice; dr.MainShowsPrice = itmpricdr.MainShowsPrice; dr.TesterClausePrice = itmpricdr.TesterClausePrice; dr.TesterSalesPrice = itmpricdr.TesterSalesPrice; dr.TesterShowsPrice = itmpricdr.TesterShowsPrice; if (ddlSalsType.SelectedValue == "1") { dr.TInvoicePrice = itmpricdr.TesterSalesPrice; dr.InvoicePrice = itmpricdr.MainSalesPrice; } if (ddlSalsType.SelectedValue == "2") { dr.InvoicePrice = itmpricdr.MainClausePrice; dr.TInvoicePrice = itmpricdr.TesterClausePrice; } mdb.ExchangeRequestPricings.Add(dr); mdb.SaveChanges(); } catch { return; } }