protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
if (ddlProductionItemType.SelectedValue == "0" || ddlProductProductionLine.SelectedValue == "0" ||
ddlProductionItem.SelectedValue == "0" || ddlProductionItemcolor.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك تأكد من أدخال بيانات المستحضر بالكامل')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.ItemContentHeaders
where a.ItemType == long.Parse(ddlProductionItemType.SelectedValue) ||
a.ProductionLineId == long.Parse(ddlProductProductionLine.SelectedValue) ||
a.ProductItemColor == long.Parse(ddlProductionItemcolor.SelectedValue) || a.ProductItemId == long.Parse(ddlProductionItem.SelectedValue)
select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.ItemContentHeader header = Rows.Single(a => a.ProductItemId == long.Parse(ddlProductionItem.SelectedValue));
hfItemContentHeaderId.Value = header.Id.ToString();
}
else
{
Response.Write("<script>alert('لا يوجد اي تركيبات لهذا المستحضر')</script>");
return;
}
}
protected void btnShowReport_Click(object sender, ImageClickEventArgs e)
{
try
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.ItemContentHeaders
where a.ItemType == long.Parse(ddlProductionItemType.SelectedValue) ||
a.ProductionLineId == long.Parse(ddlProductProductionLine.SelectedValue) ||
a.ProductItemColor == long.Parse(ddlProductionItemcolor.SelectedValue) || a.ProductItemId == long.Parse(ddlProductionItem.SelectedValue)
select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.ItemContentHeader header = Rows.Single(a => a.ProductItemId == long.Parse(ddlProductionItem.SelectedValue));
ReportDocument myReportDocument = new ReportDocument();
myReportDocument.Load(Server.MapPath("~/ProductionReport/Report/rptContentItem.rpt"));
myReportDocument.Refresh();
CrystalReportViewer1.ReportSource = myReportDocument;
myReportDocument.DataSourceConnections[0].SetConnection(csGetPermission.DBServerName, csGetPermission.DBName, csGetPermission.DBUser, csGetPermission.DBPassword);
myReportDocument.SetParameterValue("@ItemContentHeaderId", header.Id);
myReportDocument.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, false, "");
}
}
catch { }
}
protected void btnDelete_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 6;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
try
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ItemContentDetail details = mdb.ItemContentDetails.Single(a => a.Id == long.Parse(hfItemContentDetailsId.Value));
mdb.ItemContentDetails.Remove(details);
mdb.SaveChanges();
var Rows = from a in mdb.ItemContentDetails where a.ItemContentHeaderId == long.Parse(hfItemContentHeaderId.Value) select a;
if (Rows.Count() <= 0)
{
ADAM.DataBase.ItemContentHeader header = mdb.ItemContentHeaders.Single(a => a.Id == long.Parse(hfItemContentHeaderId.Value));
mdb.ItemContentHeaders.Remove(header);
mdb.SaveChanges();
btnNew_Click(sender, e);
}
gvItemContentData.DataBind();
}
catch
{
Response.Write("<script>alert('لا يمكن الحذف لأرتباطها بطلبات صرف')</script>");
return;
}
}
