public void display_data() { var context = new db_daycareContextEntities(); var data = from a in context.Daycares where a.dayare_status == 1 join e in context.Employees on a.employee_id equals e.employee_id into tmp3 from emp in tmp3.DefaultIfEmpty() join p in context.Pets on a.pet_id equals p.pet_id into tmp from pet in tmp.DefaultIfEmpty() join pt in context.Pet_Types on pet.pet_type_id equals pt.pet_type_id into tmp1 from type in tmp1.DefaultIfEmpty() join o in context.Customers on pet.customer_id equals o.customer_id into tmp2 from own in tmp2.DefaultIfEmpty() select new { ID = a.daycare_id, Pet = pet.pet_name, Jenis = type.pet_type_name, Owner = own.customer_name, Start = a.daycare_date, Pickup = a.daycare_pickup_date, Pegawai = emp.employee_name }; dataGridView1.DataSource = data.ToList(); }
private void EditPetForm_Load(object sender, EventArgs e) { db_daycareContextEntities context = new db_daycareContextEntities(); List <Pet_Types> petTypes = (from t in context.Pet_Types select t).ToList(); petTypes.Insert(0, new Pet_Types { pet_type_id = 0, pet_type_name = "Please select" }); typeComboBox.DataSource = petTypes; typeComboBox.ValueMember = "pet_type_id"; typeComboBox.DisplayMember = "pet_type_name"; List <Customers> customer = (from c in context.Customers select c).ToList(); customer.Insert(0, new Customers { customer_id = 0, customer_name = "Please select" }); ownerComboBox.DataSource = customer; ownerComboBox.ValueMember = "customer_id"; ownerComboBox.DisplayMember = "customer_name"; }
private void buttonSearch_Click(object sender, EventArgs e) { var context = new db_daycareContextEntities(); int idDaycare = Convert.ToInt32(textBoxSearch.Text); var query = (from a in context.Daycares where a.daycare_id == idDaycare select a); var daycare = query.FirstOrDefault <Daycares>(); if (daycare != null) { var pet = context.Pets.Find(daycare.pet_id); var petType = context.Pet_Types.Find(pet.pet_type_id); var owner = context.Customers.Find(pet.customer_id); var dateDaycare = Convert.ToDateTime(daycare.daycare_date); var datePickup = Convert.ToDateTime(daycare.daycare_pickup_date); labelPetName.Text = pet.pet_name; labelPetType.Text = petType.pet_type_name; labelOwner.Text = owner.customer_name; labelStart.Text = dateDaycare.ToString("yyyy-MM-dd"); labelEnd.Text = datePickup.ToString("yyyy-MM-dd"); panelForm.Show(); } else { MessageBox.Show("Maaf data yang anda cari tidak ada!"); } }
private void DaycareForm_Load(object sender, EventArgs e) { db_daycareContextEntities context = new db_daycareContextEntities(); List <Employees> employees = (from t in context.Employees select t).ToList(); employees.Insert(0, new Employees { employee_id = 0, employee_name = "Please select" }); comboBoxEmployee.DataSource = employees; comboBoxEmployee.ValueMember = "employee_id"; comboBoxEmployee.DisplayMember = "employee_name"; List <Pets> pets = (from c in context.Pets select c).ToList(); pets.Insert(0, new Pets { pet_id = 0, pet_name = "Please select" }); comboBoxPet.DataSource = pets; comboBoxPet.ValueMember = "pet_id"; comboBoxPet.DisplayMember = "pet_name"; }
private void countCharger(object sender, EventArgs e) { var context = new db_daycareContextEntities(); int idDaycare = int.Parse(textBoxSearch.Text); var daycare = context.Daycares.Find(idDaycare); var pickUpDate = Convert.ToDateTime(daycare.daycare_pickup_date); int dateTotal = (dateTimePickerPickupCharge.Value - pickUpDate).Days; int chargeCost = dateTotal * 50000; labelCost.Text = chargeCost.ToString(); }
private void countCost(object sender, EventArgs e) { db_daycareContextEntities context = new db_daycareContextEntities(); int idPet = int.Parse(comboBoxPet.SelectedValue.ToString()); var pet = context.Pets.Find(idPet); var petType = context.Pet_Types.Find(pet.pet_type_id); int totalDate = (dateTimePickerPickup.Value - dateTimePickerDaycare.Value).Days; int totalCost = totalDate * Convert.ToInt32(petType.pet_type_cost); labelCost.Text = totalCost.ToString(); }
public void display_data() { var context = new db_daycareContextEntities(); var data = from a in context.Customers select new { ID = a.customer_id, Nama = a.customer_name, Alamat = a.customer_address, NoTelp = a.customer_phone }; dataGridView1.DataSource = data.ToList(); }
private void buttonDelete_Click(object sender, EventArgs e) { string nama = textBoxSearch.Text; var contex = new db_daycareContextEntities(); var cust = (from a in contex.Customers where a.customer_name == nama select a).Single(); contex.Customers.Remove(cust); contex.SaveChanges(); MessageBox.Show("Data telah berhasil dihapus."); CustomerForm f = new CustomerForm(); f.Show(); this.Hide(); }
private void addCustomerButton_Click(object sender, EventArgs e) { var contex = new db_daycareContextEntities(); var cust = new Customers(); cust.customer_name = nameTextBox.Text; cust.customer_address = addressTextBox.Text; cust.customer_phone = phoneTextBox.Text; contex.Customers.Add(cust); contex.SaveChanges(); MessageBox.Show("Tambah data owner pet berhasil!!"); CustomerForm f = new CustomerForm(); f.Show(); this.Hide(); }
private void addEmployeeButton_Click(object sender, EventArgs e) { var contex = new db_daycareContextEntities(); var emp = new Employees(); emp.employee_name = nameTextBox.Text; emp.employee_address = addressTextBox.Text; emp.employee_phone = phoneTextBox.Text; contex.Employees.Add(emp); contex.SaveChanges(); MessageBox.Show("Tambah data pegawai berhasil!!"); EmployeeForm f = new EmployeeForm(); f.Show(); this.Hide(); }
private void buttonUpdate_Click(object sender, EventArgs e) { var context = new db_daycareContextEntities(); var pet = (from a in context.Pets where a.pet_name == textBoxSearch.Text select a).Single(); pet.pet_name = nameTextBox.Text; pet.customer_id = int.Parse(ownerComboBox.SelectedValue.ToString()); pet.pet_type_id = int.Parse(typeComboBox.SelectedValue.ToString()); context.SaveChanges(); MessageBox.Show("Data telah berhasil diupdate."); PetForm f = new PetForm(); f.Show(); this.Hide(); }
public void display_data() { var context = new db_daycareContextEntities(); var data = from a in context.Pets join customer in context.Customers on a.customer_id equals customer.customer_id into tmp from cust in tmp.DefaultIfEmpty() join petType in context.Pet_Types on a.pet_type_id equals petType.pet_type_id into tmp1 from type in tmp1.DefaultIfEmpty() select new { ID = a.pet_id, Nama = a.pet_name, Jenis = type.pet_type_name, Owner = cust.customer_name }; dataGridView1.DataSource = data.ToList(); }
private void buttonUpdate_Click(object sender, EventArgs e) { var context = new db_daycareContextEntities(); var cust = (from a in context.Customers where a.customer_name == textBoxSearch.Text select a).Single(); cust.customer_name = nameTextBox.Text; cust.customer_address = addressTextBox.Text; cust.customer_phone = phoneTextBox.Text; context.SaveChanges(); MessageBox.Show("Data telah berhasil diupdate."); CustomerForm f = new CustomerForm(); f.Show(); this.Hide(); }
private void buttonUpdate_Click(object sender, EventArgs e) { var context = new db_daycareContextEntities(); var emp = (from a in context.Employees where a.employee_name == textBoxSearch.Text select a).Single(); emp.employee_name = nameTextBox.Text; emp.employee_address = addressTextBox.Text; emp.employee_phone = phoneTextBox.Text; context.SaveChanges(); MessageBox.Show("Data telah berhasil diupdate."); EmployeeForm f = new EmployeeForm(); f.Show(); this.Hide(); }
private void proccessButton_Click(object sender, EventArgs e) { db_daycareContextEntities context = new db_daycareContextEntities(); var daycare = new Daycares(); daycare.employee_id = int.Parse(comboBoxEmployee.SelectedValue.ToString()); daycare.pet_id = int.Parse(comboBoxPet.SelectedValue.ToString()); daycare.daycare_date = dateTimePickerDaycare.Value; daycare.daycare_pickup_date = dateTimePickerPickup.Value; daycare.daycare_cost = Convert.ToInt32(labelCost.Text); daycare.dayare_status = 1; context.Daycares.Add(daycare); context.SaveChanges(); SuccessForm f = new SuccessForm(); f.Show(); this.Hide(); }
private void buttonSearch_Click(object sender, EventArgs e) { var context = new db_daycareContextEntities(); var query = (from a in context.Pets where a.pet_name == textBoxSearch.Text select a); var pet = query.FirstOrDefault <Pets>(); if (pet != null) { nameTextBox.Text = pet.pet_name; ownerComboBox.SelectedValue = pet.customer_id; typeComboBox.SelectedValue = pet.pet_type_id; panelForm.Show(); } else { MessageBox.Show("Maaf data yang anda cari tidak ada!"); } }
private void buttonSearch_Click(object sender, EventArgs e) { var context = new db_daycareContextEntities(); var query = (from a in context.Customers where a.customer_name == textBoxSearch.Text select a); var cust = query.FirstOrDefault <Customers>(); if (cust != null) { nameTextBox.Text = cust.customer_name; addressTextBox.Text = cust.customer_address; phoneTextBox.Text = cust.customer_phone; panelForm.Show(); } else { MessageBox.Show("Maaf data yang anda cari tidak ada!"); } }
private void addPetButton_Click(object sender, EventArgs e) { db_daycareContextEntities context = new db_daycareContextEntities(); var pet = new Pets(); pet.pet_name = nameTextBox.Text; //pet.customer_id = (int)ownerComboBox.SelectedIndex; //pet.pet_type_id = (int)typeComboBox.SelectedIndex; pet.customer_id = int.Parse(ownerComboBox.SelectedValue.ToString()); pet.pet_type_id = int.Parse(typeComboBox.SelectedValue.ToString()); context.Pets.Add(pet); context.SaveChanges(); MessageBox.Show("Peliharaan berhasil ditambah!"); PetForm f = new PetForm(); f.Show(); this.Hide(); }
private void buttonPickup_Click(object sender, EventArgs e) { var context = new db_daycareContextEntities(); var pickup = new Pickups(); pickup.daycare_id = int.Parse(textBoxSearch.Text); pickup.pickup_date = dateTimePickerPickupCharge.Value; pickup.pickup_charge = int.Parse(labelCost.Text); context.Pickups.Add(pickup); int daycareId = int.Parse(textBoxSearch.Text); var daycare = (from a in context.Daycares where a.daycare_id == daycareId select a).Single(); daycare.dayare_status = 0; context.SaveChanges(); SuccessForm f = new SuccessForm(); f.Show(); this.Hide(); }