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