private void GetExchangeRequestCode()
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var Rows = from a in Mdb.ExchangeRequestHeaderDatas where a.OrderType == long.Parse(ddlExchangeRequestType.SelectedValue) orderby a.Id descending select a;
if (Rows.Count() == 0)
{
txtExchangeRequestNo.Text = "1";
}
else
{
ADAM.DataBase.ExchangeRequestHeaderData dr = Rows.First();
txtExchangeRequestNo.Text = (dr.ExchangeRequestNo + 1).ToString();
}
}
protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 3;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
if (string.IsNullOrEmpty(txtExchangeRequestNo.Text))
{
Response.Write("<script>alert('من فضلك ادخل رقم طلب الصرف')</script>");
return;
}
txtExchangeRequestNo.Enabled = false;
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var HRows = from a in mdb.ExchangeRequestHeaderDatas
where a.OrderType == int.Parse(ddlExchangeRequestType.SelectedValue) &&
a.ExchangeRequestNo == int.Parse(txtExchangeRequestNo.Text)
select a;
if (HRows.Count() > 0)
{
ADAM.DataBase.ExchangeRequestHeaderData Hdr = mdb.ExchangeRequestHeaderDatas.Single(a => a.ExchangeRequestNo == int.Parse(txtExchangeRequestNo.Text) &&
a.OrderType == int.Parse(ddlExchangeRequestType.SelectedValue));
hfId.Value = Hdr.Id.ToString();
ddlClient.SelectedValue = Hdr.ClientId.ToString();
ADAM.DataBase.division Ddr = mdb.divisions.Single(a => a.Id == Hdr.DivisionId);
ADAM.DataBase.Department Depdr = mdb.Departments.Single(a => a.Id == Ddr.DepartmentId);
ddlDepartment.SelectedValue = Depdr.Id.ToString();
ddlDivision.DataBind();
ddlDivision.SelectedValue = Ddr.Id.ToString();
ddlEmployee.DataBind();
ddlEmployee.SelectedValue = Hdr.EmpId.ToString();
txtDate.Text = Hdr.ExchangeRequestDate.ToString("yyyy-MM-dd");
//gvExchangeRequestData.DataBind();
}
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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");
}
try
{
ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString();
long SalesCost = db.AccountHelpers.Single(a => a.Id == 2).AccountId;
long StoreAccount = db.ItemTypes.Single(a => a.Id == db.ExchangeRequestDetailsDatas.Single(aa => aa.ExchangeRequestHeaderDataId == long.Parse(hfExchangeheaderId.Value.ToString())).ItemTypeId).AccountId;
long ClientAccount = db.ClientDatas.Single(a => a.Id == long.Parse(ddlClient.SelectedValue)).AccountId;
long SalesAccount = db.AccountHelpers.Single(a => a.Id == 1).AccountId;
csJournal csAddjournal = new csJournal();
long JournalHeaderId = csAddjournal.InsertIntoJournalHeader(0, DateTime.Now, int.Parse(ddlExchangeRequestType.SelectedValue), "قيد فاتورة بيع", 0, long.Parse(hfExchangeheaderId.Value));
csAddjournal.InsertIntoJournalDetails(SalesAccount, long.Parse(ddlCostCenterName.SelectedValue), decimal.Parse(ViewState["AllItemCost"].ToString()), 0, JournalHeaderId, "من حـ / تكلفة المبيعات");
csAddjournal.InsertIntoJournalDetails(StoreAccount, long.Parse(ddlCostCenterName.SelectedValue), 0, decimal.Parse(ViewState["AllItemCost"].ToString()), JournalHeaderId, "الي حـ / المخزن");
csAddjournal.InsertIntoJournalDetails(ClientAccount, long.Parse(ddlCostCenterName.SelectedValue), decimal.Parse(lblBillPrice.Text), 0, JournalHeaderId, "من حـ / العميل");
csAddjournal.InsertIntoJournalDetails(SalesAccount, long.Parse(ddlCostCenterName.SelectedValue), 0, decimal.Parse(lblBillPrice.Text), JournalHeaderId, "الي حـ / المبيعات");
ADAM.DataBase.ExchangeRequestHeaderData ERHdr = db.ExchangeRequestHeaderDatas.Single(a => a.Id == long.Parse(hfExchangeheaderId.Value));
ERHdr.Posted = 1;
db.SaveChanges();
hfExchangeheaderId.Value = "0";
gvExchangeData.DataBind();
}
catch { }
}
private void GetExchangeOrderData()
{
lblExchangeOrderType.Visible = ddlExchangeRequestType.Visible = true;
ddlSupplierName.Visible = lblSupplierName.Visible = false;
lblOrderName.Text = "رقم أذن الصرف";
lblDate.Text = "تاريخ طلب الصرف";
if (!string.IsNullOrEmpty(txtPurchaseOrExchangeOrderNo.Text))
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
#region GetExchangeOrderHeader
var Rows = from a in mdb.ExchangeRequestDetailsDatas
where a.ExchangeRequestOrder == long.Parse(txtPurchaseOrExchangeOrderNo.Text) &&
a.ExchangeRequestHeaderData.OrderType == int.Parse(ddlExchangeRequestType.SelectedValue)
orderby a.Id descending
select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.ExchangeRequestHeaderData Headerdr = mdb.ExchangeRequestHeaderDatas.Single(a => a.Id == Rows.First().ExchangeRequestHeaderDataId);
ADAM.DataBase.division div = mdb.divisions.Single(a => a.Id == Headerdr.DivisionId);
ddlDepartment.SelectedValue = div.DepartmentId.ToString();
ddlDivision.DataBind();
ddlDivision.SelectedValue = Headerdr.DivisionId.ToString();
ddlEmployee.DataBind();
ddlEmployee.SelectedValue = Headerdr.EmpId.ToString();
txtDate.Text = Headerdr.ExchangeRequestDate.ToString("yyyy-MM-dd");
hfPurchaseHeaderId.Value = "0";
hfExchangeRequestHeaderId.Value = Headerdr.Id.ToString();
gvExchangeRequestData.DataBind();
}
else
{
Response.Write("<script>alert('من تأكد من رقم طلب الصرف')</script>");
return;
}
#endregion
}
}
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.ExchangeRequestDetailsData Detailsdr = Mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(hfDetailsId.Value));
if (Detailsdr.Status == 0)
{
Mdb.ExchangeRequestDetailsDatas.Remove(Detailsdr);
Mdb.SaveChanges();
gvExchangeRequestData.DataBind();
var Rows = from a in Mdb.ExchangeRequestDetailsDatas where a.ExchangeRequestHeaderDataId == long.Parse(hfId.Value) select a;
if (Rows.Count() <= 0)
{
ADAM.DataBase.ExchangeRequestHeaderData Hdr = Mdb.ExchangeRequestHeaderDatas.Single(a => a.Id == long.Parse(hfId.Value));
Mdb.ExchangeRequestHeaderDatas.Remove(Hdr);
Mdb.SaveChanges();
Response.Redirect("~/StoreData/webUpdateExchangeRequest.aspx");
}
}
else
{
Response.Write("<script>alert('لقد تم صرف هذا الصنف من المخزن')</script>");
return;
}
}
protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
if (string.IsNullOrEmpty(txtExchangeRequestNo.Text))
{
Response.Write("<script>alert('من فضلك ادخل رقم طلب الصرف')</script>");
return;
}
txtExchangeRequestNo.Enabled = false;
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var HRows = from a in mdb.ExchangeRequestHeaderDatas
where a.OrderType == int.Parse(ddlExchangeRequestType.SelectedValue) && a.ExchangeRequestNo == int.Parse(txtExchangeRequestNo.Text)
select a;
if (HRows.Count() > 0)
{
ADAM.DataBase.ExchangeRequestHeaderData Hdr = mdb.ExchangeRequestHeaderDatas.Single(a => a.ExchangeRequestNo == int.Parse(txtExchangeRequestNo.Text) &&
a.OrderType == int.Parse(ddlExchangeRequestType.SelectedValue));
hfId.Value = Hdr.Id.ToString();
ADAM.DataBase.ClientData client = mdb.ClientDatas.Single(a => a.Id == Hdr.ClientId);
ADAM.DataBase.division Ddr = mdb.divisions.Single(a => a.Id == Hdr.DivisionId);
ADAM.DataBase.Department Depdr = mdb.Departments.Single(a => a.Id == Ddr.DepartmentId);
ddlDepartment.SelectedValue = Depdr.Id.ToString();
ddlDivision.DataBind();
ddlDivision.SelectedValue = Ddr.Id.ToString();
ddlEmployee.DataBind();
ddlEmployee.SelectedValue = Hdr.EmpId.ToString();
txtDate.Text = Hdr.ExchangeRequestDate.ToString("yyyy-MM-dd");
txtClientAddress.Text = client.Address;
txtClientMob.Text = client.FirstMobile;
txtClientName.Text = client.FirstName + " " + client.LastName;
txtClientPhone.Text = client.FirstPhone;
gvExchangeRequestData.DataBind();
}
}
protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
try
{
if (ddlExchangeRequestType.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك أختر نوع طلب الصرف')</script>");
return;
}
if (ddlExchangeRequestType.SelectedValue == "10")
{
hfExchangeRequestType.Value = "8";
}
if (ddlExchangeRequestType.SelectedValue == "11")
{
hfExchangeRequestType.Value = "9";
}
if (ddlExchangeRequestType.SelectedValue == "12")
{
hfExchangeRequestType.Value = "10";
}
if (ddlExchangeRequestType.SelectedValue == "13")
{
hfExchangeRequestType.Value = "11";
}
if (ddlExchangeRequestType.SelectedValue == "14")
{
hfExchangeRequestType.Value = "12";
}
if (string.IsNullOrEmpty(txtExchangeRequestNo.Text))
{
Response.Write("<script>alert('من فضلك أدخل رقم طلب الصرف')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString();
var ExchangeRequestRow = from a in db.ExchangeRequestHeaderDatas where a.ExchangeRequestNo == long.Parse(txtExchangeRequestNo.Text) && a.OrderType == long.Parse(hfExchangeRequestType.Value) select a;
if (ExchangeRequestRow.Count() > 0)
{
ADAM.DataBase.ExchangeRequestHeaderData ERHdr = db.ExchangeRequestHeaderDatas.Single(a => a.ExchangeRequestNo == long.Parse(txtExchangeRequestNo.Text) && a.OrderType == long.Parse(hfExchangeRequestType.Value));;
if (ERHdr.Posted == 1)
{
Response.Write("<script>alert('لقد تم انشاء فاتورة لهذا الطلب من قبل')</script>");
hfExchangeheaderId.Value = "0";
gvExchangeData.DataBind();
return;
}
txtExchangeRequestDate.Text = ERHdr.ExchangeRequestDate.ToString("yyyy-MM-dd");
ddlClient.SelectedValue = ERHdr.ClientId.ToString();
txtClientCode.Text = db.ClientDatas.Single(a => a.Id == ERHdr.ClientId).Code.ToString();
hfExchangeheaderId.Value = ERHdr.Id.ToString();
gvExchangeData.DataBind();
decimal AllPrice = 0;
decimal AllItemCost = 0;
ADAM.DataBase.IncommingOrderData incomdr = new DataBase.IncommingOrderData();
for (int GRow = 0; GRow < gvExchangeData.Rows.Count; GRow++)
{
decimal Qty = 0;
decimal Price = 0;
decimal Tester = 0;
decimal TPrice = 0;
Qty = decimal.Parse(gvExchangeData.Rows[GRow].Cells[3].Text);
Price = decimal.Parse(gvExchangeData.Rows[GRow].Cells[4].Text);
Tester = decimal.Parse(gvExchangeData.Rows[GRow].Cells[5].Text);
TPrice = decimal.Parse(gvExchangeData.Rows[GRow].Cells[6].Text);
incomdr = db.IncommingOrderDatas.Single(a => a.Id == long.Parse(gvExchangeData.DataKeys[GRow].Value.ToString()));
AllItemCost += incomdr.ItemPrice * Qty;
AllPrice += (Qty * Price) + (Tester * TPrice);
}
lblBillPrice.Text = AllPrice.ToString();
txtExchangeRequestNo.Enabled = false;
ViewState["AllItemCost"] = AllItemCost.ToString();
}
else
{
Response.Write("<script>alert('من فضلك تأكد من رقم طلب الصرف')</script>");
return;
}
}
catch { }
}
