private void delete_Click(object sender, EventArgs e) { String temNic = ""; temNic = nictxt.Text; Boolean ans = checkNIC(temNic); if (temNic == "") { // MessageBox.Show("Pleace Insert NIC!!!"); ErrorDialogBox.ShowDialog("Pleace Insert NIC!!!", "Validation Error"); } else if (ans != true) { ErrorDialogBox.ShowDialog("Invalid NIC. Please enter Registerd NIC", "Validation Error"); } else { con.Open(); cmd = new SqlCommand("Delete from Staff_Mang_Table where NIC = '" + nictxt.Text + "'", con); cmd.ExecuteNonQuery(); SuccessfullMessageBox.ShowDialog("Delere Records Successfully!!!", "Confirmation Message"); // MessageBox.Show("Delere Records Successfully!!!"); con.Close(); display(); clearallData(); } }
private void changePassword_btn_Click(object sender, EventArgs e) { String getNIC = Login.setNIC; if (Login.setpassword == currentPassword_txt.Text) { if (newPassword_txt.Text == confirmPassword_txt.Text) { con.Open(); cmd = new SqlCommand("update Staff_Mang_Table set password= '******' where NIC = @getNIC", con); cmd.Parameters.Add("@getNIC", SqlDbType.VarChar).Value = getNIC; cmd.ExecuteNonQuery(); SuccessfullMessageBox.ShowDialog("Password Update Successfully !!!", "Confirmation Message"); con.Close(); } else { ErrorDialogBox.ShowDialog("Confirm Password Does't macth with new Password!!!", "New Password Invaild"); newPassword_txt.Text = ""; confirmPassword_txt.Text = ""; } } else { ErrorDialogBox.ShowDialog("Current Password does not match.!!!", "Current Password Invaild"); } }
private void cancelbtn_Click(object sender, EventArgs e) { if (staffnicLabel.Text == null || typeLable.Text == null) { ErrorDialogBox.ShowDialog("Please double click one rquest from table First", "Invaild Data"); } else { con.Open(); cmd = new SqlCommand("Delete from staff_Temp_Request_Leaves where sid = @sid", con); cmd.Parameters.Add("@sid", SqlDbType.Int).Value = sid; cmd.ExecuteNonQuery(); con.Close(); SuccessfullMessageBox.ShowDialog("Request Cancle Successfully !!!", "Confirmation Message"); String cancleby = Login.setNIC; con.Open(); cmd = new SqlCommand("insert into staff_cancle_Leaves (NIC, type, reason, date, cancleby)values('" + staffnicLabel.Text + "', '" + typeLable.Text + "', '" + reasonLable.Text + "', '" + dateLable.Text + "', @approveby)", con); cmd.Parameters.Add("@approveby", SqlDbType.VarChar).Value = cancleby; cmd.ExecuteNonQuery(); con.Close(); cleareText(); } }
public static void ShowDialog(string msg, string tMsg) { ErrorDialogBox sdb = new ErrorDialogBox(msg, tMsg); sdb.ShowDialog(); }
private void loginbtn_Click(object sender, EventArgs e) { String atype = null; atype = atypelogin.Text.ToString(); if (atypelogin.Text == "Admin") { String username = "******"; String password = "******"; if (usernametxt.Text == username && loginpasswordtxt.Text == password) { this.Hide(); // Form1 sf = new Form1(); // sf.Show(); // var form2 = Form1.StaffFrom2; // this.Closed += (s, args) => this.Close(); // form2.Show(); SchoolManagementSystem.mainMenu nm = new SchoolManagementSystem.mainMenu(); nm.Show(); // var form3 = SchoolManagementSystem.mainMenu.maintt; // form3.Show(); } else { ErrorDialogBox.ShowDialog("UserName and Password Does not Match, Pleace Re Enter!!!", "Invaild UserName Or Password"); con.Close(); return; } } else if (atype == "Staff") { con.Open(); SqlCommand cmd = new SqlCommand("select * from Staff_Mang_Table where NIC = '" + usernametxt.Text + "' AND password = '******'", con); SqlDataAdapter checkDa = new SqlDataAdapter(cmd); SqlDataReader reader = cmd.ExecuteReader(); DataSet ds = new DataSet(); int i = 0; while (reader.Read()) { i++; } if (i > 0) { this.Hide(); staff_profile f = new staff_profile(); f.Show(); var form1 = staffprofile.StaffManagmentInstance_4; // this.Closed += (s, args) => this.Close(); form1.Show(); } else { ErrorDialogBox.ShowDialog("UserName and Password Does not Match, Pleace Re Enter!!!", "Invaild UserName Or Password"); con.Close(); return; } } else if (atypelogin.Text == "Student") { } else if (atypelogin.Text == "") { ErrorDialogBox.ShowDialog("Please Select UserType!!!", "Invaild User"); con.Close(); return; } setpassword = loginpasswordtxt.Text; setNIC = usernametxt.Text; }
public void updateData() { // ======= Validation =========== if (fnametxt.Text == "") { fnametxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("First name is Requied.", "Validation Error"); fnametxt.Focus(); return; } if (lnametxt.Text == "") { lnametxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Last name is Requied.", "Validation Error"); lnametxt.Focus(); return; } if (tpnotxt.Text == "") { tpnotxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Telephone No is Requied.", "Validation Error"); tpnotxt.Focus(); return; } else { Regex regtp = new Regex(@"^\d{10}$"); if (!regtp.IsMatch(tpnotxt.Text)) { tpnotxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Telephone must containt 10 numbers and NO Alpebetic Letters", "Validation Error"); tpnotxt.Focus(); return; } } if (emailtxt.Text == "") { emailtxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Email is Requied.", "Validation Error"); emailtxt.Focus(); return; } else { Regex regEmail = new Regex(@"^(([^<>()[\]\\.,;:\s@\""]+" + @"(\.[^<>()[\]\\.,;:\s@\""]+)*)|(\"".+\""))@" + @"((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}" + @"\.[0-9]{1,3}\])|(([a-zA-Z\-0-9]+\.)+" + @"[a-zA-Z]{2,}))$", RegexOptions.Compiled); if (!regEmail.IsMatch(emailtxt.Text)) { emailtxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Please Insert Valid Email Requied.", "Validation Error"); emailtxt.Focus(); return; } } if (address1txt.Text == "") { address1txt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Addres line 01 is Requied.", "Validation Error"); address1txt.Focus(); return; } if (address2txt.Text == "") { address2txt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Addres line 02 is Requied.", "Validation Error"); address2txt.Focus(); return; } if (address3txt.Text == "") { address3txt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Addres line 03 is Requied.", "Validation Error"); address3txt.Focus(); return; } if (nictxt.Text == "") { nictxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("NIC is Requied.", "Validation Error"); nictxt.Focus(); return; } else { Regex regNIC = new Regex(@"^[0-9]{9}[vV]$"); if (!regNIC.IsMatch(nictxt.Text)) { nictxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("NIC must containt 9 numbers and 'V' or 'v' at the last.", "Validation Error"); nictxt.Focus(); return; } } if (passwordtxt.Text == "") { passwordtxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Password is Requied.", "Validation Error"); passwordtxt.Focus(); return; } String temNic = nictxt.Text; Boolean ans = checkNIC(temNic); if (ans != true) { ErrorDialogBox.ShowDialog("Invalid NIC. Please enter Registerd NIC", "Validation Error"); } else { MemoryStream ms = new MemoryStream(); profile_picxtxt.Image.Save(ms, profile_picxtxt.Image.RawFormat); byte[] image = ms.ToArray(); con.Open(); cmd = new SqlCommand("update Staff_Mang_Table set title = '" + titletxt.Text + "', fname = '" + fnametxt.Text + "', lname = '" + lnametxt.Text + "', gender = '" + gendertxt.Text + "',tpno = '" + tpnotxt.Text + "', email = '" + emailtxt.Text + "', address1 = '" + address1txt.Text + "', address2 = '" + address2txt.Text + "', address3 = '" + address3txt.Text + "', qualification = '" + qualificationtxt.Text + "', accountType = '" + atypetxt.Text + "', password = '******', startdate = '" + sdatetxt.Text + "', photo = @photo where NIC = '" + nictxt.Text + "'", con); cmd.Parameters.Add("@photo", SqlDbType.VarBinary).Value = image; cmd.ExecuteNonQuery(); SuccessfullMessageBox.ShowDialog("Update Successfully !!!", "Confirmation Message"); // MessageBox.Show("Update Successfully !!!"); con.Close(); display(); clearallData(); } }
//Insert Data to the DataBase private void Insert_Click(object sender, EventArgs e) { // ======= Validation =========== if (fnametxt.Text == "") { fnametxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("First name is Requied.", "Validation Error"); fnametxt.Focus(); return; } if (lnametxt.Text == "") { lnametxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Last name is Requied.", "Validation Error"); lnametxt.Focus(); return; } if (tpnotxt.Text == "") { tpnotxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Telephone No is Requied.", "Validation Error"); tpnotxt.Focus(); return; } else { Regex regtp = new Regex(@"^\d{10}$"); if (!regtp.IsMatch(tpnotxt.Text)) { tpnotxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Telephone must containt 10 numbers and NO Alpebetic Letters", "Validation Error"); tpnotxt.Focus(); return; } } if (emailtxt.Text == "") { emailtxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Email is Requied.", "Validation Error"); emailtxt.Focus(); return; } else { Regex regEmail = new Regex(@"^(([^<>()[\]\\.,;:\s@\""]+" + @"(\.[^<>()[\]\\.,;:\s@\""]+)*)|(\"".+\""))@" + @"((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}" + @"\.[0-9]{1,3}\])|(([a-zA-Z\-0-9]+\.)+" + @"[a-zA-Z]{2,}))$", RegexOptions.Compiled); if (!regEmail.IsMatch(emailtxt.Text)) { emailtxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Please Insert Valid Email Requied.", "Validation Error"); emailtxt.Focus(); return; } } if (address1txt.Text == "") { address1txt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Addres line 01 is Requied.", "Validation Error"); address1txt.Focus(); return; } if (address2txt.Text == "") { address2txt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Addres line 02 is Requied.", "Validation Error"); address2txt.Focus(); return; } if (address3txt.Text == "") { address3txt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Addres line 03 is Requied.", "Validation Error"); address3txt.Focus(); return; } if (nictxt.Text == "") { nictxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("NIC is Requied.", "Validation Error"); nictxt.Focus(); return; } else { Regex regNIC = new Regex(@"^[0-9]{9}[vV]$"); if (!regNIC.IsMatch(nictxt.Text)) { nictxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("NIC must containt 9 numbers and 'V' or 'v' at the last.", "Validation Error"); nictxt.Focus(); return; } } if (passwordtxt.Text == "") { passwordtxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Password is Requied.", "Validation Error"); passwordtxt.Focus(); return; } //Image MemoryStream ms = new MemoryStream(); profile_picxtxt.Image.Save(ms, profile_picxtxt.Image.RawFormat); image = ms.ToArray(); String temNic = nictxt.Text; Boolean ans = checkNIC(temNic); if (ans == true) { ErrorDialogBox.ShowDialog("This Employee Already Registered!!!Pleace Register another Employee.", "Validation Error"); } else { con.Open(); cmd = new SqlCommand("INSERT INTO Staff_Mang_Table VALUES('" + nictxt.Text + "','" + titletxt.Text + "','" + fnametxt.Text + "','" + lnametxt.Text + "','" + gendertxt.Text + "','" + tpnotxt.Text + "','" + emailtxt.Text + "','" + address1txt.Text + "','" + address2txt.Text + "','" + address3txt.Text + "','" + qualificationtxt.Text + "','" + atypetxt.Text + "','" + passwordtxt.Text + "','" + sdatetxt.Text + "', @photo)", con); cmd.Parameters.Add("@photo", SqlDbType.VarBinary).Value = image; cmd.ExecuteNonQuery(); SuccessfullMessageBox.ShowDialog("Registration Successfully.", "Confirmation Message"); con.Close(); display(); } }
private void requestlvbtn_Click(object sender, EventArgs e) { if (reasontxt.Text == "") { reasontxt.BackColor = Color.Red; ErrorDialogBox.ShowDialog("Reason is Requied.", "Validation Error"); reasontxt.Focus(); return; } if (typetxt.Text == "Casual_Leave") { if (casual > 0) { con.Open(); cmd = new SqlCommand("Insert into staff_Temp_Request_Leaves (NIC, type, reason, date) values(@getNIC2,'" + typetxt.Text + "', '" + reasontxt.Text + "','" + selectDateTxt.Text + "')", con); cmd.Parameters.Add("@getNIC2", SqlDbType.VarChar).Value = getNIC2; cmd.ExecuteNonQuery(); con.Close(); displayleave(); SuccessfullMessageBox.ShowDialog("Casual Leave Request is Applly Successfully !!!", "Confirmation Message"); } else { ErrorDialogBox.ShowDialog("Sorry!!! All alocated Casual Leaves Are Used this Month.", "No Leaves"); // MessageBox.Show("Sorry!!! All alocated Casual Leaves Are Used."); } } else if (typetxt.Text == "HalfDay_Leave") { if (casual > 0) { con.Open(); cmd = new SqlCommand("Insert into staff_Temp_Request_Leaves (NIC, type, reason, date) values(@getNIC2,'" + typetxt.Text + "', '" + reasontxt.Text + "','" + selectDateTxt.Text + "')", con); cmd.Parameters.Add("@getNIC2", SqlDbType.VarChar).Value = getNIC2; cmd.ExecuteNonQuery(); // MessageBox.Show("Leaves Pending!!!"); con.Close(); displayleave(); // MessageBox.Show("Half Day Leave Request is Applly Successfully !!!"); SuccessfullMessageBox.ShowDialog("Half Day Leave Request is Applly Successfully !!!", "Confirmation Message"); } else { ErrorDialogBox.ShowDialog("Sorry!!! All alocated Half Day Leaves Are Used this Month.", "No Leaves"); //MessageBox.Show("Sorry!!! All alocated Half Day Leaves Are Used this Month."); } } else if (typetxt.Text == "Medical_Leave") { if (medical > 0) { con.Open(); cmd = new SqlCommand("Insert into staff_Temp_Request_Leaves (NIC, type, reason, date) values(@getNIC2,'" + typetxt.Text + "', '" + reasontxt.Text + "','" + selectDateTxt.Text + "')", con); cmd.Parameters.Add("@getNIC2", SqlDbType.VarChar).Value = getNIC2; cmd.ExecuteNonQuery(); con.Close(); displayleave(); SuccessfullMessageBox.ShowDialog("Medical_Leave Leave Request is Applly Successfully !!!", "Confirmation Message"); // MessageBox.Show("Medical Leave Request is Applly Successfully !!!"); // Payment.SuccessDialogBox.ShowDialog("Medical_Leave Request is Applly Successfully !!!", "Successfull Message"); } else { ErrorDialogBox.ShowDialog("Sorry!!! All alocated Medical Leaves Are Used this Month.", "No Leaves"); // MessageBox.Show("Sorry!!! All alocated Medical Leaves Are Used this Month."); } } else if (typetxt.Text == "Short_Leave") { if (shortleave > 0) { con.Open(); cmd = new SqlCommand("Insert into staff_Temp_Request_Leaves (NIC, type, reason, date) values(@getNIC2,'" + typetxt.Text + "', '" + reasontxt.Text + "','" + selectDateTxt.Text + "')", con); cmd.Parameters.Add("@getNIC2", SqlDbType.VarChar).Value = getNIC2; cmd.ExecuteNonQuery(); // MessageBox.Show("Leaves Pending!!!"); con.Close(); displayleave(); //Payment.SuccessDialogBox.ShowDialog("shortleaves Request is Applly Successfully !!!", "Successfull Message"); // MessageBox.Show("shortleaves Request is Applly Successfully !!!"); SuccessfullMessageBox.ShowDialog("shortleaves Leave Request is Applly Successfully !!!", "Confirmation Message"); } else { ErrorDialogBox.ShowDialog("Sorry!!! All alocated shortleaves Leaves Are Used this Month.", "No Leaves"); // MessageBox.Show("Sorry!!! All alocated Half Day Leaves Are Used this Month."); } } else { ErrorDialogBox.ShowDialog("Sorry!!! No ", " Invaild Type"); MessageBox.Show("Invaild type !!!"); } reasontxt.Text = ""; typetxt.SelectedIndex = -1; }
private void confirmbtn_Click(object sender, EventArgs e) { if (staffnicLabel.Text == null || typeLable.Text == null) { ErrorDialogBox.ShowDialog("Please double click one rquest from table First", "Invaild Data"); } else { String approveby = Login.setNIC; con.Open(); cmd = new SqlCommand("insert into staff_Approve_Leaves values('" + staffnicLabel.Text + "', '" + typeLable.Text + "', '" + reasonLable.Text + "', '" + dateLable.Text + "', @approveby)", con); cmd.Parameters.Add("@approveby", SqlDbType.VarChar).Value = approveby; cmd.ExecuteNonQuery(); SuccessfullMessageBox.ShowDialog("Leave Approved", "Confirmation Message"); con.Close(); con.Open(); cmd = new SqlCommand("Delete from staff_Temp_Request_Leaves where sid = @sid", con); cmd.Parameters.Add("@sid", SqlDbType.Int).Value = sid; cmd.ExecuteNonQuery(); con.Close(); displayleaveReuest(); getLeaves(); if (typeLable.Text == "Casual_Leave") { casual = casual - 1; con.Open(); cmd = new SqlCommand("update staff_Leaves set Casual_Leave = @Casual_Leave where NIC = '" + staffnicLabel.Text + "' ", con); cmd.Parameters.Add("@Casual_Leave", SqlDbType.Int).Value = (int)casual; cmd.ExecuteNonQuery(); con.Close(); } else if (typeLable.Text == "Medical_Leave") { medical = medical - 1; con.Open(); cmd = new SqlCommand("update staff_Leaves set Medical_Leave = @Medical_Leave where NIC = '" + staffnicLabel.Text + "' ", con); cmd.Parameters.Add("@Medical_Leave", SqlDbType.Int).Value = (int)medical; cmd.ExecuteNonQuery(); con.Close(); } else if (typeLable.Text == "Short_Leave") { shortleave = shortleave - 1; con.Open(); cmd = new SqlCommand("update staff_Leaves set Short_Leave = @Short_Leave where NIC = '" + staffnicLabel.Text + "' ", con); cmd.Parameters.Add("@Short_Leave", SqlDbType.Int).Value = (int)shortleave; cmd.ExecuteNonQuery(); con.Close(); } else if (typeLable.Text == "HalfDay_Leave") { halfday = halfday + 1; con.Open(); cmd = new SqlCommand("update staff_Leaves set HalfDay_Leave = @HalfDay_Leave where NIC = '" + staffnicLabel.Text + "' ", con); cmd.Parameters.Add("@HalfDay_Leave", SqlDbType.Int).Value = (int)halfday; cmd.ExecuteNonQuery(); con.Close(); /////////////////// if (halfday % 2 == 0) { casual = casual - 1; con.Open(); cmd = new SqlCommand("update staff_Leaves set Casual_Leave = @Casual_Leave where NIC = '" + staffnicLabel.Text + "' ", con); cmd.Parameters.Add("@Casual_Leave", SqlDbType.Int).Value = (int)casual; cmd.ExecuteNonQuery(); con.Close(); } } } cleareText(); }