private void btn_employee_delete_Click(object sender, EventArgs e)
{
try
{
if (gbEmpId > 0)
{
using (var context = new PreSchoolEntities1())
{
var emplooye = context.tbl_employee.Where(item => item.id == gbEmpId).First();
var confirmation = MessageBox.Show("Are You Sure About Deleting This Emplooye ?", "Please Confirm", MessageBoxButtons.YesNo);
if (confirmation == DialogResult.Yes)
{
context.tbl_employee.Remove(emplooye);
context.SaveChanges();
}
}
view();
clear();
}
else
{
MessageBox.Show("Please Select A Row To Delete");
}
}
catch (Exception)
{
MessageBox.Show("Error Deleting Room Data");
}
}
private void btn_addkids_save_Click(object sender, EventArgs e)
{
try
{
if (userId > 0)
{
using (var context = new PreSchoolEntities1())
{
var user = context.tbl_user.Where(item => item.id == userId).First();
var confirmation = MessageBox.Show("Are You Sure About Deleting " + user.User_fullname + "?", "Please Confirm", MessageBoxButtons.YesNo);
if (confirmation == DialogResult.Yes)
{
context.tbl_user.Remove(user);
context.SaveChanges();
}
}
view();
clear();
}
}
catch (Exception)
{
MessageBox.Show("Please Select A Field You Want To Delete");
}
}
private void gunaAdvenceButton7_Click(object sender, EventArgs e)
{
try
{
if (!String.IsNullOrWhiteSpace(gunaLineTextBox1.Text) && gunaLineTextBox1.Text != "0")
{
int healthId = int.Parse(gunaLineTextBox1.Text);
using (var context = new PreSchoolEntities1())
{
var healthData = context.tbl_child_healthy.Where(item => item.id == healthId).First();
var confirmation = MessageBox.Show("Are You Sure About Deleting This Child In This Room ", "Please Confirm", MessageBoxButtons.YesNo);
if (confirmation == DialogResult.Yes)
{
context.tbl_child_healthy.Remove(healthData);
context.SaveChanges();
clear();
}
}
}
else
{
MessageBox.Show("No Id In The Search Field");
}
}
catch (Exception)
{
MessageBox.Show("Error Deleting Health Data");
}
}
void view()
{
db = new PreSchoolEntities1();
var roomsData = db.tbl_rooms.Join(
db.tbl_child_info,
room => room.id_child,
child => child.id,
(room, child) => new
{
id = room.id,
childName = child.child_fullname,
roomId = room.id_room_name,
}
).Join(
db.tbl_room_name,
room => room.roomId,
roomName => roomName.id,
(table1, roomName) => new
{
Id = table1.id,
ChildName = table1.childName,
RoomName = roomName.room_name,
}
).ToList();
dataGridView1.DataSource = roomsData;
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
var cellData = dataGridView1.SelectedCells[0].Value.ToString();
if (!String.IsNullOrWhiteSpace(cellData))
{
try
{
var id = int.Parse(cellData);
db = new PreSchoolEntities1();
var user = db.tbl_user
.Where(s => s.id == id)
.FirstOrDefault();
txt_user_userFullname.Text = user.User_fullname;
txt_user_password.Text = user.password;
txt_user_username.Text = user.username;
combo_role.Text = user.User_Role;
userId = int.Parse(user.id.ToString());
if (user.status == true)
{
gunaCheckBox1.Checked = true;
}
}
catch (Exception)
{
MessageBox.Show("Please Select The Id");
}
}
}
private void gunaAdvenceButton1_Click(object sender, EventArgs e)
{
var user = new userClass();
db = new PreSchoolEntities1();
var authUser = db.tbl_user.Where(
x => x.username == username.Text && x.password == gunaLineTextBox2.Text
).FirstOrDefault();
if (authUser != null)
{
userClass.setUserId(int.Parse(authUser.id.ToString()));
userClass.setUserName(authUser.username);
userClass.setFullName(authUser.User_fullname);
userClass.setUserStatus(authUser.status.ToString());
userClass.setUserRole(authUser.User_Role);
userClass.setUserPassword(authUser.password);
main main = new main();
main.c = gunaWinSwitch1.Checked;
main.Show();
this.Hide();
}
else
{
MessageBox.Show(this, "Wrong Credentials");
}
}
private void gunaAdvenceButton7_Click(object sender, EventArgs e)
{
try
{
if (!String.IsNullOrWhiteSpace(gunaLineTextBox1.Text) && gunaLineTextBox1.Text != "0")
{
int childId = int.Parse(gunaLineTextBox1.Text);
using (var context = new PreSchoolEntities1())
{
var childData = context.tbl_child_info.Where(item => item.id == childId).First();
var confirmation = MessageBox.Show("Are You Sure About Deleting This Child Data ", "Please Confirm", MessageBoxButtons.YesNo);
if (confirmation == DialogResult.Yes)
{
context.tbl_child_info.Remove(childData);
context.SaveChanges();
Clear(Controls);
}
}
}
else
{
MessageBox.Show("No Id In The Search Field");
}
}
catch (Exception)
{
MessageBox.Show("Before You Deeleting This Child Data You Should Remove It From The Room And Other References");
Clear(Controls);
}
}
private void btn_rooms_delete_Click_1(object sender, EventArgs e)
{
try
{
if (gbActivityId > 0)
{
using (var context = new PreSchoolEntities1())
{
var activity = context.tbl_subject_activity.Where(item => item.id == gbActivityId).First();
var confirmation = MessageBox.Show("Are You Sure About Deleting This Child In This Activity ?", "Please Confirm", MessageBoxButtons.YesNo);
if (confirmation == DialogResult.Yes)
{
context.tbl_subject_activity.Remove(activity);
context.SaveChanges();
}
}
view();
clear();
}
else
{
MessageBox.Show("Please Select A Row To Delete");
}
}
catch (Exception)
{
MessageBox.Show("Error Deleting Room Data");
}
}
private void btn_addkids_save_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(diseasse.Text))
{
MessageBox.Show("Please type something!");
}
else
{
try
{
db = new PreSchoolEntities1();
int userId = userClass.getUserId();
var newDisease = new tbl_disease_type()
{
name_disease = diseasse.Text,
id_user_save = userId,
};
db.tbl_disease_type.Add(newDisease);
db.SaveChanges();
MessageBox.Show("New Disease Added");
}
catch (Exception)
{
MessageBox.Show("Error Adding New Data");
}
}
}
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");
}
}
public void search(string text)
{
db = new PreSchoolEntities1();
db.tbl_child_info.Where(n => n.child_fullname.Contains(text)).Load();
var childs = dataGridView1.DataSource = db.tbl_child_info.Local.ToBindingList();
dataGridView1.DataSource = childs;
}
private void btn_rooms_save_Click(object sender, EventArgs e)
{
if (gbAttensId > 0)
{
db = new PreSchoolEntities1();
var attenData = db.tbl_attendance.Where(x => x.id == gbAttensId).FirstOrDefault();
var childId = db.tbl_child_info.Where(items => items.child_fullname == comboo_child_name.Text)
.Select(a => a.id)
.FirstOrDefault();
DateTime dt = dateTimePicker1.Value;
TimeSpan incomeTime = new TimeSpan(dt.Hour, dt.Minute, dt.Second);
DateTime dt2 = dateTimePicker2.Value;
TimeSpan leftTime = new TimeSpan(dt2.Hour, dt2.Minute, dt2.Second);
attenData.id_child = childId;
attenData.time_income = incomeTime;
attenData.time_left = leftTime;
attenData.left_with = left_with.Text;
attenData.date_save = DateTime.Now;
db.SaveChanges();
view();
clear();
}
else
{
db = new PreSchoolEntities1();
DateTime dt = dateTimePicker1.Value;
TimeSpan incomeTime = new TimeSpan(dt.Hour, dt.Minute, dt.Second);
DateTime dt2 = dateTimePicker2.Value;
TimeSpan leftTime = new TimeSpan(dt2.Hour, dt2.Minute, dt2.Second);
var childId = db.tbl_child_info.Where(items => items.child_fullname == comboo_child_name.Text)
.Select(a => a.id)
.FirstOrDefault();
var newAttendance = new tbl_attendance()
{
id_child = childId,
id_user_save = userClass.getUserId(),
time_income = incomeTime,
time_left = leftTime,
left_with = left_with.Text,
date_save = DateTime.Now
};
db.tbl_attendance.Add(newAttendance);
db.SaveChanges();
view();
clear();
}
}
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 combo_addkids_child_place_of_birth_Enter(object sender, EventArgs e)
{
combo_addkids_child_place_of_birth.Items.Clear();
db = new PreSchoolEntities1();
var addresses = db.tbl_address;
foreach (var item in addresses)
{
combo_addkids_child_place_of_birth.Items.Add(item.adrress);
}
}
private void addKidscs_Load(object sender, EventArgs e)
{
db = new PreSchoolEntities1();
var addresses = db.tbl_address;
foreach (var item in addresses)
{
combo_addkids_child_address.Items.Add(item.adrress);
combo_addkids_child_place_of_birth.Items.Add(item.adrress);
}
}
private void childHealth_Load(object sender, EventArgs e)
{
db = new PreSchoolEntities1();
var childs = db.tbl_child_info;
foreach (var item in childs)
{
combo_childHealth_child_name.Items.Add(item.child_fullname);
}
fillDisease();
}
void search(string txt)
{
db = new PreSchoolEntities1();
var healthData = db.tbl_child_healthy.Join(
db.tbl_child_info,
x => x.id_child,
y => y.id,
(health, child) => new
{
id = health.id,
child_name = child.child_fullname,
drug_algeric = health.drug_allergy,
coronic_cure = health.darmany_naxoshiya_drezhxayanaka,
surgery = health.have_surgery,
disease_id_name = health.id_child_disease_type,
surgery_note = health.note_of_surgery,
clinic_type = health.general_clinic_test_disease_type,
clinic_type_note = health.general_clinic_test_disease_type_note,
face_type = health.face_type,
height = health.child_height,
weight = health.child_weight,
food_type = health.food_eating_type,
dateSave = health.datetime_save,
dateUpdate = health.datetime_update,
}).Join(
db.tbl_disease_type,
x => x.disease_id_name,
y => y.id,
(tbl1, disease) => new
{
id = tbl1.id,
ChildName = tbl1.child_name,
DrugAlergic = tbl1.drug_algeric,
Surgery = tbl1.surgery,
SurgeryNote = tbl1.surgery_note,
CorinicCure = tbl1.coronic_cure,
ClinicType = tbl1.clinic_type,
ClinicNote = tbl1.clinic_type_note,
Heigth = tbl1.height,
Weight = tbl1.weight,
FoodType = tbl1.food_type,
Disease = disease.name_disease,
SavedAt = tbl1.dateSave,
LastUpdate = tbl1.dateUpdate,
}
)
.Where(
x => x.ChildName.Contains(txt)
).ToList();
dataGridView1.DataSource = healthData;
}
private void HealthData_Load(object sender, EventArgs e)
{
db = new PreSchoolEntities1();
var healthData = db.tbl_child_healthy.Join(
db.tbl_child_info,
x => x.id_child,
y => y.id,
(health, child) => new
{
id = health.id,
child_name = child.child_fullname,
drug_algeric = health.drug_allergy,
coronic_cure = health.darmany_naxoshiya_drezhxayanaka,
surgery = health.have_surgery,
disease_id_name = health.id_child_disease_type,
surgery_note = health.note_of_surgery,
clinic_type = health.general_clinic_test_disease_type,
clinic_type_note = health.general_clinic_test_disease_type_note,
face_type = health.face_type,
height = health.child_height,
weight = health.child_weight,
food_type = health.food_eating_type,
dateSave = health.datetime_save,
dateUpdate = health.datetime_update,
}).
// Join(
//db.tbl_disease_type,
//x => x.disease_id_name,
//y => y.id,
//(tbl1, disease) => new
//{
// //id = tbl1.id,
// //ChildName = tbl1.child_name,
// //DrugAlergic = tbl1.drug_algeric,
// //Surgery = tbl1.surgery,
// //SurgeryNote = tbl1.surgery_note,
// //CorinicCure = tbl1.coronic_cure,
// //ClinicType = tbl1.clinic_type,
// //ClinicNote = tbl1.clinic_type_note,
// //Heigth = tbl1.height,
// //Weight = tbl1.weight,
// //FoodType = tbl1.food_type,
// //Disease = disease.name_disease,
// //SavedAt = tbl1.dateSave,
// //LastUpdate = tbl1.dateUpdate,
//}
//).
ToList();
dataGridView1.DataSource = healthData;
}
private void btn_employee_save_Click(object sender, EventArgs e)
{
try
{
if (gbEmpId > 0)
{
db = new PreSchoolEntities1();
int userId = userClass.getUserId();
var emplooye = db.tbl_employee.Where(x => x.id == gbEmpId).FirstOrDefault();
emplooye.employee_fullname = txt_employee_employeeFullname.Text;
emplooye.employee_gender = combo_employee_employeeGender.Text;
emplooye.employee_job_title = job_title.Text;
emplooye.salary = Math.Round(Convert.ToDecimal(txt_employee_salary.Text));
emplooye.employee_phone = txt_employee_employeePhone.Text;
emplooye.datetime_save = DateTime.Now;
emplooye.id_user_update = userId;
db.SaveChanges();
view();
clear();
}
else
{
db = new PreSchoolEntities1();
int userId = userClass.getUserId();
var newEmployee = new tbl_employee()
{
employee_fullname = txt_employee_employeeFullname.Text,
employee_gender = combo_employee_employeeGender.Text,
employee_job_title = job_title.Text,
salary = Math.Round(Convert.ToDecimal(txt_employee_salary.Text)),
employee_phone = txt_employee_employeePhone.Text,
datetime_save = DateTime.Now,
id_user_save = userId
};
db.tbl_employee.Add(newEmployee);
db.SaveChanges();
view();
clear();
}
}
catch (Exception)
{
MessageBox.Show("Eror");
}
}
private void Login_Load(object sender, EventArgs e)
{
//checkMode();
db = new PreSchoolEntities1();
var users = db.tbl_user;
foreach (var item in users)
{
username.Items.Add(item.username);
}
}
private void teacher_Load(object sender, EventArgs e)
{
db = new PreSchoolEntities1();
var rooms = db.tbl_room_name;
foreach (var item in rooms)
{
combo_teacher_room_name.Items.Add(item.room_name);
}
view();
}
private void Rooms_Load(object sender, EventArgs e)
{
db = new PreSchoolEntities1();
var childs = db.tbl_child_info;
var rooms = db.tbl_room_name;
foreach (var item in childs)
{
combo_rooms_child_name.Items.Add(item.child_fullname);
}
foreach (var item in rooms)
{
combo_rooms_roomsName.Items.Add(item.room_name);
}
view();
}
void search(string txt)
{
db = new PreSchoolEntities1();
int healthId = int.Parse(txt);
var healthData = db.tbl_child_healthy
.Where(s => s.id == healthId)
.FirstOrDefault();
decimal childId = healthData.id_child;
var child = db.tbl_child_info.Where(
x => x.id == childId
).Select(a => a.child_fullname)
.FirstOrDefault();
decimal diseaseId = Convert.ToInt32(healthData.id_child_disease_type);
var disease = db.tbl_disease_type.Where(
x => x.id == diseaseId
).Select(a => a.name_disease)
.FirstOrDefault();
combo_childHealth_child_name.Text = child;
combo_childHealth_child_disease.Text = disease;
txt_childHealth_drug_allergy.Text = healthData.drug_allergy;
disease_type_txt.Text = healthData.general_clinic_test_disease_type;
not_childHealth_general_clinic_test.Text = healthData.general_clinic_test_disease_type_note;
not_childHealth_surgery.Text = healthData.note_of_surgery;
txt_childHealth_chronic_candition_cure.Text = healthData.darmany_naxoshiya_drezhxayanaka;
txt_childHealth_face_type.Text = healthData.face_type;
txt_childHealth_child_weight.Text = healthData.child_weight;
txt_childHealth_child_height.Text = healthData.child_height;
txt_childHealth_foot_eating_type.Text = healthData.food_eating_type;
if (healthData.have_surgery == true)
{
gunaWinSwitch1.Checked = true;
}
}
private void gunaAdvenceButton2_Click(object sender, EventArgs e)
{
using (var context = new PreSchoolEntities1())
{
if (userId > 0 && !String.IsNullOrWhiteSpace(txt_user_userFullname.Text) &&
!String.IsNullOrWhiteSpace(txt_user_username.Text) &&
!String.IsNullOrWhiteSpace(txt_user_username.Text))
{
var user = context.tbl_user.Where(item => item.id == userId).First();
user.User_fullname = CapitalizeFirst(txt_user_userFullname.Text);
user.User_Role = combo_role.Text;
user.password = txt_user_password.Text;
user.username = txt_user_username.Text;
user.status = gunaCheckBox1.Checked;
context.SaveChanges();
}
else if (userId == 0 && !String.IsNullOrWhiteSpace(txt_user_userFullname.Text) &&
!String.IsNullOrWhiteSpace(txt_user_username.Text) &&
!String.IsNullOrWhiteSpace(txt_user_username.Text))
{
var newUser = new tbl_user()
{
User_fullname = CapitalizeFirst(txt_user_userFullname.Text),
User_Role = combo_role.Text,
password = txt_user_password.Text,
username = txt_user_username.Text,
status = gunaCheckBox1.Checked,
};
context.tbl_user.Add(newUser);
context.SaveChanges();
}
else
{
MessageBox.Show("Plese Enter Valid Fields");
}
}
view();
clear();
}
private void Attedance_Load(object sender, EventArgs e)
{
dateTimePicker1.Format = DateTimePickerFormat.Custom;
dateTimePicker1.CustomFormat = "HH:mm tt";
dateTimePicker2.Format = DateTimePickerFormat.Custom;
dateTimePicker2.CustomFormat = "HH:mm tt";
dateTimePicker1.ShowUpDown = true;
dateTimePicker2.ShowUpDown = true;
db = new PreSchoolEntities1();
var childs = db.tbl_child_info;
foreach (var item in childs)
{
comboo_child_name.Items.Add(item.child_fullname);
}
view();
}
void view()
{
db = new PreSchoolEntities1();
var employees = db.tbl_employee.Join(
db.tbl_user,
empolooye => empolooye.id_user_save,
user => user.id,
(emp, usr) => new
{
id = emp.id,
EmployeeFullname = emp.employee_fullname,
EmployeeGender = emp.employee_gender,
JobTitle = emp.employee_job_title,
Salary = emp.salary,
Phone = emp.employee_phone,
SavedAt = emp.datetime_save,
SavedBy = usr.User_fullname,
}
).ToList();
dataGridView1.DataSource = employees;
}
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");
}
public void search(int number)
{
//Creatig objct from the database
db = new PreSchoolEntities1();
var childData = db.tbl_child_info
.Where(s => s.id == number)
.FirstOrDefault();
//The Fields
txt_addkids_child_fullname.Text = childData.child_fullname;
txt_addkids_form_number.Text = childData.form_number.ToString();
combo_addkids_child_gendar.Text = childData.child_gender;
txt_addkids_father_fullname.Text = childData.father_fullname;
txt_addkids_mother_fullname.Text = childData.mother_fullname;
txt_addkids_father_phone_number.Text = childData.father_phone;
txt_addkids_mother_phone_number.Text = childData.mother_phone;
combo_addkids_child_language.Text = childData.child_language;
combo_addkids_child_nationality.Text = childData.child_nationality;
txt_addkids_parent_email.Text = childData.parent_email;
txt_addkids_name_of_baby_steer.Text = childData.name_of_baby_steer;
txt_addkids_baby_steer_phone.Text = childData.baby_steer_phone;
combo_addkids_serial_of_child.Text = childData.serial_of_child;
combo_addkids_child__blood_type.Text = childData.child_blood_type;
txt_addkids_number_of_bro_sis.Text = childData.number_of_bro_and_sis.ToString();
//Date And Time
DateTimePicker_In_come_date.Value = childData.income_date;
DateTimePicker_child_birth_date.Value = childData.child_birthday;
//Address And Place Of Birth
combo_addkids_child_address.Text = childData.id_child_address;
combo_addkids_child_place_of_birth.Text = childData.id_child_place_of_birth;
}
private void btn_addkids_save_Click_1(object sender, EventArgs e)
{
try
{
var confirmation = MessageBox.Show("Are You Sure To Save These Changes ?", "Submit Channges", MessageBoxButtons.YesNo);
if (confirmation == DialogResult.Yes)
{
using (var context = new PreSchoolEntities1())
{
context.SaveChanges();
}
}
else
{
db = new PreSchoolEntities1();
db.tbl_child_info.Load();
dataGridView1.DataSource = db.tbl_child_info.Local.ToBindingList();
}
}
catch (Exception)
{
MessageBox.Show("Error");
}
}
void view()
{
db = new PreSchoolEntities1();
var activityData = db.tbl_subject_activity.Join(
db.tbl_room_name,
teacher => teacher.id_room_name,
roomName => roomName.id,
(subject, room) => new
{
id = subject.id,
Subject = subject.subject,
RoomName = room.room_name,
Savedate = subject.date,
userId = subject.id_user_save,
teacherNote = subject.note
}
)
.Join(
db.tbl_user,
subject => subject.userId,
user => user.id,
(table1, user) => new
{
Id = table1.id,
Subject = table1.Subject,
Date = table1.Savedate,
RoomName = table1.RoomName,
Teacher = user.User_fullname,
Note = table1.teacherNote
}
)
.ToList();
dataGridView1.DataSource = activityData;
}