private void btn_rooms_save_Click(object sender, EventArgs e) { db = new PreSchoolEntities1(); if (gunaLineTextBox1.Text == gunaLineTextBox2.Text && !String.IsNullOrWhiteSpace(gunaLineTextBox1.Text)) { db = new PreSchoolEntities1(); int userId = userClass.getUserId(); var user = db.tbl_user.Where(x => x.id == userId).FirstOrDefault(); user.password = gunaLineTextBox1.Text; userClass.setUserPassword(user.password); db.SaveChangesAsync(); MessageBox.Show("Password Changed Successfully"); gunaLineTextBox1.Text = null; gunaLineTextBox2.Text = null; } else if ((gunaLineTextBox1.Text != gunaLineTextBox2.Text)) { MessageBox.Show("Password Do Not Match"); } else if (String.IsNullOrWhiteSpace(gunaLineTextBox1.Text)) { MessageBox.Show("Please Enter Something At First"); } }
private void btn_rooms_save_Click(object sender, EventArgs e) { if (gbSocialId > 0) { db = new PreSchoolEntities1(); var sociogistData = db.tbl_sociologist.Where(items => items.id == gbSocialId).FirstOrDefault(); var childId = db.tbl_child_info.Where(items => items.child_fullname == combo_sociallogist_child_name.Text) .Select(a => a.id) .FirstOrDefault(); var roomId = db.tbl_room_name .Where(items => items.room_name == combo_sociallogist_room_name.Text) .Select(a => a.id) .FirstOrDefault(); sociogistData.id_user_update = userClass.getUserId(); sociogistData.datetime_update = DateTime.Now; sociogistData.note = not_sociallogist.Text; sociogistData.id_room_name = roomId; sociogistData.id_child = childId; db.SaveChangesAsync(); view(); clear(); } else { db = new PreSchoolEntities1(); var childId = db.tbl_child_info.Where(items => items.child_fullname == combo_sociallogist_child_name.Text) .Select(a => a.id) .FirstOrDefault(); var roomId = db.tbl_room_name .Where(items => items.room_name == combo_sociallogist_room_name.Text) .Select(a => a.id) .FirstOrDefault(); var newSocial = new tbl_sociologist() { id_user_save = userClass.getUserId(), id_child = childId, note = not_sociallogist.Text, datetime_save = DateTime.Now, id_room_name = roomId }; db.tbl_sociologist.Add(newSocial); db.SaveChangesAsync(); view(); } }
private void btn_teacher_save_Click(object sender, EventArgs e) { db = new PreSchoolEntities1(); var roomId = db.tbl_room_name .Where(items => items.room_name == combo_teacher_room_name.Text) .Select(a => a.id) .FirstOrDefault(); var newActivity = new tbl_subject_activity() { subject = txt_subject_subjectName.Text, date = gunaDateTimePicker1.Value, note = not_teacher_subject.Text, datetime_save = DateTime.Now, id_user_save = userClass.getUserId(), id_room_name = roomId }; db.tbl_subject_activity.Add(newActivity); db.SaveChangesAsync(); MessageBox.Show("New Activity Added"); }
private void btn_rooms_save_Click(object sender, EventArgs e) { try { if (gbActivityId > 0) { db = new PreSchoolEntities1(); var activity = db.tbl_subject_activity.Where(item => item.id == gbActivityId).First(); var roomId = db.tbl_room_name .Where(items => items.room_name == combo_teacher_room_name.Text) .Select(a => a.id) .FirstOrDefault(); activity.datetime_update = DateTime.Now; activity.id_user_update = userClass.getUserId(); activity.date = gunaDateTimePicker1.Value; activity.id_room_name = roomId; activity.subject = txt_subject_subjectName.Text; activity.note = not_teacher_subject.Text; db.SaveChangesAsync(); view(); clear(); } else if (gbActivityId == 0 && combo_teacher_room_name.SelectedIndex != -1 && !String.IsNullOrWhiteSpace(txt_subject_subjectName.Text) && !String.IsNullOrWhiteSpace(not_teacher_subject.Text)) { db = new PreSchoolEntities1(); var roomId = db.tbl_room_name .Where(items => items.room_name == combo_teacher_room_name.Text) .Select(a => a.id) .FirstOrDefault(); var newActivity = new tbl_subject_activity() { datetime_save = DateTime.Now, id_user_save = userClass.getUserId(), id_room_name = roomId, date = gunaDateTimePicker1.Value, subject = txt_subject_subjectName.Text, note = not_teacher_subject.Text, }; db.tbl_subject_activity.Add(newActivity); db.SaveChangesAsync(); view(); clear(); } else { MessageBox.Show("Please Select Some Data To Edit Or Add New Data"); } } catch (Exception) { MessageBox.Show("Error Adding New Subject Activity"); } }
private void btn_rooms_save_Click(object sender, EventArgs e) { try { if (gbRoomId > 0) { db = new PreSchoolEntities1(); var room = db.tbl_rooms.Where(item => item.id == gbRoomId).First(); var childId = db.tbl_child_info.Where(items => items.child_fullname == combo_rooms_child_name.Text) .Select(a => a.id) .FirstOrDefault(); var roomId = db.tbl_room_name .Where(items => items.room_name == combo_rooms_roomsName.Text) .Select(a => a.id) .FirstOrDefault(); room.datetime_update = DateTime.Now; room.id_user_update = userClass.getUserId(); room.id_child = childId; room.id_room_name = roomId; db.SaveChangesAsync(); view(); clear(); } else if (gbRoomId == 0 && combo_rooms_child_name.SelectedIndex != -1 && combo_rooms_roomsName.SelectedIndex != -1) { db = new PreSchoolEntities1(); var childId = db.tbl_child_info.Where(items => items.child_fullname == combo_rooms_child_name.Text) .Select(a => a.id) .FirstOrDefault(); var roomId = db.tbl_room_name .Where(items => items.room_name == combo_rooms_roomsName.Text) .Select(a => a.id) .FirstOrDefault(); var newRoom = new tbl_rooms() { id_user_save = userClass.getUserId(), id_child = childId, datetime_save = DateTime.Now, id_room_name = roomId }; db.tbl_rooms.Add(newRoom); db.SaveChangesAsync(); view(); clear(); } else { MessageBox.Show("Please Select Some Data To Edit Or Add New Data"); } } catch (Exception) { MessageBox.Show("Error Adding New Rooms Data"); } }
private void btn_addkids_save_Click(object sender, EventArgs e) { try { if (!String.IsNullOrWhiteSpace(gunaLineTextBox1.Text)) { var userId = int.Parse(gunaLineTextBox1.Text); var existingUser = db.tbl_child_info. Where(s => s.id == userId). First(); existingUser.child_fullname = CapitalizeFirst(txt_addkids_child_fullname.Text); existingUser.income_date = DateTime.Parse(DateTimePicker_In_come_date.Text); existingUser.id_user_update = userClass.getUserId(); existingUser.datetime_update = DateTime.Today;; existingUser.id_child_address = combo_addkids_child_address.Text; existingUser.child_birthday = DateTime.Parse(DateTimePicker_child_birth_date.Text); existingUser.father_fullname = CapitalizeFirst(txt_addkids_father_fullname.Text); existingUser.mother_fullname = CapitalizeFirst(txt_addkids_mother_fullname.Text); existingUser.father_phone = txt_addkids_father_phone_number.Text; existingUser.mother_phone = txt_addkids_mother_phone_number.Text; existingUser.id_child_place_of_birth = combo_addkids_child_place_of_birth.Text; existingUser.id_child_address = combo_addkids_child_address.Text; existingUser.child_nationality = combo_addkids_child_nationality.Text; existingUser.child_blood_type = combo_addkids_child__blood_type.Text; existingUser.serial_of_child = combo_addkids_serial_of_child.Text; existingUser.child_language = combo_addkids_child_language.Text; existingUser.child_gender = combo_addkids_child_gendar.Text; existingUser.number_of_bro_and_sis = int.Parse(txt_addkids_number_of_bro_sis.Text); existingUser.parent_email = txt_addkids_parent_email.Text; existingUser.name_of_baby_steer = txt_addkids_name_of_baby_steer.Text; existingUser.baby_steer_phone = txt_addkids_baby_steer_phone.Text; db.SaveChangesAsync(); MessageBox.Show("Updated Successfully"); } else { gunaLineTextBox1.Text = "0"; var currentAddressId = db.tbl_address .Where(a => a.adrress == combo_addkids_child_address.Text) .Select(a => a.id) .SingleOrDefault(); var birtrhAddressId = db.tbl_address .Where(a => a.adrress == combo_addkids_child_place_of_birth.Text) .Select(a => a.id) .SingleOrDefault(); var child = new tbl_child_info() { child_fullname = CapitalizeFirst(txt_addkids_child_fullname.Text), income_date = DateTime.Parse(DateTimePicker_In_come_date.Text), id_user_save = userClass.getUserId(), datetime_save = DateTime.Today, form_number = int.Parse(txt_addkids_form_number.Text), child_birthday = DateTime.Parse(DateTimePicker_child_birth_date.Text), father_fullname = CapitalizeFirst(txt_addkids_father_fullname.Text), mother_fullname = CapitalizeFirst(txt_addkids_mother_fullname.Text), father_phone = txt_addkids_father_phone_number.Text, mother_phone = txt_addkids_mother_phone_number.Text, id_child_place_of_birth = combo_addkids_child_place_of_birth.Text, id_child_address = combo_addkids_child_place_of_birth.Text, child_nationality = combo_addkids_child_nationality.Text, child_blood_type = combo_addkids_child__blood_type.Text, serial_of_child = combo_addkids_serial_of_child.Text, child_language = combo_addkids_child_language.Text, child_gender = combo_addkids_child_gendar.Text, number_of_bro_and_sis = int.Parse(txt_addkids_number_of_bro_sis.Text), parent_email = txt_addkids_parent_email.Text, name_of_baby_steer = txt_addkids_name_of_baby_steer.Text, baby_steer_phone = txt_addkids_baby_steer_phone.Text, }; db.tbl_child_info.Add(child); db.SaveChangesAsync(); MessageBox.Show("New child Added Successfully"); } } catch (Exception) { MessageBox.Show("Some Field Are Required"); } }