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