private void EditData()
{
try
{
if (string.IsNullOrEmpty(txtDate.Text) || string.IsNullOrEmpty(txtDirectSellOrderNo.Text) ||
ddlDivision.SelectedValue == "0" || ddlDepartment.SelectedValue == "0" || ddlEmployee.SelectedValue == "0" || ddlItemType.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك تأكد من ادخال كل البيانات بشكل صحيح')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.DirectSellData dr = Mdb.DirectSellDatas.Single(a => a.DirectSellNo == long.Parse(txtDirectSellOrderNo.Text));
if (Validation())
{
dr.DirectSellDate = DateTime.Parse(txtDate.Text);
dr.DirectSellNo = long.Parse(txtDirectSellOrderNo.Text);
dr.EmpId = long.Parse(ddlEmployee.SelectedValue);
Mdb.SaveChanges();
Response.Write("<script>alert('تمت عملية التعديل بنجاح')</script>");
}
else
{
Response.Write("<script>alert('هذا الكود غير موجود بقاعدة البيانات')</script>");
}
}
catch { Response.Write("<script>alert('خطأ أثناء التعديل من فضلك تأكد من ادخال البيانات بشكل صحيح او الاتصال بقاعدة البيانات ')</script>"); }
}
private void ShowData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var Rows = from a in Mdb.DirectSellDatas where a.DirectSellNo == long.Parse(txtDirectSellOrderNo.Text) select a;
if (Rows.Count() > 0)
{
#region ShowHeader
ADAM.DataBase.DirectSellData dr = Mdb.DirectSellDatas.Single(a => a.DirectSellNo == long.Parse(txtDirectSellOrderNo.Text));
txtDirectSellOrderNo.Text = dr.DirectSellNo.ToString();
txtDate.Text = dr.DirectSellDate.ToString("yyyy-MM-dd");
ADAM.DataBase.EmployeeData Empdr = Mdb.EmployeeDatas.Single(a => a.Id == dr.EmpId);
ADAM.DataBase.division divdr = Mdb.divisions.Single(a => a.Id == Empdr.DivisionId);
ADAM.DataBase.Department depId = Mdb.Departments.Single(a => a.Id == divdr.DepartmentId);
ddlDepartment.SelectedValue = depId.Id.ToString();
ddlDivision.DataBind();
ddlDivision.SelectedValue = divdr.Id.ToString();
ddlEmployee.DataBind();
ddlEmployee.SelectedValue = dr.EmpId.ToString();
ddlItemType.SelectedValue = dr.ItemType.ToString();
hfId.Value = dr.Id.ToString();
ddlItemType.Enabled = false;
#endregion
gvPurchaseDetailsData.DataBind();
}
else
{
Response.Write("<script>alert('من فضلك تأكد من رقم طلب الشراء')</script>");
}
}
catch { Response.Write("<script>alert('خطأ أثناء عرض البيانات من فضلك تأكد من الكود او من الاتصال بقاعدة البيانات')</script>"); }
}
private void GetNum()
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.DirectSellDatas orderby a.Id descending select a;
if (Rows.Count() == 0)
{
txtDirectSellOrderNo.Text = "1";
}
else
{
ADAM.DataBase.DirectSellData dr = Rows.First();
txtDirectSellOrderNo.Text = (dr.DirectSellNo + 1).ToString();
}
}
protected void btndeletePurchaseItem_Click(object sender, ImageClickEventArgs e)
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.DierctSellDetail PurcahseOrderdetaildr = Mdb.DierctSellDetails.Single(a => a.Id == long.Parse(hfPurchaseDetailsId.Value));
Mdb.DierctSellDetails.Remove(PurcahseOrderdetaildr);
Mdb.SaveChanges();
gvPurchaseDetailsData.DataBind();
var PurchaseOrderHeaderRows = from a in Mdb.DierctSellDetails where a.DirectSellHeaderId == long.Parse(hfId.Value) select a;
if (PurchaseOrderHeaderRows.Count() <= 0)
{
ADAM.DataBase.DirectSellData PurchaseHeadedr = Mdb.DirectSellDatas.Single(a => a.Id == long.Parse(hfId.Value));
Mdb.DirectSellDatas.Remove(PurchaseHeadedr);
Mdb.SaveChanges();
btnNew_Click(sender, e);
}
}
private void DeleteData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.DirectSellData dr = Mdb.DirectSellDatas.Single(a => a.DirectSellNo == long.Parse(txtDirectSellOrderNo.Text));
var DirectSellDetailsRows = from a in Mdb.DierctSellDetails where a.DirectSellHeaderId == dr.Id select a;
foreach (ADAM.DataBase.DierctSellDetail ddr in DirectSellDetailsRows)
{
Mdb.DierctSellDetails.Remove(ddr);
Mdb.SaveChanges();
}
Mdb.DirectSellDatas.Remove(dr);
Mdb.SaveChanges();
txtDate.Text = txtDirectSellOrderNo.Text = "";
ddlEmployee.SelectedValue = ddlDepartment.SelectedValue = ddlDivision.SelectedValue = ddlItemType.SelectedValue = "0";
Response.Write("<script>alert('تمت عملية الحذف نجاح')</script>");
}
catch { Response.Write("<script>alert('خطأ أثناء الحذف من فضلك تأكد من ادخال البيانات بشكل صحيح او من الاتصال بقاعدة البيانات')</script>"); }
}
