public override void btn_Delete_Click(object sender, EventArgs e) { int?supplierID = 0; if (dgrid_Result.Rows[dgrid_Result.SelectedCells[0].RowIndex].Cells["SupplierID"].Value != null) { if (MessageBox.Show("هل نت متأكد من حذف المورد؟", "تحذير", MessageBoxButtons.YesNo) == DialogResult.Yes) { supplierID = Convert.ToInt32(dgrid_Result.Rows[dgrid_Result.SelectedCells[0].RowIndex].Cells["SupplierID"].Value); BDSupplierPrimaryKey customerPK = new BDSupplierPrimaryKey(); customerPK.SupplierID = supplierID; try { _bDSupplierWrapper.Delete(customerPK); } catch (Exception ex) { MessageBox.Show("لا يمكن مسح هذا المورد .. حيث انه مرتبط بفواتير"); } } else { return; } } else { MessageBox.Show("لابد من اختيار مورد"); } Search(); }
private bool ValidateSaving() { if (cbx_Supplier.SelectedIndex == -1) { MessageBox.Show("اختار مورد أولا"); return(false); } if (cbx_Inventory.SelectedIndex == -1) { MessageBox.Show("اختار المخزن أولا"); return(false); } if (cbx_PaymentType.SelectedIndex == -1) { MessageBox.Show("اختار طريقه دفع أولا"); return(false); } if ((int)cbx_PaymentType.SelectedValue == 1 && decimal.Parse(num_Remaining.Text) > 0) { MessageBox.Show(" لا يمكن ان تكون طريقه الدفع كاش ويوجد متبقي "); return(false); } BDSupplierPrimaryKey key = new BDSupplierPrimaryKey(); key.SupplierID = int.Parse(cbx_Supplier.SelectedValue.ToString()); if (txt_invoiceNumber.Text != "" && _pURPurchaseHeaderWrapper.SelectAllByForeignKeySupplierID(key).Where(h => h.InvoiceNumber == txt_invoiceNumber.Text).Count() > 0) { MessageBox.Show("يوجد فاتوره بنفس الرقم لنفس المورد"); return(false); } return(true); }
private void FillSupplierData() { try { BDSupplierPrimaryKey _supplierPrimaryKey = new BDSupplierPrimaryKey(); _supplierPrimaryKey.SupplierID = _supplierID; _supplier = _bDSupplierWrapper.SelectOne(_supplierPrimaryKey); num_Credit.Value = _supplier.Credit.Value; num_Debit.Value = _supplier.Debit.Value; } catch (Exception) { throw; } }
private void LoadControls() { BDSupplierPrimaryKey pk = new BDSupplierPrimaryKey(); pk.SupplierID = SupplierID; supplier = supplierWrapper.SelectOne(pk); tbx_Code.Text = supplier.SupplierCode != null ? supplier.SupplierCode : ""; tbx_Name.Text = supplier.SupplierName; tbx_Address.Text = supplier.Address != null ? supplier.Address : ""; tbx_Pone1.Text = supplier.Phone1 != null ? supplier.Phone1 : ""; tbx_phone2.Text = supplier.phone2 != null ? supplier.phone2 : ""; tbx_Mobile1.Text = supplier.Mobile1 != null ? supplier.Mobile1 : ""; tbx_Mobile2.Text = supplier.Mobile2 != null ? supplier.Mobile2 : ""; tbx_Email.Text = supplier.Email != null ? supplier.Email : ""; chk_IsActive.Checked = supplier.IsActive != null ? (bool)supplier.IsActive : true; }
private void FillSupplierData() { try { BDSupplierPrimaryKey _supplierPrimaryKey = new BDSupplierPrimaryKey(); _supplierPrimaryKey.SupplierID = _supplierID; _supplier = _bDSupplierWrapper.SelectOne(_supplierPrimaryKey); num_Credit.Value = _supplier.Credit.Value; num_Debit.Value = _supplier.Debit.Value; } catch (Exception ex) { MessageBox.Show("حدث خطأ برجاء تكرار العمليه مره اخرى واذا تكرر الخطا برجاءالاتصال بالشخص المصمم للبرنامج وارسال رسالة الخطا التى ستظهر بعد قليل له"); MessageBox.Show(ex.Message); } }
public override void btn_Save_Click(object sender, EventArgs e) { if (tbx_Name.Text != "") { supplier = new BDSupplier(); BDSupplierService supplierService = new BDSupplierService(); if (SupplierID == null)//new supplier { supplier.SupplierCode = tbx_Code.Text; supplier.SupplierName = tbx_Name.Text; supplier.Address = tbx_Address.Text; supplier.Phone1 = tbx_Pone1.Text; supplier.phone2 = tbx_phone2.Text; supplier.Mobile1 = tbx_Mobile1.Text; supplier.Mobile2 = tbx_Mobile2.Text; supplier.Email = tbx_Email.Text; supplier.IsActive = chk_IsActive.Checked; supplier.Debit = 0; supplier.Credit = 0; supplierService.Insert(supplier); // ClearControls(); MessageBox.Show("تم الحفظ بنجاح"); } else { BDSupplierPrimaryKey pk = new BDSupplierPrimaryKey(); pk.SupplierID = SupplierID; supplier = supplierService.SelectOne(pk); supplier.SupplierCode = tbx_Code.Text; supplier.SupplierName = tbx_Name.Text; supplier.Address = tbx_Address.Text; supplier.Phone1 = tbx_Pone1.Text; supplier.phone2 = tbx_phone2.Text; supplier.Mobile1 = tbx_Mobile1.Text; supplier.Mobile2 = tbx_Mobile2.Text; supplier.Email = tbx_Email.Text; supplier.IsActive = chk_IsActive.Checked; supplierService.Update(supplier); MessageBox.Show("تم التعديل بنجاح"); } this.Close(); } else { MessageBox.Show("لابد من ادخال إسم المورد"); } }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="BDSupplierPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class BDSupplier</returns> public BDSupplier SelectOne(BDSupplierPrimaryKey pk) { _bDSupplierWCF = new BDSupplier(); _bDSupplier = POS.DataLayer.BDSupplierBase.SelectOne(new POS.DataLayer.BDSupplierPrimaryKey(pk.SupplierID)); _bDSupplierWCF.SupplierID = _bDSupplier.SupplierID; _bDSupplierWCF.SupplierCode = _bDSupplier.SupplierCode; _bDSupplierWCF.SupplierName = _bDSupplier.SupplierName; _bDSupplierWCF.Address = _bDSupplier.Address; _bDSupplierWCF.Phone1 = _bDSupplier.Phone1; _bDSupplierWCF.phone2 = _bDSupplier.Phone2; _bDSupplierWCF.Mobile1 = _bDSupplier.Mobile1; _bDSupplierWCF.Mobile2 = _bDSupplier.Mobile2; _bDSupplierWCF.Email = _bDSupplier.Email; _bDSupplierWCF.IsActive = _bDSupplier.IsActive; _bDSupplierWCF.Debit = _bDSupplier.Debit; _bDSupplierWCF.Credit = _bDSupplier.Credit; return _bDSupplierWCF; }
public List <BDSupplierAccount> GetSupplierAccounts(int id) { List <BDSupplierAccount> supplierAccountCollection = new List <BDSupplierAccount>(); BDSupplierPrimaryKey pk = new BDSupplierPrimaryKey(); pk.SupplierID = id; var query = SelectAllByForeignKeySupplierID(pk); if (query.Count == 0) { return(supplierAccountCollection); } supplierAccountCollection = (from item in query join customer in _supplierService.SelectAll() on item.SupplierID equals customer.SupplierID join _user in _userService.SelectAll() on item.CreatedBy equals _user.UserID select new BDSupplierAccount() { SupplierAccountId = item.SupplierAccountId, SupplierID = item.SupplierID, SupplierName = customer.SupplierName, InvoiceNumber = item.InvoiceNumber, IsVoid = item.IsVoid, PaidAmount = item.PaidAmount, RemainingAmount = item.RemainingAmount, PurchaseDate = item.PurchaseDate, PurcaseInvoiceID = item.PurcaseInvoiceID, TotalPrice = item.TotalPrice, CreateDate = item.CreateDate, CreatedByName = _user.UserFullName } ).ToList(); return(supplierAccountCollection); }
public List <BDSupplierAccount> GetSupplierAccounts(int?id, DateTime?dateFrom = null, DateTime?toFrom = null) { List <BDSupplierAccount> supplierAccountCollection = new List <BDSupplierAccount>(); var query = SelectAll().ToList(); DateTime?fromCreationDate = dateFrom != null ? dateFrom : null; DateTime?toCreationDate = toFrom != null ? toFrom : null; if (fromCreationDate != null && toCreationDate != null) { query = (from item in query where (item.CreateDate.Value.Date >= dateFrom.Value.Date && item.CreateDate.Value.Date <= toFrom.Value.Date) select item).ToList(); } if (id != null) { BDSupplierPrimaryKey pk = new BDSupplierPrimaryKey(); pk.SupplierID = id; try { query = SelectAllByForeignKeySupplierID(pk).ToList(); } catch (Exception EX) { query = new List <BDSupplierAccount>(); } } if (query.Count == 0) { return(supplierAccountCollection); } supplierAccountCollection = (from item in query join customer in _supplierService.SelectAll() on item.SupplierID equals customer.SupplierID join _user in _userService.SelectAll() on item.CreatedBy equals _user.UserID select new BDSupplierAccount() { SupplierAccountId = item.SupplierAccountId, SupplierID = item.SupplierID, SupplierName = customer.SupplierName, InvoiceNumber = item.InvoiceNumber, IsVoid = item.IsVoid, PaidAmount = item.PaidAmount, RemainingAmount = item.RemainingAmount, PurchaseDate = item.PurchaseDate, PurcaseInvoiceID = item.PurcaseInvoiceID, TotalPrice = item.TotalPrice, CreateDate = item.CreateDate, CreatedByName = _user.UserFullName, ChequeNumber = item.ChequeNumber, Credit = item.Credit, Depit = item.Depit, InvoiceType = item.InvoiceType, LstDayToPay = item.LstDayToPay } ).ToList(); return(supplierAccountCollection); }
/// <summary> /// This method will get row(s) from the database using the value of the field specified /// along with the details of the child table. /// </summary> /// /// <param name="pk" type="BDSupplierPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// <param name="orderByStatement" type="string">The field value to number.</param> /// /// <returns>object of class BDSupplierAccountCollection</returns> public BDSupplierAccountCollection SelectAllByForeignKeySupplierIDPaged(BDSupplierPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { BDSupplierAccountCollection bDSupplierAccountCollection=new BDSupplierAccountCollection(); foreach (POS.DataLayer.BDSupplierAccount _bDSupplierAccount in POS.DataLayer.BDSupplierAccountBase.SelectAllByForeignKeySupplierIDPaged(new POS.DataLayer.BDSupplierPrimaryKey(pk.SupplierID), pageSize, skipPages, orderByStatement)) { _bDSupplierAccountWCF = new BDSupplierAccount(); _bDSupplierAccountWCF.SupplierAccountId = _bDSupplierAccount.SupplierAccountId; _bDSupplierAccountWCF.PurcaseInvoiceID = _bDSupplierAccount.PurcaseInvoiceID; _bDSupplierAccountWCF.PurchaseDate = _bDSupplierAccount.PurchaseDate; _bDSupplierAccountWCF.SupplierID = _bDSupplierAccount.SupplierID; _bDSupplierAccountWCF.InvoiceNumber = _bDSupplierAccount.InvoiceNumber; _bDSupplierAccountWCF.TotalPrice = _bDSupplierAccount.TotalPrice; _bDSupplierAccountWCF.PaidAmount = _bDSupplierAccount.PaidAmount; _bDSupplierAccountWCF.IsVoid = _bDSupplierAccount.IsVoid; _bDSupplierAccountWCF.RemainingAmount = _bDSupplierAccount.RemainingAmount; _bDSupplierAccountWCF.CreateDate = _bDSupplierAccount.CreateDate; _bDSupplierAccountWCF.CreatedBy = _bDSupplierAccount.CreatedBy; _bDSupplierAccountWCF.updateDate = _bDSupplierAccount.updateDate; _bDSupplierAccountWCF.UpdatedBy = _bDSupplierAccount.UpdatedBy; _bDSupplierAccountWCF.IsDeleted = _bDSupplierAccount.IsDeleted; _bDSupplierAccountWCF.DeleteDate = _bDSupplierAccount.DeleteDate; _bDSupplierAccountWCF.DeletedBy = _bDSupplierAccount.DeletedBy; _bDSupplierAccountWCF.Depit = _bDSupplierAccount.Depit; _bDSupplierAccountWCF.Credit = _bDSupplierAccount.Credit; _bDSupplierAccountWCF.LstDayToPay = _bDSupplierAccount.LstDayToPay; _bDSupplierAccountWCF.ChequeNumber = _bDSupplierAccount.ChequeNumber; _bDSupplierAccountWCF.InvoiceType = _bDSupplierAccount.InvoiceType; bDSupplierAccountCollection.Add(_bDSupplierAccountWCF); } return bDSupplierAccountCollection; }
/// <summary> /// This method will delete row(s) from the database using the value of the field specified /// along with the details of the child table. /// </summary> /// /// <param name="pk" type="BDSupplierPrimaryKey">Primary Key information based on which data is to be deleted.</param> /// /// <returns>True if succeeded</returns> public bool DeleteAllByForeignKeySupplierID(BDSupplierPrimaryKey pk) { return POS.DataLayer.BDSupplierAccountBase.DeleteAllByForeignKeySupplierID(new POS.DataLayer.BDSupplierPrimaryKey(pk.SupplierID)); }
///<summary> ///This method will Delete the object from the database ///</summary> ///<param name="pk" type="BDSupplierPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// <returns>True if succeeded</returns> public bool Delete(BDSupplierPrimaryKey pk) { return POS.DataLayer.BDSupplierBase.Delete(new POS.DataLayer.BDSupplierPrimaryKey(pk.SupplierID)); }
public List<BDSupplierAccount> GetSupplierAccounts(int? id, DateTime? dateFrom = null, DateTime? toFrom = null) { List<BDSupplierAccount> supplierAccountCollection = new List<BDSupplierAccount>(); var query = SelectAll().ToList(); DateTime? fromCreationDate = dateFrom != null ? dateFrom : null; DateTime? toCreationDate = toFrom != null ? toFrom : null; if (fromCreationDate != null && toCreationDate != null) { query = (from item in query where (item.CreateDate.Value.Date >= dateFrom.Value.Date && item.CreateDate.Value.Date <= toFrom.Value.Date) select item).ToList(); } if (id != null) { BDSupplierPrimaryKey pk = new BDSupplierPrimaryKey(); pk.SupplierID = id; try { query = SelectAllByForeignKeySupplierID(pk).ToList(); } catch (Exception EX) { query = new List<BDSupplierAccount>(); } } if (query.Count == 0) return supplierAccountCollection; supplierAccountCollection = (from item in query join customer in _supplierService.SelectAll() on item.SupplierID equals customer.SupplierID join _user in _userService.SelectAll() on item.CreatedBy equals _user.UserID select new BDSupplierAccount() { SupplierAccountId = item.SupplierAccountId, SupplierID = item.SupplierID, SupplierName = customer.SupplierName, InvoiceNumber = item.InvoiceNumber, IsVoid = item.IsVoid, PaidAmount = item.PaidAmount, RemainingAmount = item.RemainingAmount, PurchaseDate = item.PurchaseDate, PurcaseInvoiceID = item.PurcaseInvoiceID, TotalPrice = item.TotalPrice, CreateDate = item.CreateDate, CreatedByName = _user.UserFullName, ChequeNumber = item.ChequeNumber, Credit = item.Credit, Depit = item.Depit, InvoiceType = item.InvoiceType, LstDayToPay = item.LstDayToPay } ).ToList(); return supplierAccountCollection; }
/// <summary> /// This method will get row(s) from the database using the value of the field specified /// along with the details of the child table. /// </summary> /// /// <param name="pk" type="BDSupplierPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// <param name="orderByStatement" type="string">The field value to number.</param> /// /// <returns>object of class PURPurchaseHeaderCollection</returns> public PURPurchaseHeaderCollection SelectAllByForeignKeySupplierIDPaged(BDSupplierPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { PURPurchaseHeaderCollection pURPurchaseHeaderCollection=new PURPurchaseHeaderCollection(); foreach (POS.DataLayer.PURPurchaseHeader _pURPurchaseHeader in POS.DataLayer.PURPurchaseHeaderBase.SelectAllByForeignKeySupplierIDPaged(new POS.DataLayer.BDSupplierPrimaryKey(pk.SupplierID), pageSize, skipPages, orderByStatement)) { _pURPurchaseHeaderWCF = new PURPurchaseHeader(); _pURPurchaseHeaderWCF.PurcaseHeaderID = _pURPurchaseHeader.PurcaseHeaderID; _pURPurchaseHeaderWCF.PurchaseDate = _pURPurchaseHeader.PurchaseDate; _pURPurchaseHeaderWCF.PaymentTypeID = _pURPurchaseHeader.PaymentTypeID; _pURPurchaseHeaderWCF.SupplierID = _pURPurchaseHeader.SupplierID; _pURPurchaseHeaderWCF.InvoiceNumber = _pURPurchaseHeader.InvoiceNumber; _pURPurchaseHeaderWCF.CreateDate = _pURPurchaseHeader.CreateDate; _pURPurchaseHeaderWCF.CreatedBy = _pURPurchaseHeader.CreatedBy; _pURPurchaseHeaderWCF.updateDate = _pURPurchaseHeader.updateDate; _pURPurchaseHeaderWCF.UpdatedBy = _pURPurchaseHeader.UpdatedBy; _pURPurchaseHeaderWCF.IsDeleted = _pURPurchaseHeader.IsDeleted; _pURPurchaseHeaderWCF.DeleteDate = _pURPurchaseHeader.DeleteDate; _pURPurchaseHeaderWCF.TotalPrice = _pURPurchaseHeader.TotalPrice; _pURPurchaseHeaderWCF.ServicePrice = _pURPurchaseHeader.ServicePrice; _pURPurchaseHeaderWCF.PaidAmount = _pURPurchaseHeader.PaidAmount; _pURPurchaseHeaderWCF.IsClosed = _pURPurchaseHeader.IsClosed; _pURPurchaseHeaderWCF.IsVoid = _pURPurchaseHeader.IsVoid; _pURPurchaseHeaderWCF.IsPrinted = _pURPurchaseHeader.IsPrinted; _pURPurchaseHeaderWCF.RefuseReasonID = _pURPurchaseHeader.RefuseReasonID; _pURPurchaseHeaderWCF.TotalDiscountAmount = _pURPurchaseHeader.TotalDiscountAmount; _pURPurchaseHeaderWCF.TotalDiscountRatio = _pURPurchaseHeader.TotalDiscountRatio; _pURPurchaseHeaderWCF.TaxTypeID = _pURPurchaseHeader.TaxTypeID; _pURPurchaseHeaderWCF.RemainingAmount = _pURPurchaseHeader.RemainingAmount; _pURPurchaseHeaderWCF.LastDayToPay = _pURPurchaseHeader.LastDayToPay; _pURPurchaseHeaderWCF.DeletedBy = _pURPurchaseHeader.DeletedBy; _pURPurchaseHeaderWCF.Notes = _pURPurchaseHeader.Notes; _pURPurchaseHeaderWCF.InventoryID = _pURPurchaseHeader.InventoryID; _pURPurchaseHeaderWCF.InvoiceDate = _pURPurchaseHeader.InvoiceDate; _pURPurchaseHeaderWCF.ChequeNumber = _pURPurchaseHeader.ChequeNumber; pURPurchaseHeaderCollection.Add(_pURPurchaseHeaderWCF); } return pURPurchaseHeaderCollection; }
/// <summary> /// This method will delete row(s) from the database using the value of the field specified /// along with the details of the child table. /// </summary> /// /// <param name="pk" type="BDSupplierPrimaryKey">Primary Key information based on which data is to be deleted.</param> /// /// <returns>True if succeeded</returns> public bool DeleteAllByForeignKeySupplierID(BDSupplierPrimaryKey pk) { return POS.DataLayer.PURPurchaseHeaderBase.DeleteAllByForeignKeySupplierID(new POS.DataLayer.BDSupplierPrimaryKey(pk.SupplierID)); }