private void ShowData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var Rows = from a in Mdb.Items where a.Code == long.Parse(txtCode.Text) && a.ItemTypeId == long.Parse(ddlItemType.SelectedValue) select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.Item dr = Mdb.Items.Single(a => a.Code == long.Parse(txtCode.Text) && a.ItemTypeId == long.Parse(ddlItemType.SelectedValue));
txtLimitQty.Text = dr.LimitQty.ToString();
txtName.Text = dr.Name;
txtNote.Text = dr.Note;
txtSpecification.Text = dr.Specification;
ddlItemStatus.SelectedValue = dr.ItemStatus.ToString();
ddlItemType.SelectedValue = dr.ItemTypeId.ToString();
ddlItemUnit.SelectedValue = dr.ItemunitId.ToString();
ddlSex.SelectedValue = dr.Sex.ToString();
ddlProductionLine.SelectedValue = dr.ProductionLineId.ToString();
#region showImg
Binary binary = dr.Image;
byte[] bytes;
string Base64String = string.Empty;
bytes = binary.ToArray();
Base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
ImgItem.ImageUrl = "data:image/png;base64," + Base64String;
#endregion
}
else
{
Response.Write("<script>alert('من فضلك تأكد من كود الصنف')</script>");
}
}
catch { Response.Write("<script>alert('خطأ أثناء عرض البيانات من فضلك تأكد من الكود او من الاتصال بقاعدة البيانات')</script>"); }
}
private void EditData()
{
try
{
if (ValidationData())
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.Item dr = Mdb.Items.Single(a => a.Code == long.Parse(txtCode.Text) && a.ItemTypeId == long.Parse(ddlItemType.SelectedValue));
if (Validation())
{
#region InsertImgIntoSql
string filePath = fulImage.PostedFile.FileName;
string filename = Path.GetFileName(filePath);
string ext = Path.GetExtension(filename);
Stream fs = fulImage.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
Byte[] bytes = br.ReadBytes((Int32)fs.Length);
#endregion
if (bytes.Count() != 0)
{
dr.Image = bytes;
}
dr.ItemStatus = int.Parse(ddlItemStatus.SelectedValue);
dr.ItemTypeId = long.Parse(ddlItemType.SelectedValue);
dr.ItemunitId = long.Parse(ddlItemUnit.SelectedValue);
dr.LimitQty = decimal.Parse(txtLimitQty.Text);
dr.Note = txtNote.Text;
dr.Sex = int.Parse(ddlSex.SelectedValue);
dr.Specification = txtSpecification.Text;
dr.ProductionLineId = int.Parse(ddlProductionLine.SelectedValue);
dr.Name = txtName.Text;
Mdb.SaveChanges();
#region showImg
if (bytes.Count() != 0)
{
Binary binary = dr.Image;
byte[] Nbytes;
string Base64String = string.Empty;
Nbytes = binary.ToArray();
Base64String = Convert.ToBase64String(bytes, 0, Nbytes.Length);
ImgItem.ImageUrl = "data:image/png;base64," + Base64String;
}
#endregion
Response.Write("<script>alert('تمت عملية التعديل بنجاح')</script>");
}
else
{
Response.Write("<script>alert('هذا الكود غير موجود بقاعدة البيانات')</script>");
}
}
}
catch { Response.Write("<script>alert('خطأ أثناء التعديل من فضلك تأكد من ادخال البيانات بشكل صحيح او الاتصال بقاعدة البيانات ')</script>"); }
}
protected void ddlItemName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.Item itm = mdb.Items.Single(a => a.Id == long.Parse(ddlItemName.SelectedValue));
txtItemCode.Text = itm.Code.ToString();
GetItemData(itm.Id);
}
catch { }
}
protected void gvExchangeRequestData_SelectedIndexChanged(object sender, EventArgs e)
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ExchangeRequestDetailsData Detailsdr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(gvExchangeRequestData.SelectedDataKey.Value.ToString()));
hfDetailsId.Value = Detailsdr.Id.ToString();
ADAM.DataBase.Item itmdr = mdb.Items.Single(a => a.Id == Detailsdr.ItemId);
ItemId.Value = itmdr.Id.ToString();
hfItemColorId.Value = Detailsdr.ItemColorId.ToString();
gvItemMovement.DataBind();
gvExchangeRequestData.DataBind();
gvExchangeRequestData.SelectedRow.BackColor = System.Drawing.Color.BurlyWood;
gvExchangeRequestData.SelectedRow.Cells[8].BackColor = gvExchangeRequestData.SelectedRow.Cells[9].BackColor = System.Drawing.Color.PaleVioletRed;
}
private void GetItemData(long ItemId)
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.Item itm = mdb.Items.Single(a => a.Id == ItemId);
ddlItemName.SelectedValue = itm.Id.ToString();
txtItemCode.Text = itm.Code.ToString();
ADAM.DataBase.ItemUnit unit = mdb.ItemUnits.Single(a => a.Id == itm.ItemunitId);
lblItemUnit.Text = unit.Name;
ADAM.DataBase.SexData sex = mdb.SexDatas.Single(a => a.Id == itm.Sex);
lblSex.Text = sex.Sex;
ADAM.DataBase.ItemStatus itmstatus = mdb.ItemStatus.Single(a => a.Id == itm.ItemStatus);
lblItemstatus.Text = itmstatus.Status;
}
private void DeleteData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.Item dr = Mdb.Items.Single(a => a.Code == long.Parse(txtCode.Text) && a.ItemTypeId == long.Parse(ddlItemType.SelectedValue));
Mdb.Items.Remove(dr);
Mdb.SaveChanges();
txtName.Text = txtCode.Text = "";
Response.Write("<script>alert('تمت عملية الحذف نجاح')</script>");
}
catch { Response.Write("<script>alert('خطأ أثناء الحذف من فضلك تأكد من ادخال البيانات بشكل صحيح او من الاتصال بقاعدة البيانات')</script>"); }
}
protected void gvPurchaseDetailsData_SelectedIndexChanged(object sender, EventArgs e)
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.DeliveryDataDetail PurchaseDetailsdr = Mdb.DeliveryDataDetails.Single(a => a.Id == long.Parse(gvDeliveryData.SelectedDataKey.Value.ToString()));
hfPurchaseDetailsId.Value = PurchaseDetailsdr.Id.ToString();
PurchaseDetailsdr.Status = 1;
DropDownList ddlLoction = gvDeliveryData.SelectedRow.FindControl("ddlLocation") as DropDownList;
if (ddlLoction.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك أدخل الـ Location')</script>");
return;
}
TextBox txtQty = gvDeliveryData.SelectedRow.FindControl("txtRealQty") as TextBox;
TextBox txtRealTester = gvDeliveryData.SelectedRow.FindControl("txtRealTester") as TextBox;
if (string.IsNullOrEmpty(txtQty.Text) || (decimal.Parse(txtQty.Text) == 0 && PurchaseDetailsdr.Qty > 0))
{
Response.Write("<script>alert('من فضلك أدخل الكمية بشكل صحيح')</script>");
return;
}
#region Insert Into Movement
ADAM.DataBase.ItemMovement itmmovdr = new DataBase.ItemMovement();
itmmovdr.AdditionalQty = decimal.Parse(txtRealTester.Text);
itmmovdr.AdditionalQtyOut = 0;
itmmovdr.AuditDetailsId = 0;
itmmovdr.DocmentId = PurchaseDetailsdr.Id;
itmmovdr.IncommingOrderNo = 0;
itmmovdr.ItemColorId = PurchaseDetailsdr.ItemColorId;
itmmovdr.ItemId = PurchaseDetailsdr.ItemId;
ADAM.DataBase.Item itmdr = Mdb.Items.Single(a => a.Id == PurchaseDetailsdr.ItemId);
itmmovdr.ItemUnitId = itmdr.ItemunitId;
itmmovdr.LocatioId = long.Parse(ddlLoction.SelectedValue);
itmmovdr.MainQty = decimal.Parse(txtQty.Text);
itmmovdr.MainQtyOut = 0;
itmmovdr.MovementDate = DateTime.Now;
itmmovdr.MovmentnameId = 16;
itmmovdr.RecDate = DateTime.Now;
itmmovdr.StoreId = 2;
itmmovdr.SupplyOrderDetailsId = 0;
itmmovdr.ParentItemMoveMentId = 0;
Mdb.ItemMovements.Add(itmmovdr);
Mdb.SaveChanges();
#endregion
gvDeliveryData.DataBind();
}
private void GetItemDatabyID(long itemID)
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.Item itmdr = Mdb.Items.Single(a => a.Id == itemID);
txtItemCode.Text = itmdr.Code.ToString();
ddlItemName.SelectedValue = itmdr.Id.ToString();
ADAM.DataBase.ItemUnit unitdr = Mdb.ItemUnits.Single(a => a.Id == itmdr.ItemunitId);
lblItemUnit.Text = unitdr.Name;
lblLimitQty.Text = itmdr.LimitQty.ToString();
ADAM.DataBase.SexData sexdr = Mdb.SexDatas.Single(a => a.Id == itmdr.Sex);
lblSex.Text = sexdr.Sex;
ADAM.DataBase.ItemStatus itmstatsudr = Mdb.ItemStatus.Single(a => a.Id == itmdr.ItemStatus);
lblItemstatus.Text = itmstatsudr.Status;
}
protected void gvItems_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
TextBox txtMainQty = gvItems.SelectedRow.FindControl("txtMainQty") as TextBox;
TextBox txtAdditionalQty = gvItems.SelectedRow.FindControl("txtAdditionalQty") as TextBox;
int ItemColorId = int.Parse(gvItems.SelectedDataKey[1].ToString());
DropDownList ddlLocation = gvItems.SelectedRow.FindControl("ddlLocation") as DropDownList;
ADAM.DataBase.Item itmdr = mdb.Items.Single(a => a.Code == long.Parse(gvItems.SelectedRow.Cells[0].Text) && a.ItemTypeId == long.Parse(ddlItemType.SelectedValue));
var CountRows = from a in mdb.ItemMovements
where a.StoreId == 2 && a.ItemColorId == ItemColorId && a.ItemId == itmdr.Id &&
a.MovmentnameId == long.Parse(ddlItemMovementName.SelectedValue)
select a;
if (CountRows.Count() > 0 && ddlItemMovementName.SelectedValue == "6")
{
Response.Write("<script>alert('لقد تم ادخل رصيد مدة لهذا الصنف مع هذا اللون')</script>");
return;
}
if (string.IsNullOrEmpty(txtMainQty.Text) || string.IsNullOrEmpty(txtAdditionalQty.Text) || ddlLocation.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك تأكد من ادخال الكميات بشكل صحيح وفي حالة عدم الرغبه في ادخال كمية ادخل صفر')</script>");
return;
}
ADAM.DataBase.ItemMovement dr = new DataBase.ItemMovement();
dr.AdditionalQty = decimal.Parse(txtAdditionalQty.Text);
dr.DocmentId = 0;
dr.ItemColorId = ItemColorId;
dr.ItemId = itmdr.Id;
dr.ItemUnitId = itmdr.ItemunitId;
dr.LocatioId = int.Parse(ddlLocation.SelectedValue);
dr.MainQty = decimal.Parse(txtMainQty.Text);
dr.MovementDate = DateTime.Now;
dr.MovmentnameId = long.Parse(ddlItemMovementName.SelectedValue);
dr.RecDate = DateTime.Now;
dr.StoreId = 2;
dr.SupplyOrderDetailsId = 0;
dr.ParentItemMoveMentId = 0;
mdb.ItemMovements.Add(dr);
mdb.SaveChanges();
}
catch { }
}
protected void gvReflux_SelectedIndexChanged(object sender, EventArgs e)
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.RefluxDetailsData dr = mdb.RefluxDetailsDatas.Single(a => a.Id == long.Parse(gvReflux.SelectedDataKey.Value.ToString()));
ADAM.DataBase.Item itmdr = mdb.Items.Single(a => a.Id == dr.ItemId);
ADAM.DataBase.ItemColor itmcolordr = mdb.ItemColors.Single(a => a.Id == dr.ItemColorId);
ADAM.DataBase.ItemUnit unitdr = mdb.ItemUnits.Single(a => a.Id == itmdr.ItemunitId);
txtItemCode.Text = itmdr.Code.ToString();
ddlItemName.SelectedValue = itmdr.Id.ToString();
ddlItemColor.SelectedValue = itmcolordr.Id.ToString();
txtQty.Text = dr.RefluxQty.ToString();
txtFreeQty.Text = dr.RefluxFreeQty.ToString();
lblItemUnit.Text = unitdr.Name;
RefluxDetailsId.Value = dr.Id.ToString();
}
private void GetNum()
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.Items where a.ItemTypeId == long.Parse(ddlItemType.SelectedValue) orderby a.Code descending select a;
if (Rows.Count() == 0)
{
txtCode.Text = "1";
}
else
{
ADAM.DataBase.Item dr = Rows.First();
txtCode.Text = (dr.Code + 1).ToString();
}
}
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();
}
protected void btnGetItemData_Click(object sender, EventArgs e)
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
if (!string.IsNullOrEmpty(txtItemCode.Text))
{
var Rows = from a in Mdb.Items where a.Code == long.Parse(txtItemCode.Text) select a;
if (Rows.Count() <= 0)
{
Response.Write("<script>alert('هذا الكود غير موجود بقاعدة البيانات')</script>");
return;
}
else
{
ADAM.DataBase.Item itmdr = Mdb.Items.Single(a => a.Code == long.Parse(txtItemCode.Text));
GetItemDatabyID(itmdr.Id);
}
}
}
protected void btnGetItem_Click(object sender, EventArgs e)
{
try
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.Items where a.Code == long.Parse(txtItemCode.Text) && a.ItemTypeId == long.Parse(ddlItemColor.SelectedValue) &&
a.ProductionLineId == long.Parse(ddlProductionLine.SelectedValue) select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.Item itm = Rows.Single(a => a.Code == long.Parse(txtItemCode.Text));
ddlItemName.SelectedValue = itm.Id.ToString();
GetItemData(itm.Id);
}
}
catch {
Response.Write("<script>alert('من فضلك تأكد من الكود')</script>");
return;
}
}
private void GetItemDatabyID(long itemID)
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.Item itmdr = Mdb.Items.Single(a => a.Id == itemID);
txtItemCode.Text = itmdr.Code.ToString();
ddlItemName.SelectedValue = itmdr.Id.ToString();
ADAM.DataBase.ItemUnit unitdr = Mdb.ItemUnits.Single(a => a.Id == itmdr.ItemunitId);
lblItemUnit.Text = unitdr.Name;
lblLimitQty.Text = itmdr.LimitQty.ToString();
ADAM.DataBase.SexData sexdr = Mdb.SexDatas.Single(a => a.Id == itmdr.Sex);
lblSex.Text = sexdr.Sex;
ADAM.DataBase.ItemStatus itmstatsudr = Mdb.ItemStatus.Single(a => a.Id == itmdr.ItemStatus);
lblItemstatus.Text = itmstatsudr.Status;
}
catch
{
Response.Write("<script>alert('نأسف لقد حدث خطأ أثناء تحميل البيانات')</script>");
return;
}
}
protected void gvExchangeRequestData_SelectedIndexChanged(object sender, EventArgs e)
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ExchangeRequestDetailsData Detailsdr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(gvExchangeRequestData.SelectedDataKey.Value.ToString()));
ADAM.DataBase.Item itmdr = mdb.Items.Single(a => a.Id == Detailsdr.ItemId);
txtItemCode.Text = itmdr.Code.ToString();
ddlItemName.SelectedValue = itmdr.Id.ToString();
ADAM.DataBase.ItemUnit Unitdr = mdb.ItemUnits.Single(a => a.Id == itmdr.ItemunitId);
txtFreeQty.Text = Detailsdr.FreeQty.ToString();
lblItemUnit.Text = Unitdr.Name;
lblLimitQty.Text = itmdr.LimitQty.ToString();
ddlItemColor.SelectedValue = Detailsdr.ItemColorId.ToString();
ADAM.DataBase.ItemStatus stdr = mdb.ItemStatus.Single(a => a.Id == itmdr.ItemStatus);
lblItemstatus.Text = stdr.Status;
txtBounce.Text = Detailsdr.Bounce.ToString();
ADAM.DataBase.SexData sexdr = mdb.SexDatas.Single(a => a.Id == itmdr.Sex);
lblSex.Text = sexdr.Sex;
txtQty.Text = Detailsdr.Qty.ToString();
txtExchangeRequestNote.Text = Detailsdr.Note;
hfDetailsId.Value = Detailsdr.Id.ToString();
GetCurrentBalance();
}
