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");
}
}