private void button3_Click(object sender, EventArgs e) { this.Hide(); cashier aa = new cashier(); aa.Show(); }
private void button2_Click_1(object sender, EventArgs e) { this.Hide(); cashier mm = new cashier(); mm.Show(); }
private void button2_Click(object sender, EventArgs e) { this.Hide(); cashier cc = new cashier(); cc.Show(); }
public static void cashier_view(cashier _cashier, ConsoleColor color = ConsoleColor.White, bool first = true) { Console.ForegroundColor = ConsoleColor.DarkYellow; Console.WriteLine("ID: {0}\nTrabajando: {8}\nNombre: {1}\nDirección: {2}\nCódigo postal: {3}\nNúmero de teléfono: {4}\nNúmero de teléfono celular: {5}\nCorreo electrónico: {6}\nContraseña: {7}", _cashier.id.ToString().PadLeft(5, '0'), _cashier.name, _cashier.adress, _cashier.postal_code, _cashier.phone_number, _cashier.cell_phone_number, _cashier.email, _cashier.password, _cashier.working); if (_cashier.sales[0].id != 0) { Console.WriteLine("===================="); Console.WriteLine(" VENTAS "); foreach (sale _sale in _cashier.sales) { if (_sale.id != 0) { sale_view(_sale, ConsoleColor.DarkYellow, !first); } } Console.WriteLine("===================="); } Console.ForegroundColor = color; }
private void menuOpenCashier_ItemClick(object sender, ItemClickEventArgs e) { int cashier_opened = Program.db.ExecuteScalar <int>("SELECT COUNT(id) FROM cashiers WHERE opened = TRUE"); if (cashier_opened > 0) { XtraMessageBox.Show("Já existe um caixa aberto!"); return; } InformValueOpenCashierForm ivocf = new InformValueOpenCashierForm(); DialogResult rs = ivocf.ShowDialog(); if (rs == DialogResult.Cancel) { return; } try { cashier cash = new cashier() { apened_by = Program.userLogin.id, locked = false, opened = true, opened_at = Program.getDateTime(), responsible = Program.userLogin.id, value_opening = ivocf.ValueOpening }; cash.Insert(); } catch (Exception ex) { XtraMessageBox.Show(String.Format("Ocorreu um erro ao abrir o caixa!\n{0}\n\n{1}", ex.Message, ex.InnerException)); } XtraMessageBox.Show("Caixa aberto com sucesso!", "Abertura de caixa"); }
private void getCurrentCashier() { currentCashier = Program.getOpenCashier(); }
public DataTable buildAndPerformSelectDeleteQuery(string queryType, string tableName, string queryValue) { if (queryType == "select") { if (tableName == "administrator") { IEnumerable <CinemaContext.administrator> selectData = from administrator in dc.administrators select administrator; dt = LINQResultToDataTable(selectData); } if (tableName == "cashier") { IEnumerable <CinemaContext.cashier> selectData = from cashier in dc.cashiers select cashier; dt = LINQResultToDataTable(selectData); } if (tableName == "customer") { IEnumerable <CinemaContext.customer> selectData = from customer in dc.customers select customer; dt = LINQResultToDataTable(selectData); } if (tableName == "film") { IEnumerable <CinemaContext.film> selectData = from film in dc.films select film; dt = LINQResultToDataTable(selectData); } } if (queryType == "delete") { int idValue; var splitRes = queryValue.Split('='); idValue = Convert.ToInt32(splitRes[1]); if (tableName == "administrator") { administrator admin = (from r in dc.administrators where r.adminid == idValue select r).SingleOrDefault(); dc.administrators.DeleteOnSubmit(admin); dc.SubmitChanges(); IEnumerable <CinemaContext.administrator> selectData = from administrator in dc.administrators select administrator; dt = LINQResultToDataTable(selectData); } if (tableName == "cashier") { cashier cash = (from r in dc.cashiers where r.cashierid == idValue select r).SingleOrDefault(); dc.cashiers.DeleteOnSubmit(cash); dc.SubmitChanges(); IEnumerable <CinemaContext.cashier> selectData = from cashier in dc.cashiers select cashier; dt = LINQResultToDataTable(selectData); } if (tableName == "customer") { customer cust = (from r in dc.customers where r.customerid == idValue select r).SingleOrDefault(); dc.customers.DeleteOnSubmit(cust); dc.SubmitChanges(); IEnumerable <CinemaContext.customer> selectData = from customer in dc.customers select customer; dt = LINQResultToDataTable(selectData); } if (tableName == "film") { string filmTitle; var splitResult = queryValue.Split('='); filmTitle = splitRes[1]; film fil = (from r in dc.films where r.title == filmTitle select r).SingleOrDefault(); dc.films.DeleteOnSubmit(fil); dc.SubmitChanges(); IEnumerable <CinemaContext.film> selectData = from film in dc.films select film; dt = LINQResultToDataTable(selectData); } } return(dt); }
public DataTable buildAndPerformInsertQuery(string tableName, string columnName, string value) { connectionToPgSql = new NpgsqlConnection(connectionString); var splitValueResult = value.Split(','); if (tableName == "administrator") { administrator admin = new administrator(); admin.adminid = Convert.ToInt32(splitValueResult[0]); admin.fullname = splitValueResult[1]; admin.shift = Convert.ToInt32(splitValueResult[2]); admin.salary = Convert.ToDecimal(splitValueResult[3]); dc.administrators.InsertOnSubmit(admin); dc.SubmitChanges(); IEnumerable <CinemaContext.administrator> selectData = from administrator in dc.administrators select administrator; dt = LINQResultToDataTable(selectData); } if (tableName == "cashier") { cashier cash = new cashier(); cash.cashierid = Convert.ToInt32(splitValueResult[0]); cash.fullname = splitValueResult[1]; cash.shift = Convert.ToInt32(splitValueResult[2]); cash.salary = Convert.ToDecimal(splitValueResult[3]); dc.cashiers.InsertOnSubmit(cash); dc.SubmitChanges(); IEnumerable <CinemaContext.cashier> selectData = from cashier in dc.cashiers select cashier; dt = LINQResultToDataTable(selectData); } if (tableName == "customer") { customer cust = new customer(); cust.customerid = Convert.ToInt32(splitValueResult[0]); cust.cashierid = Convert.ToInt32(splitValueResult[1]); cust.category = splitValueResult[2]; cust.privilege = splitValueResult[3]; cust.privilegesize = Convert.ToDecimal(splitValueResult[4]); dc.customers.InsertOnSubmit(cust); dc.SubmitChanges(); IEnumerable <CinemaContext.customer> selectData = from customer in dc.customers select customer; dt = LINQResultToDataTable(selectData); } if (tableName == "film") { film fil = new film(); fil.title = splitValueResult[0]; fil.genre = splitValueResult[1]; fil.releasedate = Convert.ToDateTime(splitValueResult[2]); dc.films.InsertOnSubmit(fil); dc.SubmitChanges(); IEnumerable <CinemaContext.film> selectData = from film in dc.films select film; dt = LINQResultToDataTable(selectData); } return(dt); }