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(); }