private void prev_record() { rpsDataContext dbcon = new rpsDataContext(); Bill_Table bill = new Bill_Table(); var bills = from q in dbcon.Bill_Tables where q.flat == login.user select new { //q.Bill_Date, q.House_Rent, q.Electricity_Bill, q.Water_Bill, q.Gas_Bill, q.Service_Charge }; if (bills.Sum(x => x.House_Rent) == 0 && bills.Sum(x => x.Electricity_Bill) == 0 && bills.Sum(x => x.Water_Bill) == 0 && bills.Sum(x => x.Gas_Bill) == 0 && bills.Sum(x => x.Service_Charge) == 0) { pictureBox3.Image = Properties.Resources.check; } else { pictureBox3.Image = Properties.Resources.caution; } }
private void load_bill() { rpsDataContext dbcon = new rpsDataContext(); string flat_search; if (login.user != "owner") { flat_search = login.user; } else { flat_search = flat.flatselected; } Bill_Table bill = new Bill_Table(); var query = from q in dbcon.Bill_Tables where q.flat == flat_search select q; var curr_bill = query.OrderByDescending(x => x.Bill_Date).First(); if (curr_bill != null) { richTextBox1.Text = curr_bill.House_Rent.ToString(); richTextBox2.Text = curr_bill.Electricity_Bill.ToString(); richTextBox3.Text = curr_bill.Water_Bill.ToString(); richTextBox4.Text = curr_bill.Gas_Bill.ToString(); richTextBox5.Text = curr_bill.Service_Charge.ToString(); } }
private void flat2_status() { rpsDataContext dbcon = new rpsDataContext(); Bill_Table bill = new Bill_Table(); var query = from q in dbcon.Bill_Tables where q.flat == label3.Text select new { //q.Bill_Date, q.House_Rent, q.Electricity_Bill, q.Water_Bill, q.Gas_Bill, q.Service_Charge }; if (query.Sum(x => x.House_Rent) == 0 && query.Sum(x => x.Electricity_Bill) == 0 && query.Sum(x => x.Water_Bill) == 0 && query.Sum(x => x.Gas_Bill) == 0 && query.Sum(x => x.Service_Charge) == 0) { pictureBox4.Image = Properties.Resources.check; label5.Text = "paid"; } else { label5.Text = "due"; pictureBox4.Image = Properties.Resources.caution; } }
private void button2_Click(object sender, EventArgs e) { rpsDataContext dbcon = new rpsDataContext(); //int id = Int32.Parse(comboBox1.SelectedValue.ToString()); Bill_Table bill = dbcon.Bill_Tables.SingleOrDefault(x => x.flat == comboBox1.SelectedItem.ToString() && x.Bill_Date == dateTimePicker1.Value); if (bill != null) { richTextBox1.Text = Convert.ToString(bill.House_Rent); richTextBox2.Text = Convert.ToString(bill.Electricity_Bill); richTextBox3.Text = Convert.ToString(bill.Water_Bill); richTextBox4.Text = Convert.ToString(bill.Gas_Bill); richTextBox5.Text = Convert.ToString(bill.Service_Charge); } else { MessageBox.Show("Bill not found"); } }
private void ConfirmButton_Click(object sender, EventArgs e) { try { rpsDataContext dbcon = new rpsDataContext(); if (FirstNameTextBox.Text == null || FatherFirstNameTextBox.Text == null || MotherFirstNameTextBox == null || ContactNoTextbox.Text == null || EmailTextbox.Text == null || PAddressTextBox.Text == null || OffAddressTextBox == null || comboBox1.Text == null || OfficeContNoTextBox == null || RentedFlatComboBox.Text == null || renterImage.Image == null) { MessageBox.Show("Please fill up all the feilds!!!"); } else if (textBox1.Text.Length < 6) { MessageBox.Show("Select a password with at least 6 characters !!"); } else { //renter RENTER r = new RENTER(); r.r_name = FirstNameTextBox.Text + " " + LastNameTextBox.Text; r.rf_name = FatherFirstNameTextBox.Text + " " + FatherLastNameTextBox.Text; r.rm_name = MotherFirstNameTextBox.Text + " " + MotherLastNameTextBox.Text; r.r_contact = ContactNoTextbox.Text; r.renter_email = EmailTextbox.Text; r.pt_address = PAddressTextBox.Text; r.r_off_add = OffAddressTextBox.Text; r.r_occupation = textBox2.Text; r.rent_date = dateTimePicker1.Value; r.renter_family_mamber = comboBox1.Text; r.r_off_contact = OfficeContNoTextBox.Text; r.rented_flat = RentedFlatComboBox.Text; byte[] img = null; FileStream fs = new FileStream(imgLoc, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fs); img = br.ReadBytes((int)fs.Length); r.renter_image = img; //login_table login l = new login(); l.user_id = RentedFlatComboBox.Text; l.password = textBox1.Text; //deafult bill Bill_Table bill = new Bill_Table(); bill.flat = RentedFlatComboBox.Text; bill.House_Rent = 0; bill.Electricity_Bill = 0; bill.Water_Bill = 0; bill.Gas_Bill = 0; bill.Service_Charge = 0; dbcon.logins.InsertOnSubmit(l); dbcon.RENTERs.InsertOnSubmit(r); dbcon.Bill_Tables.InsertOnSubmit(bill); dbcon.SubmitChanges(); MessageBox.Show("Congratulations!! You may login now"); this.Hide(); new login().Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
partial void DeleteBill_Table(Bill_Table instance);
partial void UpdateBill_Table(Bill_Table instance);
partial void InsertBill_Table(Bill_Table instance);
private void button1_Click(object sender, EventArgs e) { try { rpsDataContext dbcon = new rpsDataContext(); if (this.Text == "Update_bill") { //rpsDataContext dbcon = new rpsDataContext(); //int id = Int32.Parse(comboBox1.SelectedValue.ToString()); Bill_Table bill = dbcon.Bill_Tables.SingleOrDefault(x => x.flat == comboBox1.SelectedItem.ToString() && x.Bill_Date == dateTimePicker1.Value); if (bill != null) { bill.House_Rent = Convert.ToDouble(richTextBox1.Text); bill.Electricity_Bill = Convert.ToDouble(richTextBox2.Text); bill.Water_Bill = Convert.ToDouble(richTextBox3.Text); bill.Gas_Bill = Convert.ToDouble(richTextBox4.Text); bill.Service_Charge = Convert.ToDouble(richTextBox5.Text); dbcon.SubmitChanges(); MessageBox.Show("Bill Updated successfully"); this.Dispose(); } } else { // Bill_Table bill = dbcon.Bill_Tables.SingleOrDefault(x => x.Bill_Date == dateTimePicker1.Value); if (comboBox1.Text == null || dateTimePicker1.Text == null || richTextBox1.Text == null || richTextBox2.Text == null || richTextBox3.Text == null || richTextBox4.Text == null || richTextBox5.Text == null) { MessageBox.Show("Please fill up all feilds with valid data"); } else if (dbcon.Bill_Tables.Any(x => x.flat == comboBox1.SelectedItem.ToString() && x.Bill_Date == dateTimePicker1.Value) == true) { MessageBox.Show("A bill aready exists for this date in this flat"); } else { Bill_Table bill = new Bill_Table(); bill.flat = comboBox1.SelectedItem.ToString(); bill.Bill_Date = dateTimePicker1.Value; bill.House_Rent = Convert.ToDouble(richTextBox1.Text); bill.Electricity_Bill = Convert.ToDouble(richTextBox2.Text); bill.Water_Bill = Convert.ToDouble(richTextBox3.Text); bill.Gas_Bill = Convert.ToDouble(richTextBox4.Text); bill.Service_Charge = Convert.ToDouble(richTextBox5.Text); dbcon.Bill_Tables.InsertOnSubmit(bill); dbcon.SubmitChanges(); MessageBox.Show("new bill created for " + comboBox1.SelectedItem.ToString()); this.Dispose(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }