private void DeleteData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ItemColorSelected dr = Mdb.ItemColorSelecteds.Single(a => a.Id == long.Parse(hfItemColorSelectedId.Value));
Mdb.ItemColorSelecteds.Remove(dr);
Mdb.SaveChanges();
EmptyData();
Response.Write("<script>alert('تمت عملية الحذف نجاح')</script>");
gvItemColorSelected.DataBind();
}
catch { Response.Write("<script>alert('خطأ أثناء الحذف من فضلك تأكد من ادخال البيانات بشكل صحيح او من الاتصال بقاعدة البيانات')</script>"); }
}
protected void gvItemColorSelected_SelectedIndexChanged(object sender, EventArgs e)
{
hfItemColorSelectedId.Value = gvItemColorSelected.SelectedDataKey.Value.ToString();
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ItemColorSelected dr = Mdb.ItemColorSelecteds.Single(a => a.Id == long.Parse(hfItemColorSelectedId.Value));
ADAM.DataBase.Item itmdr = Mdb.Items.Single(a => a.Id == dr.ItemId);
ADAM.DataBase.ProductionLine prdr = Mdb.ProductionLines.Single(a => a.Id == itmdr.ProductionLineId);
ADAM.DataBase.ItemType itmtyprdr = Mdb.ItemTypes.Single(a => a.Id == itmdr.ItemTypeId);
ddlItemType.SelectedValue = itmtyprdr.Id.ToString();
ddlProdctionLine.SelectedValue = prdr.Id.ToString();
ddlItemGroup.SelectedValue = dr.ItemsGroupId.ToString();
ddlItems.DataBind();
ddlItems.SelectedValue = itmdr.Id.ToString();
ddlItemColor.SelectedValue = dr.ItemColorId.ToString();
txtPoint.Text = dr.Point.ToString();
}
private void EditData()
{
try
{
if (ddlItemType.SelectedValue == "0" || ddlProdctionLine.SelectedValue == "0" || ddlItems.SelectedValue == "0" || ddlItemColor.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك تأكد من ادخال كل البيانات بشكل صحيح')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ItemColorSelected dr = Mdb.ItemColorSelecteds.Single(a => a.Id == long.Parse(hfItemColorSelectedId.Value));
dr.ItemId = long.Parse(ddlItems.SelectedValue);
dr.ItemColorId = int.Parse(ddlItemColor.SelectedValue);
dr.Point = decimal.Parse(txtPoint.Text);
dr.ItemsGroupId = long.Parse(ddlItemGroup.SelectedValue);
Mdb.SaveChanges();
Response.Write("<script>alert('تمت عملية التعديل بنجاح')</script>");
gvItemColorSelected.DataBind();
}
catch { Response.Write("<script>alert('خطأ أثناء التعديل من فضلك تأكد من ادخال البيانات بشكل صحيح او الاتصال بقاعدة البيانات ')</script>"); }
}
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 gvItemPrice_SelectedIndexChanged(object sender, EventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 1;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
long ItemColorSelectedId = long.Parse(gvItemPrice.SelectedDataKey.Value.ToString());
try
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
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;
ADAM.DataBase.ItemPrice itmpricedr = new DataBase.ItemPrice();
if (Rows.Count() > 0)
{
itmpricedr = mdb.ItemPrices.Single(a => a.ItemId == itmcolordr.ItemId && a.ItemColorId == itmcolordr.ItemColorId);
}
TextBox txtMainClausePrice = gvItemPrice.SelectedRow.FindControl("txtMainClausePrice") as TextBox;
TextBox txtMainSalesPrice = gvItemPrice.SelectedRow.FindControl("txtMainSalesPrice") as TextBox;
TextBox txtMainShowsPrice = gvItemPrice.SelectedRow.FindControl("txtMainShowsPrice") as TextBox;
TextBox txtTesterClausePrice = gvItemPrice.SelectedRow.FindControl("txtTesterClausePrice") as TextBox;
TextBox txtTesterSalesPrice = gvItemPrice.SelectedRow.FindControl("txtTesterSalesPrice") as TextBox;
TextBox txtTesterShowsPrice = gvItemPrice.SelectedRow.FindControl("txtTesterShowsPrice") as TextBox;
if (string.IsNullOrEmpty(txtMainClausePrice.Text))
{
txtMainClausePrice.Text = "0";
}
if (string.IsNullOrEmpty(txtMainSalesPrice.Text))
{
txtMainSalesPrice.Text = "0";
}
if (string.IsNullOrEmpty(txtMainShowsPrice.Text))
{
txtMainShowsPrice.Text = "0";
}
if (string.IsNullOrEmpty(txtTesterClausePrice.Text))
{
txtTesterClausePrice.Text = "0";
}
if (string.IsNullOrEmpty(txtTesterSalesPrice.Text))
{
txtTesterSalesPrice.Text = "0";
}
if (string.IsNullOrEmpty(txtTesterShowsPrice.Text))
{
txtTesterShowsPrice.Text = "0";
}
itmpricedr.ItemColorId = itmcolordr.ItemColorId;
itmpricedr.ItemId = itmcolordr.ItemId;
itmpricedr.MainClausePrice = decimal.Parse(txtMainClausePrice.Text);
itmpricedr.MainSalesPrice = decimal.Parse(txtMainSalesPrice.Text);
itmpricedr.MainShowsPrice = decimal.Parse(txtMainShowsPrice.Text);
itmpricedr.TesterClausePrice = decimal.Parse(txtTesterClausePrice.Text);
itmpricedr.TesterSalesPrice = decimal.Parse(txtTesterSalesPrice.Text);
itmpricedr.TesterShowsPrice = decimal.Parse(txtTesterShowsPrice.Text);
if (Rows.Count() <= 0)
{
mdb.ItemPrices.Add(itmpricedr);
}
mdb.SaveChanges();
}
catch { }
}
