private void button2_Click(object sender, EventArgs e) { var ans = (from prog in dc.programs where prog.name == progNameTxt.Text select prog).FirstOrDefault(); if (ans != null) { MessageBox.Show("התוכנית כבר קיימת במערכת"); } else { program pr = new program(); //create new program record pr.name = progNameTxt.Text; pr.start_date = startDatedt.Value; pr.end_date = endDatedt.Value; pr.frequency = frequencyStr.Text; pr.comments = commentsStr.Text; pr.program_details = detailsStr.Text; pr.program_type = programTypeStr.Text; dc.programs.InsertOnSubmit(pr); dc.SubmitChanges(); } }
private void saveButton_Click(object sender, EventArgs e) { Customer customerId = (from c in dc.Customers // get the record from the db where c.Id == Program.custId select c).FirstOrDefault(); if (customerId != null) { customerId.independency = indepependency.Text;//get values no need to check if null customerId.mobility = mobility.Text; customerId.active_inclub = activeClub.Text; customerId.day_care = dayCenter.Text; if (entitledDisctrue.Checked) { customerId.entitled_todiscount = true; } else if (entitledDiscfalse.Checked) { customerId.entitled_todiscount = false; } if (holocSurvtrue.Checked) { customerId.holocaust_survaviour = true; } else if (holocSurvfalse.Checked) { customerId.holocaust_survaviour = false; } if (nursLawtrue.Checked) { customerId.nursing_law = true; } else if (nursLawfalse.Checked) { customerId.nursing_law = false; } dc.SubmitChanges(); if (foreignWorkerYes.Checked) { customerId.foreign_worker = true; } else if (foreignWorkerYes.Checked) { customerId.foreign_worker = false; } } }
//dataGridView1_CellContentClick private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { var senderGrid = (DataGridView)sender; if (e.ColumnIndex == senderGrid.Columns["AddProgram"].Index && e.RowIndex >= 0) { int index = Convert.ToInt32(e.RowIndex); int programNum = int.Parse(dataGridView1.Rows[index].Cells[0].Value.ToString()); var ans = (from custprog in dc.customer_programs where custprog.customer_id == Program.custId && custprog.program_id == programNum select custprog).FirstOrDefault(); if (ans != null) { MessageBox.Show("מקבל השירות כבר שויך לתוכנית"); } else { MessageBox.Show(programNum.ToString()); customer_program cp = new customer_program(); //create new customer program record cp.customer_id = Program.custId; cp.program_id = programNum; cp.start_date = DateTime.Now; cp.end_date = DateTime.Parse(dataGridView1.Rows[index].Cells[5].Value.ToString()); dc.customer_programs.InsertOnSubmit(cp); dc.SubmitChanges(); } } if (e.ColumnIndex == senderGrid.Columns["MoreInfo"].Index && e.RowIndex >= 0) { int index = Convert.ToInt32(e.RowIndex); int programNum = int.Parse(dataGridView1.Rows[index].Cells[0].Value.ToString()); SearchResultsProgram f = new SearchResultsProgram(); f.Show(); this.Hide(); } }
private void button2_Click(object sender, EventArgs e) { var ans = (from volunlist in dc.volunteers where volunlist.first_name == strFName.Text && volunlist.last_name == strLName.Text select volunlist).FirstOrDefault(); if (ans != null) { MessageBox.Show("המתנדב כבר רשום במערכת"); } else { volunteer vol = new volunteer(); //create new volunteer record vol.first_name = strFName.Text; vol.last_name = strLName.Text; vol.email_address = emailAdd.Text; vol.comments = strComments.Text; vol.start_date = startDate.Value; vol.end_date = endDate.Value; dc.volunteers.InsertOnSubmit(vol); dc.SubmitChanges(); } }
private void button2_Click(object sender, EventArgs e) { var customerId = (from c in dc.Customers // get the record from the db where c.Id == Program.custId select c).FirstOrDefault(); if (customerId != null) { if (specialPName_str.Text == "" || specialPDetails_str.Text == "" || specialPType_str.Text == "") { MessageBox.Show("לא מולאו כל שדות חובה"); } else { customer_sp_act spactivity = new customer_sp_act(); //create new customer special activity record spactivity.activity_name = specialPName_str.Text; spactivity.activity_details = specialPDetails_str.Text; spactivity.activity_type = specialPType_str.Text; spactivity.activity_status = "פעיל"; spactivity.customer_id = Program.custId; if (qualificationTrue.Checked) { spactivity.qualification = true; } else if (qualificationfalse.Checked) { spactivity.qualification = false; } dc.customer_sp_acts.InsertOnSubmit(spactivity); dc.SubmitChanges(); } } }
private void button2_Click(object sender, EventArgs e) { var customerId = (from c in dc.Customers // get the record from the db where c.Id == Program.custId select c).FirstOrDefault(); if (customerId != null) { contact cont = new contact(); //create new customer contact record of family type cont.first_name = strFName.Text; cont.last_name = strLName.Text; dc.contacts.InsertOnSubmit(cont); dc.SubmitChanges(); phone ph = new phone(); //create new phone record if (phoneNumM.Text != "" && areaCodeM.Text != "") { ph.phone_type = "נייד"; ph.area_code = areaCodeM.Text; ph.phone_num = phoneNumM.Text; dc.phones.InsertOnSubmit(ph); // dc.SubmitChanges(); } dc.SubmitChanges(); if (ph != null) { contact_phone cph = new contact_phone(); cph.contact_id = cont.ID; cph.phone_id = ph.ID; cph.status = "פעיל"; cph.type = ph.phone_type; dc.contact_phones.InsertOnSubmit(cph); } dc.SubmitChanges(); wh_address adr = new wh_address(); // new address record adr.city_name = cityName.Text; if (streetName.Text != "") { adr.street_name = streetName.Text; } if (houseNum.Text != "") { adr.house_num = int.Parse(houseNum.Text); } if (apartNum.Text != "") { adr.appartment_num = int.Parse(apartNum.Text); } if (postCode.Text != "") { adr.zip_code = postCode.Text; } dc.wh_addresses.InsertOnSubmit(adr); dc.SubmitChanges(); contact_address contaddr = new contact_address();//new contact address record contaddr.contact_id = cont.ID; contaddr.address_id = adr.ID; contaddr.status = "פעיל"; dc.contact_addresses.InsertOnSubmit(contaddr); dc.SubmitChanges(); customer_contact custcont = new customer_contact(); //add new contact to customer custcont.customer_id = Program.custId; custcont.contact_id = cont.ID; custcont.type = "מטפל ראשי"; custcont.status = "פעיל"; dc.customer_contacts.InsertOnSubmit(custcont); dc.SubmitChanges(); } }
private void InsertMedicalHistory_Click(object sender, EventArgs e) { var customerId = (from c in dc.Customers // get the record from the db where c.Id == Program.custId select c).FirstOrDefault(); if (customerId != null) { if (Hearing_chkbox.Checked) { customer_medical_history custmed = new customer_medical_history(); //create new customer medical history record custmed.desease = "שמיעה"; custmed.severity = Severity_cbBox1.Text; custmed.comments = comments1.Text; custmed.customer_id = Program.custId; dc.customer_medical_histories.InsertOnSubmit(custmed); dc.SubmitChanges(); } if (Chronic__chkbox.Checked) { customer_medical_history custmed = new customer_medical_history(); //create new customer medical history record custmed.desease = "מחלה כרונית"; custmed.severity = Severity_cbBox2.Text; custmed.comments = comments2.Text; custmed.customer_id = Program.custId; dc.customer_medical_histories.InsertOnSubmit(custmed); dc.SubmitChanges(); } if (Vision__chkbox.Checked) { customer_medical_history custmed = new customer_medical_history(); custmed.desease = "ראיה"; custmed.severity = Severity_cbBox3.Text; custmed.comments = comments3.Text; custmed.customer_id = Program.custId; dc.customer_medical_histories.InsertOnSubmit(custmed); dc.SubmitChanges(); } if (Demensia__chkbox.Checked) { customer_medical_history custmed = new customer_medical_history(); custmed.desease = "דמנציה"; custmed.severity = Severity_cbBox4.Text; custmed.comments = comments4.Text; custmed.customer_id = Program.custId; dc.customer_medical_histories.InsertOnSubmit(custmed); dc.SubmitChanges(); } if (Parkinson__chkbox.Checked) { customer_medical_history custmed = new customer_medical_history(); custmed.desease = "פרקינסון"; custmed.severity = Severity_cbBox5.Text; custmed.comments = comments5.Text; custmed.customer_id = Program.custId; dc.customer_medical_histories.InsertOnSubmit(custmed); dc.SubmitChanges(); } if (Other__chkbox.Checked) { if (diffDeseaseNamestr.Text == "") { diffDeseaseNamestr.BackColor = Color.Red; MessageBox.Show("נא למלא את שם המחלה"); } else { customer_medical_history custmed = new customer_medical_history(); custmed.desease = diffDeseaseNamestr.Text; custmed.severity = Severity_cbBox6.Text; custmed.comments = comments6.Text; custmed.customer_id = Program.custId; dc.customer_medical_histories.InsertOnSubmit(custmed); dc.SubmitChanges(); } } AddCustomerPage2 f = new AddCustomerPage2(); f.Show(); this.Hide(); } }
private void saveButton_Click(object sender, EventArgs e) { if (strId.Text == "" || strFName.Text == "" || strLName.Text == "" || dateofBirth.Value == DateTime.Now || (!checkMale.Checked && !checkFemale.Checked) || ((phoneNumH.Text == "" || areaCodeH.Text == "") && (phoneNumM.Text == "" || areaCodeM.Text == ""))) { MessageBox.Show("לא מולאו כל שדות החובה"); if (strId.Text == "") { strId.BackColor = Color.Red; // color red if id is null } else { strId.BackColor = Color.White; } if (strFName.Text == "") { strFName.BackColor = Color.Red;// color red if first name is null } else { strFName.BackColor = Color.White; } if (strLName.Text == "") { strLName.BackColor = Color.Red;// color red if last name is null } else { strLName.BackColor = Color.White; } if (dateofBirth.Value == DateTime.Now) { dateofBirth.BackColor = Color.Red; } else { dateofBirth.BackColor = Color.White; } if (!checkMale.Checked && !checkFemale.Checked) { checkMale.BackColor = Color.Red; checkFemale.BackColor = Color.Red; } else { checkMale.BackColor = Color.White; checkFemale.BackColor = Color.White; } } else { var ans = (from cust in dc.Customers where cust.Id == strId.Text select cust).FirstOrDefault(); if (ans != null) { MessageBox.Show("מקבל שירות כבר קיים במערכת"); } else { Customer cust = new Customer(); //create new customer record cust.Id = strId.Text; cust.first_name = strFName.Text; cust.last_name = strLName.Text; cust.birthdate = dateofBirth.Value; if (checkMale.Checked) { cust.gender = "זכר"; } else { cust.gender = "נקבה"; } cust.marital_status = maritalStatus.Text; cust.comments = strComments.Text; cust.email_address = emailAdd.Text; cust.status_cd = "פעיל"; dc.Customers.InsertOnSubmit(cust); // dc.SubmitChanges(); phone ph = new phone(); //create new phone record if (phoneNumH.Text != "" && areaCodeH.Text != "") { ph.phone_type = "בית"; ph.area_code = areaCodeH.Text; ph.phone_num = phoneNumH.Text; dc.phones.InsertOnSubmit(ph); // dc.SubmitChanges(); } phone ph1 = new phone(); //create new phone record if (phoneNumM.Text != "" && areaCodeM.Text != "") { ph1.phone_type = "נייד"; ph1.area_code = areaCodeM.Text; ph1.phone_num = phoneNumM.Text; dc.phones.InsertOnSubmit(ph1); // dc.SubmitChanges(); } dc.SubmitChanges(); if (ph != null) { customer_phone cph = new customer_phone(); cph.customer_id = strId.Text; cph.phone_id = ph.ID; cph.status = "פעיל"; cph.type = ph.phone_type; dc.customer_phones.InsertOnSubmit(cph); } if (ph1 != null) { customer_phone cph1 = new customer_phone(); cph1.customer_id = strId.Text; cph1.phone_id = ph1.ID; cph1.status = "פעיל"; cph1.type = ph1.phone_type; dc.customer_phones.InsertOnSubmit(cph1); } dc.SubmitChanges(); wh_address adr = new wh_address(); // new address record adr.city_name = cityName.Text; if (streetName.Text != "") { adr.street_name = streetName.Text; } if (houseNum.Text != "") { adr.house_num = int.Parse(houseNum.Text); } if (apartNum.Text != "") { adr.appartment_num = int.Parse(apartNum.Text); } if (neighbName.Text != "") { adr.neighborhood = neighbName.Text; } if (postCode.Text != "") { adr.zip_code = postCode.Text; } dc.wh_addresses.InsertOnSubmit(adr); dc.SubmitChanges(); customer_address custaddr = new customer_address();//new customer address record custaddr.customer_id = strId.Text; custaddr.address_id = adr.ID; custaddr.status = "פעיל"; dc.customer_addresses.InsertOnSubmit(custaddr); dc.SubmitChanges(); nextButton.Enabled = true; } } }