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