public ledger(int userid) { InitializeComponent(); var financeaccountrepo = new data.dapper.financeaccountrepo(); var financetransactionrepo = new data.dapper.financetransactionrepo(); var userrepo = new data.dapper.userrepo(); financeaccounts = financeaccountrepo.get(); user = userrepo.get(userid); var list = financetransactionrepo.getusertransactions(userid); foreach (var item in list) { dg.Items.Add(item); } var totalpending = 0; if (user.role == "customer") { totalpending = financetransactionrepo.getuserreceiveablessum(userid); } else if (user.role == "vendor") { totalpending = financetransactionrepo.getuserpayablesum(userid); } remaining_label.Content = totalpending; var assetaccounts = financeaccountrepo.getmanybytype("asset"); account_combobox.ItemsSource = assetaccounts; account_combobox.DisplayMemberPath = "name"; account_combobox.SelectedValuePath = "id"; }
void getone(int userid) { selecteduser = userrepo.get(userid); tb_Name.Text = selecteduser.name; if (selecteduser.phone != null) { tb_Phone.Text = selecteduser.phone; } if (selecteduser.phone2 != null) { tb_Phone2.Text = selecteduser.phone2; } if (selecteduser.address != null) { tb_Address.Text = selecteduser.address; } if (selecteduser.role != null) { tb_Role.Text = selecteduser.role; } if (selecteduser.username != null) { tb_UserName.Text = selecteduser.username; } if (selecteduser.password != null) { tb_Password.Text = selecteduser.password; } }
public Add(string role, int?userId = null) { InitializeComponent(); userrepo = new userrepo(); if (role == "") { role = "customer"; } this.selectedrole = role; tb_Role.Text = this.selectedrole; if (userId == null || userId == 0) { this.createmode = true; } else { this.createmode = false; this.getone((int)userId); } this.loggedinpersond = userutils.loggedinuserd; if (selectedrole == "customer" || selectedrole == "vendor") { tb_Password.IsEnabled = false; tb_UserName.IsEnabled = false; } }
private void customer_button_click(object sender, RoutedEventArgs e) { var dialog = new DialogSelectUser("customer"); if (dialog.ShowDialog() == true) { customer = dialog.seleteduser; return; } }
public void delete(object sender, RoutedEventArgs e) { MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Are you sure?", "Delete Confirmation", System.Windows.MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { data.dapper.user obj = ((FrameworkElement)sender).DataContext as data.dapper.user; userrepo.delete(obj); Close(); new user.List(selectedrole).Show(); } }
private void SaveAndSelect(object sender, System.Windows.RoutedEventArgs e) { //var db = new dbctx(); data.dapper.user c = new data.dapper.user(); c.phone = tb_Phone.Text; c.role = roletype; c.name = tb_Name.Text; c.address = tb_Address.Text; //db.user.Add(c); //db.SaveChanges(); var userrepo = new userrepo(); var customer = userrepo.save(c); this.seleteduser = customer; DialogResult = true; }
public static void printDuplicateRecipt(int saleid) { var financetransactionrepo = new financetransactionrepo(); var userrepo = new userrepo(); var productrepo = new productrepo(); var productsalepurchaserepo = new productsalepurchaserepo(); var ft = financetransactionrepo.get(saleid); data.dapper.user customer = null; if (ft.fk_user_targetto_in_financetransaction != null) { customer = userrepo.get((int)ft.fk_user_targetto_in_financetransaction); } // var soldproducts = db.productsalepurchase.Where(a => a.fk_financetransaction_in_productsalepurchase == saleid).ToList(); var soldproducts = productsalepurchaserepo.getmultiplebytransactionid(saleid); float totalbill = 0; var salelist = new List <productsaleorpurchaseviewmodel>(); foreach (var item in soldproducts) { totalbill = totalbill + (float)(item.price * item.quantity); //var dbproduct = db.product.Find(item.fk_product_in_productsalepurchase); var dbproduct = productrepo.get((int)item.fk_product_in_productsalepurchase); var p = new productsaleorpurchaseviewmodel(); p.id = dbproduct.id; p.name = dbproduct.name; p.price = (double)item.price; p.quantity = (double)item.quantity; p.total = (double)item.total; } ; //int salesId, List< ItemOrDealSaleModel > list, int totalBill,int remaining, int saleType,string customerAddress string customerAddress = ""; if (customer != null) { customerAddress = customer.address + " " + customer.phone; } printing.printSaleReceipt(saleid, salelist, (int)totalbill, (int)totalbill, 0, false, customerAddress); }
private void btn_Save(object sender, RoutedEventArgs e) { if (tb_Name.Text == "") { MessageBox.Show("Please enter name", "Info"); return; } if (selectedrole == "admin" || selectedrole == "user") { if (tb_UserName.Text == "" || tb_Password.Text == "") { MessageBox.Show("Enter Username or password", "Info"); return; } } data.dapper.user person = new data.dapper.user(); person.name = tb_Name.Text; person.address = tb_Address.Text; person.phone = tb_Phone.Text; person.phone2 = tb_Phone2.Text; person.username = tb_UserName.Text; person.password = tb_Password.Text; person.role = this.selectedrole; userrepo a = new userrepo(); if (this.createmode) { a.save(person); MessageBox.Show("Person Saved", "Info"); Close(); new Add(this.selectedrole).Show(); } else { person.id = selecteduser.id; a.update(person); MessageBox.Show("Person Updated", "Info"); Close(); new Add(this.selectedrole, selecteduser.id).Show(); } }
public static string parsenumberfromuserobject(data.dapper.user user) { string res = ""; var phone1exists = true; var phone2exists = true; if (user.phone == null || user.phone == "") { phone1exists = false; } if (user.phone2 == null || user.phone2 == "") { phone2exists = false; } if (!phone1exists && !phone2exists) { return(res); } else { var parsednumber = ""; if (phone1exists) { parsednumber = parsenumberforsms(user.phone); } if (parsednumber == "") { if (phone2exists) { parsednumber = parsenumberforsms(user.phone2); } } if (parsednumber != "") { res = parsednumber; } return(res); } }
public void cancel(object sender, RoutedEventArgs e) { this.seleteduser = null; DialogResult = true; }
public void select(object sender, RoutedEventArgs e) { data.dapper.user obj = ((FrameworkElement)sender).DataContext as data.dapper.user; this.seleteduser = obj; DialogResult = true; }
public static void possale(List <productsaleorpurchaseviewmodel> saleList, double change, data.dapper.user customer, int numberofrecipiets, bool printCustomerInfoOnReciept) { var totalpayment = saleList.Sum(a => a.total); var customerid = 0; var customeraddress = ""; if (customer != null) { customerid = customer.id; customeraddress = customer.address + " " + customer.phone + " " + customer.phone2; } var saleid = financeutils.insertSaleTransactions("pos sale", saleList, totalpayment, customerid); for (int i = 0; i < numberofrecipiets; i++) { printing.printSaleReceipt(saleid, saleList, totalpayment, totalpayment + change, change, printCustomerInfoOnReciept, customeraddress); } Task.Run(() => { insertSellingProductsInDatabase(saleList, saleid); inventoryutils.updateInventoryonsale(saleList, saleid); }); }
public void ledger(object sender, RoutedEventArgs e) { data.dapper.user obj = ((FrameworkElement)sender).DataContext as data.dapper.user; new ledger(obj.id).Show(); }
public void edit(object sender, RoutedEventArgs e) { data.dapper.user obj = ((FrameworkElement)sender).DataContext as data.dapper.user; new user.Add(selectedrole, obj.id).Show(); }