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; }
}
