public static IEnumerable <SupplierSet> getAllSuppliers() { using (var ctx = new AccountingSystem()) { return(ctx.SupplierSets.ToList()); } }
public static IEnumerable <ItemGroup> getAllCategory() {//repositoryItemComboBox1 using (var ctx = new AccountingSystem()) { return(ctx.ItemGroups.ToList()); } }
public static IEnumerable <Invoice> getAllInvoice() { using (var ctx = new AccountingSystem()) { return(ctx.Invoices.ToList()); } }
public static IEnumerable <InvoiceDetail> getInvoiceDetais(int invID) { using (var ctx = new AccountingSystem()) { return(ctx.InvoiceDetails.Where(i => i.InvoiceId == invID).ToList()); } }
public static IEnumerable <Item> getAllCategoryProducts(int catID) {//repositoryItemComboBox1 using (var ctx = new AccountingSystem()) { return(ctx.Items.Where(ctr => ctr.ItemGroupsId == catID).ToList()); } }
public static int getIvoiceCount() { using (var ctx = new AccountingSystem()) { return(ctx.Invoices.Count()); } }
private void save_Click(object sender, EventArgs e) { news.Visible = true; save.Visible = false; update.Visible = true; splashScreenManager1.ShowWaitForm(); Thread.Sleep(1000); using (var db = new AccountingSystem()) { var Branch = db.Branches.Create(); Branch.BName = search.Text; Branch.BId = Id.Text; Branch.BStatus = Status.Checked.ToString(); Branch.BPhone1 = Phone1.Text; Branch.BPhone2 = Phone2.Text; Branch.BAddress = Address.Text; db.Branches.Add(Branch); try { db.SaveChanges(); } catch (Exception dbEx) { Exception raise = dbEx; var val = dbEx.InnerException; MessageBox.Show(val.ToString()); } // MessageBox.Show("تم الحفظ بنجاح ", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Information); } fillsearch(); splashScreenManager1.CloseWaitForm(); }
public StoresForm(string Id) { InitializeComponent(); if (!Id.Equals("AddStore")) { Wharehous updatedItem = new Wharehous(); using (var db = new AccountingSystem()) { i = int.Parse(Id); updatedItem = db.Wharehouses.First(x => x.Id == i); isEditForm = true; GroupId.Text = updatedItem.Id.ToString(); GroupName.Text = updatedItem.StoreName; StoreBranch.EditValue = updatedItem.BranchID; StoreMobile.Text = updatedItem.Mobile; StoreSize.Text = updatedItem.Size + ""; StoreStatus.Checked = (bool)updatedItem.Status; StoreAddress.Text = updatedItem.Address; } } else { GetId(); } CancelBtn.Visible = true; }
private void news_Click(object sender, EventArgs e) { update.Visible = false; save.Visible = true; using (var db = new AccountingSystem()) { var dc = from c in db.Groups //where c.Id.Equals(InvoiceID) select new { c.Id, }; var list = dc.ToList(); int id = list.Count; GroupId.Text = (id + 1).ToString(); } search.Text = ""; Admin.Checked = false; Sells.Checked = false; Buys.Checked = false; Warehouse.Checked = false; Account.Checked = false; VendorSupplier.Checked = false; Other.Checked = false; }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (MessageBox.Show("هل تريد الحذف؟", "تأكيد", MessageBoxButtons.YesNo) != DialogResult.Yes) { return; } string no = DebGrid.GetRowCellValue(DebGrid.FocusedRowHandle, "DebentureID").ToString(); int i = int.Parse(no); using (var db = new AccountingSystem()) { var widgets = db.debenturedetails.Where(x => x.DebentureID.Equals(i)); foreach (debenturedetail widget in widgets) { db.debenturedetails.Remove(widget); } db.SaveChanges(); var d = db.debentures.Where(x => x.DebentureID.Equals(i)); foreach (debenture widget in d) { db.debentures.Remove(widget); } db.SaveChanges(); MessageBox.Show("تم الحذف بنجاح"); Refresh(); } }
public static IEnumerable <Item> getAllProducts() {//repositoryItemComboBox1 using (var ctx = new AccountingSystem()) { return(ctx.Items.ToList()); } }
public static TObject Find <TObject>(int id) where TObject : class { using (var ctx = new AccountingSystem()) { return(ctx.Set <TObject>().Find(id)); } }
private void VendBankName_EditValueChanged(object sender, EventArgs e) { using (var d = new AccountingSystem()) { var dc = from ff in d.BankBranches where (ff.IdBank.Equals(VendBankName.EditValue.ToString())) select new { ff.BranchName, ff.IdBank, ff.Id }; bindingSource4.DataSource = dc.ToList(); VendBranch.Refresh(); } }
private void GetItems() { using (var db = new AccountingSystem()) { var dc = from c in db.Items select new { c.Id, c.Name }; cmbItem.Properties.DataSource = dc.ToList(); cmbItem.Properties.ValueMember = "Id"; cmbItem.Properties.DisplayMember = "Name"; } }
private void GetPayType() { using (var db = new AccountingSystem()) { var dc = from c in db.PaymentTypes select new { c.PaymentTypeID, c.PaymentTypeName }; cmbPaymentType.Properties.DataSource = dc.ToList(); cmbPaymentType.Properties.ValueMember = "PaymentTypeID"; cmbPaymentType.Properties.DisplayMember = "PaymentTypeName"; } }
public static int Update <TObject>(TObject obj) where TObject : class { using (var ctx = new AccountingSystem()) { ctx.Set(typeof(TObject)).Attach(obj); ctx.Entry(obj).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); return(0); } }
private void GetCustomers() { using (var db = new AccountingSystem()) { var dc = from c in db.VendorSets select new { c.Id, c.VendorName }; cmbCustomerID.Properties.DataSource = dc.ToList(); cmbCustomerID.Properties.ValueMember = "Id"; cmbCustomerID.Properties.DisplayMember = "VendorName"; } }
public static int Add <TEntity>(TEntity entity) { using (var ctx = new AccountingSystem()) { //entity.cuid = LogTracker.GetLoggedUser().FullName; //entity.MakeCreated(); ctx.Set(typeof(TEntity)).Add(entity); ctx.SaveChanges(); return(0); } }
private void GetCurrency() { using (var db = new AccountingSystem()) { var dc = from c in db.CurrencySets select new { c.Id, c.CurrencyName }; cmbCurreny.Properties.DataSource = dc.ToList(); cmbCurreny.Properties.ValueMember = "Id"; cmbCurreny.Properties.DisplayMember = "CurrencyName"; } }
public void ReportVendors() { isVendor = true; isSpuulier = false; Vendor.Visible = true; Supplier.Visible = false; //MessageBox.Show(ReprotStatus.SelectedIndex.ToString()); using (var db = new AccountingSystem()) { String status = "2"; if ((ReprotStatus.SelectedIndex.ToString().Equals("0")) || (ReprotStatus.SelectedIndex.ToString().Equals("1"))) { if (ReprotStatus.SelectedIndex.ToString().Equals("0")) { status = "True"; } if (ReprotStatus.SelectedIndex.ToString().Equals("1")) { status = "False"; } var dc = from c in db.VendorSets where c.VendorStatus.Equals(status) select new { c.VendorName, c.VendorCompanyName, c.VendorStatus, c.VendorBankName, c.VendorPhone1, c.VendorTypeOfBalance }; bindingSource1.DataSource = dc.ToList(); Vendor.Refresh(); } else { var dc = from c in db.VendorSets //where c.VendorStatus.Equals(status) select new { c.VendorName, c.VendorCompanyName, c.VendorStatus, c.VendorBankName, c.VendorPhone1, c.VendorTypeOfBalance }; bindingSource1.DataSource = dc.ToList(); Vendor.Refresh(); } } }
private void simpleButton1_Click(object sender, EventArgs e) { save.Visible = false; news.Visible = true; update.Visible = true; using (var db = new AccountingSystem()) { var na = from b in db.Groups where b.Name.Equals(search.Text) select new { b.Id }; var lis = na.ToList(); string Gid = lis[0].Id.ToString(); if (lis.Count != 0) { var dc = from c in db.PermissionControls where c.CGroupId.Equals(Gid) select new { c.CGroupId, c.CAdmin, c.CSells, c.CBuys, c.CWarehouse, c.CVendorSupplier, c.CAccount, c.COther, }; var list = dc.ToList(); if (list.Count != 0) { Other.Checked = list[0].COther; Account.Checked = list[0].CAccount; Admin.Checked = list[0].CAdmin; Sells.Checked = list[0].CSells; Buys.Checked = list[0].CBuys; Warehouse.Checked = list[0].CWarehouse; VendorSupplier.Checked = list[0].CVendorSupplier; GroupId.Text = list[0].CGroupId; } else { MessageBox.Show("عفوا لا يوجد عميل بهذا الاسم", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } }
private void save_Click(object sender, EventArgs e) { if (search.Text.Equals("") || search.Text.Equals(" ")) { DevExpress.XtraEditors.XtraMessageBox.Show("الرجاء ادخال اسم المستخدم"); } else if (Branch.Text.Equals("") || Branch.Text.Equals(" ")) { DevExpress.XtraEditors.XtraMessageBox.Show("الرجاء اختيار الفرع"); } else if (Password.Text.Equals("") || Password.Text.Equals(" ")) { DevExpress.XtraEditors.XtraMessageBox.Show("الرجاء ادخال كلمة المرور"); } else if (Group.Text.Equals("") || Group.Text.Equals(" ")) { DevExpress.XtraEditors.XtraMessageBox.Show("الرجاء اختيار المجموعة"); } else { news.Visible = true; save.Visible = false; update.Visible = true; splashScreenManager1.ShowWaitForm(); Thread.Sleep(1000); using (var db = new AccountingSystem()) { var User = db.Users.Create(); User.UCode = Code.Text; User.UName = search.Text; User.UStatus = Status.Checked.ToString(); User.UBranch = Branch.EditValue.ToString(); User.UPassword = Password.Text; User.UGroup = Group.EditValue.ToString(); db.Users.Add(User); try { db.SaveChanges(); } catch (Exception dbEx) { Exception raise = dbEx; var val = dbEx.InnerException; MessageBox.Show(val.ToString()); } } fillsearch(); splashScreenManager1.CloseWaitForm(); } }
public GroupForms(string id) { ItemGroup updatedItem = new ItemGroup(); InitializeComponent(); GroupId.Text = id; using (var db = new AccountingSystem()) { i = int.Parse(id); updatedItem = db.ItemGroups.First(x => x.Id == i); isEditForm = true; GroupName.Text = updatedItem.Name; } }
public VenforVendpliersReview() { InitializeComponent(); Vendor.Visible = true; Supplier.Visible = false; // This line of code is generated by Data Source Configuration Wizard // Instantiate a new DBContext dbContext = new Purchase.AccountingSystem(); // Call the Load method to get the data for the given DbSet from the database. dbContext.VendorSets.Load(); // This line of code is generated by Data Source Configuration Wizard using (var db = new AccountingSystem()) { var dc = from c in db.VendorSets //where c.Id.Equals(InvoiceID) select new { c.VendorName, c.VendorCompanyName, c.VendorStatus, c.VendorBankName, c.VendorPhone1, c.VendorTypeOfBalance }; bindingSource1.DataSource = dc.ToList(); } // This line of code is generated by Data Source Configuration Wizard // Instantiate a new DBContext // Call the Load method to get the data for the given DbSet from the database. dbContext.SupplierSets.Load(); // This line of code is generated by Data Source Configuration Wizard using (var db = new AccountingSystem()) { var dc = from c in db.SupplierSets //where c.Id.Equals(InvoiceID) select new { c.SupplierName, c.SupplierCompanyName, c.SupplierStatus, c.SupplierBankName, c.SupplierPhone1, c.SupplierTypeOfBalance }; bindingSource2.DataSource = dc.ToList(); //bindingSource2.DataSource = dbContext.SupplierSets.Local.ToBindingList(); } ReprotStatus.SelectedIndex = 2; }
private void GetId() { using (var db = new AccountingSystem()) { var dc = 0; try { dc = (from c in db.Wharehouses select c.Id).Max(); } catch (Exception) { } GroupId.Text = (int.Parse(dc.ToString()) + 1) + ""; } }
public GroupForms() { InitializeComponent(); using (var db = new AccountingSystem()) { var dc = 0; try { dc = (from c in db.ItemGroups select c.Id).Max(); }catch (Exception) { } GroupId.Text = (int.Parse(dc.ToString()) + 1) + ""; } }
private void ItemCode_EditValueChanged(object sender, EventArgs e) { using (var db = new AccountingSystem()) { if (db.Items.Any(o => o.Code == ItemCode.Text)) { if (!ItemCode.Text.Equals(currentCode) && isEditForm) { dxErrorProvider1.SetError(ItemCode, "هذا الكود موجود", DevExpress.XtraEditors.DXErrorProvider.ErrorType.Critical); } else { dxErrorProvider1.ClearErrors(); } } } }
private void AddGroup_Load(object sender, EventArgs e) { update.Visible = false; using (var db = new AccountingSystem()) { var dc = from c in db.Groups //where c.Id.Equals(InvoiceID) select new { c.Id, }; var list = dc.ToList(); int id = list.Count; GroupId.Text = (id + 1).ToString(); } fillsearch(); }
private void update_Click(object sender, EventArgs e) { splashScreenManager1.ShowWaitForm(); Thread.Sleep(1000); using (var db = new AccountingSystem()) { try { var Control = db.PermissionControls.First(x => x.CGroupId.Equals(GroupId.Text.ToString())); Control.CAdmin = Admin.Checked; Control.CSells = Sells.Checked; Control.CBuys = Buys.Checked; Control.CWarehouse = Warehouse.Checked; Control.CAccount = Account.Checked; Control.CVendorSupplier = VendorSupplier.Checked; Control.COther = Other.Checked; db.Entry(Control).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); raise = new InvalidOperationException(message, raise); } } throw raise; } catch (Exception dbEx) { Exception raise = dbEx; var val = dbEx.InnerException; MessageBox.Show(val.ToString()); //throw raise; } } fillsearch(); splashScreenManager1.CloseWaitForm(); }
private void update_Click(object sender, EventArgs e) { splashScreenManager1.ShowWaitForm(); Thread.Sleep(1000); using (var db = new AccountingSystem()) { try { var Branch = db.Branches.First(x => x.BId.Equals(Id.Text.ToString())); Branch.BName = search.Text; Branch.BId = Id.Text; Branch.BStatus = Status.Checked.ToString(); Branch.BPhone1 = Phone1.Text; Branch.BPhone2 = Phone2.Text; Branch.BAddress = Address.Text; db.Branches.Add(Branch); db.Entry(Branch).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); raise = new InvalidOperationException(message, raise); } } throw raise; } catch (Exception dbEx) { Exception raise = dbEx; var val = dbEx.InnerException; MessageBox.Show(val.ToString()); //throw raise; } } fillsearch(); splashScreenManager1.CloseWaitForm(); }