private void ShowData()
{
try
{
if (ddlRefluxType.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك اختر نوع طلب الارتجاع')</script>");
return;
}
if (string.IsNullOrEmpty(txtRefluxNo.Text))
{
Response.Write("<script>alert('من فضلك ادخل رقم الطلب')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.RefluxHeaderDatas
where a.RefluxNo == long.Parse(txtRefluxNo.Text) && a.OrderType == int.Parse(ddlRefluxType.SelectedValue)
select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.RefluxHeaderData headerdr = mdb.RefluxHeaderDatas.Single(a => a.RefluxNo == long.Parse(txtRefluxNo.Text) && a.OrderType == int.Parse(ddlRefluxType.SelectedValue));
RefluxHeaderId.Value = headerdr.Id.ToString();
gvReflux.DataBind();
}
}
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");
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.RefluxDetailsData ddr = mdb.RefluxDetailsDatas.Single(a => a.Id == long.Parse(RefluxDetailsId.Value));
long HeaderId = ddr.RefluxHeaderId;
mdb.RefluxDetailsDatas.Remove(ddr);
mdb.SaveChanges();
var Rows = from a in mdb.RefluxHeaderDatas where a.Id == HeaderId select a;
if (Rows.Count() <= 0)
{
ADAM.DataBase.RefluxHeaderData dr = mdb.RefluxHeaderDatas.Single(a => a.Id == HeaderId);
mdb.RefluxHeaderDatas.Remove(dr);
mdb.SaveChanges();
}
}
private void GetNum()
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.RefluxHeaderDatas where a.OrderType == int.Parse(ddlRefluxType.SelectedValue) orderby a.Id descending select a;
if (Rows.Count() == 0)
{
txtRefluxNo.Text = "1";
}
else
{
ADAM.DataBase.RefluxHeaderData dr = Rows.First();
txtRefluxNo.Text = (dr.RefluxNo + 1).ToString();
}
}
private void EditData()
{
if (ddlRefluxType.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك اختر نوع الصرف')</script>");
return;
}
if (string.IsNullOrEmpty(txtRefluxNo.Text))
{
Response.Write("<script>alert('من فضلك ادخل رقم الارتجاع')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.RefluxHeaderDatas
where a.OrderType == int.Parse(ddlRefluxType.SelectedValue) &&
a.RefluxNo == long.Parse(txtRefluxNo.Text)
select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.RefluxHeaderData dr = mdb.RefluxHeaderDatas.Single(a => a.OrderType == int.Parse(ddlRefluxType.SelectedValue) &&
a.RefluxNo == long.Parse(txtRefluxNo.Text));
RefluxHeaderId.Value = dr.Id.ToString();
gvReflux.DataBind();
if (dr.OrderType == 1)
{
ADAM.DataBase.PurchaseOrderHeader Pdr = mdb.PurchaseOrderHeaders.Single(a => a.Id == dr.ExchangeOrPurchaseHeaderId);
txtPurchaseOrExchangeOrderNo.Text = Pdr.PurchaseOrderNo.ToString();
ddlItemType.SelectedValue = dr.ItemTypeId.ToString();
txtReason.Text = dr.Reason;
txtRefluxDate.Text = dr.RefluxDate.ToString("yyyy-MM-dd");
ShowData(dr.OrderType);
}
}
else
{
Response.Write("<script>alert('من فضلك تأكد من رقم الارتجاع')</script>");
return;
}
}
