private void dtgvPacket_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
int id = (int)dtgvPacket.Rows[e.RowIndex].Cells[0].Value;
CardtoPacketService cardtoPacketService = _context.CardtoPacketServices.Find(id);
SelectedData = cardtoPacketService;
txtBarcode.Text = cardtoPacketService.Card.Code;
txtName.Text = cardtoPacketService.Card.Registration.Client_Name;
txtSurname.Text = cardtoPacketService.Card.Registration.Client_Surname;
txtPacketPrice.Text = cardtoPacketService.Packet.Packet_Price.ToString();
txtServicePrice.Text = cardtoPacketService.Service.Service_Price.ToString();
cmbPacket.Text = cardtoPacketService.Packet.Packet_Name;
cmbService.Text = cardtoPacketService.Service.Service_Name;
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (CheckAll())
{
string Name = txtName.Text;
string Surname = txtSurname.Text;
string Barcode = txtBarcode.Text;
string Packet = cmbPacket.Text;
string Service = cmbService.Text;
string ServicePrice = txtServicePrice.Text;
string PacketPrice = txtPacketPrice.Text;
Registration registration = new Registration()
{
Client_Name = Name,
Client_Surname = Surname
};
_context.Registrations.Add(registration);
Card card = new Card()
{
Registration_Id = registration.Id,
Code = Barcode
};
Service service = _context.Services.Where(p => p.Service_Name == cmbService.Text).FirstOrDefault();
Packet packet = _context.Packets.Where(p => p.Packet_Name == cmbPacket.Text).FirstOrDefault();
if (packet != null)
{
CardtoPacketService cardtoPacketService = new CardtoPacketService()
{
Card_Id = _context.Cards.Where(c => c.Code == txtBarcode.Text).First().Id,
//Packet_Id = packet.Id,
//Service_Id = service.Id
Packet_Id = packet.Id,
Service_Id = null
};
Income income = new Income()
{
Client_Id = _context.Cards.Where(c => c.Code == txtBarcode.Text).First().Registration.Id,
IncomeMonth = DateTime.Now,
ClientIncomes = (int)packet.Packet_Price
};
_context.Incomes.Add(income);
_context.CardtoPacketServices.Add(cardtoPacketService);
}
if (service != null)
{
CardtoPacketService cardtoPacketService = new CardtoPacketService()
{
Card_Id = _context.Cards.Where(c => c.Code == txtBarcode.Text).First().Id,
//Packet_Id = packet.Id,
//Service_Id = service.Id
Packet_Id = null,
Service_Id = service.Id
};
Income income = new Income()
{
Client_Id = _context.Cards.Where(c => c.Code == txtBarcode.Text).First().Registration.Id,
IncomeMonth = DateTime.Now,
ClientIncomes = (int)service.Service_Price
};
_context.Incomes.Add(income);
_context.CardtoPacketServices.Add(cardtoPacketService);
}
_context.SaveChanges();
FillDataGridView();
ClearAllField();
}
}
