private void BtnSalvar_Click(object sender, EventArgs e)
{
using (var db = new PostgreContext())
{
var func = new Funcionario()
{
Nome = txtNome.Text,
Email = txtEmail.Text,
CargoId = int.Parse(cboCargos.SelectedValue.ToString())
};
if (txtId.Text == String.Empty)
{
db.Funcionarios.Add(func);
}
else
{
func.Id = int.Parse(txtId.Text);
db.Entry(func).State = EntityState.Modified;
}
db.SaveChanges();
MessageBox.Show("Funcionário salvo com sucesso.");
Close();
}
}
/*
* Stores some supermarkets data return by google maps places api
*/
private int SaveSupermarkets(List <Supermarket> supermarkets)
{
int rowsAffected = 0;
using (PostgreContext context = new PostgreContext())
{
List <Shop> shopsToStore = new List <Shop>();
foreach (Supermarket supermarket in supermarkets)
{
bool supermarketAlreadyExists = context.Shop.Where(x => x.Id.Equals(supermarket.id)).Count() != 0;
if (!supermarketAlreadyExists)
{
Shop shop = new Shop()
{
Id = supermarket.id,
Nom = supermarket.name,
Address = supermarket.address,
City = "",
Latitude = supermarket.location.Lat,
Longitude = supermarket.location.Lng
};
shopsToStore.Add(shop);
}
}
if (shopsToStore.Count != 0)
{
context.AddRange(shopsToStore);
rowsAffected = context.SaveChanges();
}
}
return(rowsAffected);
}
private void CarregarCargo(int id)
{
using (var db = new PostgreContext())
{
var cargo = db.Cargos.FirstOrDefault(c => c.Id == id);
txtId.Text = cargo.Id.ToString();
txtDescricao.Text = cargo.Descricao;
}
}
/*
* Checks database connectivity
*/
public bool CheckDatabaseConnection()
{
bool isThereConnection = false;
using (PostgreContext context = new PostgreContext())
{
isThereConnection = 0 < context.GroupTypes.Count();
}
return(isThereConnection);
}
private void ListarTodos()
{
using (var db = new PostgreContext())
{
var cargos = (from c in db.Cargos
orderby c.Id
select new { Id = c.Id, Descricao = c.Descricao }).ToList();
dgvCargos.DataSource = cargos;
}
}
private void CarregarFuncionario(int id)
{
using (var db = new PostgreContext())
{
var func = db.Funcionarios.FirstOrDefault(c => c.Id == id);
txtId.Text = func.Id.ToString();
txtNome.Text = func.Nome;
txtEmail.Text = func.Email;
cboCargos.SelectedValue = func.CargoId;
}
}
private static void PrintBooks()
{
using (var context = new PostgreContext())
{
var books = context.Book.ToList();
foreach (var book in books)
{
Console.WriteLine($" '{book.Title}' by {book.Author}");
}
}
}
private void ListarTodos(string buscar)
{
using (var db = new PostgreContext())
{
buscar = buscar.ToLower();
var cargos = (from c in db.Cargos
where c.Descricao.ToLower().Contains(buscar)
orderby c.Id
select new { Id = c.Id, Descricao = c.Descricao }).ToList();
dgvCargos.DataSource = cargos;
}
}
private void CarregarCargos()
{
using (var db = new PostgreContext())
{
cboCargos.DataSource = (from c in db.Cargos
orderby c.Id
select new {
Id = c.Id,
Descricao = c.Descricao
}).ToList();
cboCargos.DisplayMember = "Descricao";
cboCargos.ValueMember = "Id";
}
}
private static void InsertSampleData()
{
using (var context = new PostgreContext())
{
context.Book.Add(new Book {
Title = "Witcher", Author = "Andrzej Sapkowski"
});
context.Book.Add(new Book {
Title = "A Game of Thrones", Author = "George R.R. Martin"
});
context.Book.Add(new Book {
Title = "Inclusion", Author = "Andrzej W. Sawicki"
});
context.SaveChanges();
}
}
private void ListarTodos()
{
using (var db = new PostgreContext())
{
var funcionarios = (from f in db.Funcionarios
orderby f.Id
select new
{
Id = f.Id,
Nome = f.Nome,
Email = f.Email,
Cargo = f.Cargo.Descricao
}).ToList();
dgvFuncionarios.DataSource = funcionarios;
}
}
private void BtnExcluir_Click(object sender, EventArgs e)
{
var result = MessageBox.Show($"Deseja realmente excluir o cargo: {txtDescricao.Text}?", "Confirmação", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
using (var db = new PostgreContext())
{
int id = int.Parse(txtId.Text);
var cargo = db.Cargos.FirstOrDefault(c => c.Id == id);
db.Cargos.Remove(cargo);
db.SaveChanges();
MessageBox.Show("Cargo excluído com sucesso.");
Close();
}
}
}
private void ListarTodos(string buscar)
{
using (var db = new PostgreContext())
{
buscar = buscar.ToLower();
var funcionarios = (from f in db.Funcionarios
where (f.Nome.ToLower().Contains(buscar) ||
f.Email.ToLower().Contains(buscar) ||
f.Cargo.Descricao.ToLower().Contains(buscar))
orderby f.Id
select new
{
Id = f.Id,
Nome = f.Nome,
Email = f.Email,
Cargo = f.Cargo.Descricao
}).ToList();
dgvFuncionarios.DataSource = funcionarios;
}
}
private void BtnSalvar_Click(object sender, EventArgs e)
{
var cargo = new Cargo()
{
Descricao = txtDescricao.Text
};
using (var db = new PostgreContext())
{
if (txtId.Text == String.Empty)
{
db.Cargos.Add(cargo);
}
else
{
cargo.Id = int.Parse(txtId.Text);
db.Entry(cargo).State = EntityState.Modified;
}
db.SaveChanges();
}
MessageBox.Show("Cargo salvo com sucesso.");
Close();
}
/*
* Returns the basic goods data for a given supermarket
*/
public IEnumerable <SupermarketData> GetSupermarketDataById(string id)
{
List <SupermarketData> supermarketDataList = new List <SupermarketData>();
using (PostgreContext context = new PostgreContext())
{
IEnumerable <IGrouping <string, LastFourHours> > lastFourHours = context.LastFourHours.Where(x => x.Idshop.Equals(id)).ToList().GroupBy(x => x.Groupname);
lastFourHours.SelectMany(group => group);
foreach (IGrouping <string, LastFourHours> entry in lastFourHours)
{
SupermarketData supermarketData = new SupermarketData();
List <BasicGoodStatus> basicGoodStatuses = new List <BasicGoodStatus>();
string key = entry.Key;
foreach (LastFourHours item in entry)
{
BasicGoodStatus basicGoodStatus = new BasicGoodStatus()
{
timestamp = decimal.ToInt64(item.Unixtime ?? 0),
upvote = decimal.ToInt32(item.Positives ?? 0),
downvote = decimal.ToInt32(item.Negatives ?? 0)
};
basicGoodStatuses.Add(basicGoodStatus);
}
supermarketData.item = key;
supermarketData.timeline = basicGoodStatuses;
supermarketDataList.Add(supermarketData);
}
}
return(supermarketDataList);
}
public FlightReadRepository(PostgreContext context) : base(context, Flight.Table)
{
}
public PassengerReadRepository(PostgreContext context) : base(context, Passenger.Table)
=> m_Context = context ?? throw new ArgumentNullException(nameof(context));
public GetAllMoviesHandler(PostgreContext context)
{
_context = context;
}
public PostgreCardsRepository(PostgreContext context)
{
this.context = context;
}
public PostgreCollectionsRepository(PostgreContext context)
{
this.context = context;
}
public PassengerWriteRepository(PostgreContext context) : base(context, Passenger.Table)
{
}
public DeleteMovieHandler(PostgreContext context)
{
_context = context;
}
public TenantsController(PostgreContext context)
{
_context = context;
}
public PatchMovieHandler(PostgreContext context)
{
_context = context;
}
public IterationsController(PostgreContext context)
{
_context = context;
}
public GetMovieByIdHandler(PostgreContext context)
{
_context = context;
}
public UsersController(PostgreContext context)
{
_context = context;
}
public PostgreTrainingRepository(PostgreContext context)
{
this.context = context;
}
public WorkItemStatesController(PostgreContext context)
{
_context = context;
}
public PostgreTokensRepository(PostgreContext context)
{
this.context = context;
}
