public DialogSelectUser(string roletype) { InitializeComponent(); tb_Phone.Focus(); this.roletype = roletype; // var db = new dbctx(); var userrepo = new userrepo(); ////var db = new dbctx(); if (roletype == "staff") { //dg_AllStaff.ItemsSource = db.user.Where(a => (a.role == "admin" || a.role == "user")).ToList(); var roles = new object[] { "admin", "user" }; allusers = userrepo.getbywherein("role", roles); } else if (roletype == "customer") { //dg_AllStaff.ItemsSource = db.user.Where(a => a.role == "customer").ToList(); var roles = new object[] { "customer" }; allusers = userrepo.getbywherein("role", roles); } else { //dg_AllStaff.ItemsSource = db.user.Where(a => a.role == "vendor").ToList(); var roles = new object[] { "vendor" }; allusers = userrepo.getbywherein("role", roles); } dg.ItemsSource = allusers; }
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(); } }
void loaccounts() { var userrepo = new userrepo(); var financetransactionrepo = new financetransactionrepo(); var sales = 0; var customers = 0; var vendors = 0; var users = 0; if (userutils.loggedinuserd.role == "superadmin" || userutils.loggedinuserd.role == "admin") { sales = -financetransactionrepo.gettransactionsumbyaccountnamesandfromtodate(new string[] { "pos sale", "sale", "service sale" }, DateTime.Now, DateTime.Now); customers = userrepo.getbywherein("role", new object[] { "customer" }).Count(); vendors = userrepo.getbywherein("role", new object[] { "vendor" }).Count(); users = userrepo.getbywherein("role", new object[] { "admin", "user" }).Count(); } string html = @"<html> <head> <style> html{overflow:hidden;height:200px;} .main{ font-family: arial; } .blocks{ float: left; width: 20%; margin: 1%; border: 1px solid #ddd; padding: 10px 20px 10px 20px; border-radius: 4px; } .blocks .title{ margin: 0; font-weight: 300; color: #888; } .blocks p{ text-align: center; font-size: 55px; } p.a{ color:rgb(98, 147, 211); } p.b{ color:#f5584c; } p.c{ color:#aa6edb; } p.d{ color:#7fb856; } .blocks .footer{ margin: 0; font-weight: 100; color: #888; font-size:10px; text-align: center; } </style> </head> <body style='background-color:#f0f0f0' scroll='no'> <div class='main'> <div class='blocks'> <span class='title'>Sales</span> <p class='a'>" + sales + @"</p> <span class='footer'>Total Sales</span> </div> <div class='blocks'> <span class='title'>Customers</span> <p class='b'>" + customers + @"</p> <span class='footer'>Included All Types</span> </div> <div class='blocks'> <span class='title'>Vendors</span> <p class='c'>" + vendors + @"</p> <span class='footer'>Included All Types</span> </div> <div class='blocks'> <span class='title'>Users</span> <p class='d'>" + users + @"</p> <span class='footer'>All software users</span> </div> <div> </body> </html>"; webview.NavigateToString(html); }