private void btnpasssave_Click(object sender, EventArgs e) { var pass = db.UserLogins.Where(c => c.UserName == FormLogin.USERNAME).FirstOrDefault(); if (pass.Password == textBoxpass.Text) { if (textBoxnewpass.Text != "") { if (textBoxnewpass.Text == textBoxcpass.Text) { pass.Password = textBoxnewpass.Text; db.Entry(pass).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); MessageBox.Show("Password successfully changed!", "Data Updated - Student Management Sytem", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); DbEntityRefresh.Refresh(db); FormMain_Shown(sender, e); } else { MessageBox.Show("New Password and Confirm Password does not match!", "Error - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else { MessageBox.Show("Please enter a new password!", "Error - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else { MessageBox.Show("You have entered an incorrect current password!", "Error - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void panelsearchprevious_Click(object sender, EventArgs e) { DbEntityRefresh.Refresh(db); PreviousStudentList lst = new PreviousStudentList(); lst.ShowDialog(); }
private void btnschoolsave_Click(object sender, EventArgs e) { try { var schooladress = db.Randoms.Where(c => c.ID == 2).FirstOrDefault(); var schoolemail = db.Randoms.Where(c => c.ID == 4).FirstOrDefault(); var schoolcontact = db.Randoms.Where(c => c.ID == 3).FirstOrDefault(); schooladress.Text = txtschooladdress.Text; schoolcontact.Text = txtschoolcontact.Text; schoolemail.Text = txtschoolemail.Text; db.Entry(schooladress).State = System.Data.Entity.EntityState.Modified; db.Entry(schoolemail).State = System.Data.Entity.EntityState.Modified; db.Entry(schoolcontact).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); MessageBox.Show("Your School Data is sucessfully updated", "Data Updated - Student Management Sytem", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); DbEntityRefresh.Refresh(db); FormMain_Shown(sender, e); } catch (Exception ex) { MessageBox.Show("An Error Occured: " + ex.Message.ToString(), "Error - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnusersave_Click(object sender, EventArgs e) { var user = db.UserLogins.Where(c => c.UserName == textBoxuser.Text).FirstOrDefault(); if (user != null) { if (textBoxnewuser.Text != "") { if (textBoxnewuser.Text == textBoxcuser.Text) { user.UserName = textBoxnewuser.Text; db.Entry(user).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); MessageBox.Show("Username successfully changed!", "Data Updated - Student Management Sytem", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); DbEntityRefresh.Refresh(db); FormMain_Shown(sender, e); } else { MessageBox.Show("New Username and Confirm Username does not match!", "Error - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else { MessageBox.Show("Please enter a new username!", "Error - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else { MessageBox.Show("You have entered an incorrect current username!", "Error - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Bwreg_DoWork(object sender, DoWorkEventArgs e) { DbEntityRefresh.Refresh(db); LicenseEntity licdb = new LicenseEntity(); try { var a = licdb.Licenses.Where(c => c.SoftwareID == txtpublickey.Text).FirstOrDefault(); if (a != null) { var uid = db.Randoms.Where(c => c.ID == 18).FirstOrDefault(); bool IsPayement = a.IsPayment; if (IsPayement) { if (txtlicense.Text == a.LicenseKey) { var path = Application.StartupPath + @"\bin\"; string filename = "License.lic"; string[] lines = File.ReadAllLines(path + filename); string ency = a.LicenseStarts + "," + a.LicenseEnds + "," + uid.Text + "," + a.OwnerName + "," + a.SchoolName + "," + "False"; lines[7] = "Licensed Hash:" + ClsTripleDES.Encrypt(ency); File.WriteAllLines(path + "/" + filename, lines); a.InProcess = false; licdb.Entry(a).State = System.Data.Entity.EntityState.Modified; licdb.SaveChanges(); validate = true; } MessageBox.Show("Student Management System is successfully activated until " + a.LicenseEnds, "Successfully Activated", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { validate = false; } } else { MessageBox.Show("Your request doesnot exist at our License server! Please send request then register!", "Error - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show("An error occured: " + ex.Message.ToString(), "Error - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { licdb.Dispose(); } }
private void Bwreq_DoWork(object sender, DoWorkEventArgs e) { LicenseEntity licdb = new LicenseEntity(); try { DbEntityRefresh.Refresh(db); if (RequestExists()) { req = false; MessageBox.Show("Please be patience! Your request is under proces!", "Error - Student Management Sytem", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { SoftwareIDCheck(txtpublickey.Text); var schoolname = db.Randoms.Where(c => c.ID == 1).FirstOrDefault(); var Address = db.Randoms.Where(c => c.ID == 2).FirstOrDefault(); var Contact = db.Randoms.Where(c => c.ID == 3).FirstOrDefault(); var Email = db.Randoms.Where(c => c.ID == 4).FirstOrDefault(); var OwnerName = db.Randoms.Where(c => c.ID == 5).FirstOrDefault(); var softid = db.Randoms.Where(c => c.ID == 18).FirstOrDefault(); License lic = new License() { SoftwareID = softid.Text.ToString().Substring(0, 18), SchoolName = schoolname.Text, SchoolAddress = Address.Text, SchoolContact = Contact.Text, SchoolEmail = Email.Text, OwnerName = OwnerName.Text, IstallationDate = InstallationDate().ToString(), InProcess = true, IsPayment = false, LicenseKey = LicenseKey(), LicenseStarts = LicenseStarts(), LicenseEnds = LicenseEnds() }; licdb.Licenses.Add(lic); licdb.SaveChanges(); req = true; } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message.ToString(), "Error - Student Management Sytem", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } finally { licdb.Dispose(); } }
private void tabControl_SelectedIndexChanged(object sender, EventArgs e) { DbEntityRefresh.Refresh(db); li = db.StudentDatas.ToList(); labeltotalstd.Text = li.Count.ToString(); fe = db.StudentFees.Where(c => c.Submitted == false).ToList(); labeltotalfeede.Text = fe.Count.ToString(); labelfee.Text = "RS." + TotalAmountPerMonth() + "/-"; switch (tabControl.SelectedIndex) { case 0: this.btndashbaord.Normalcolor = System.Drawing.Color.FromArgb(((int)(((byte)(157)))), ((int)(((byte)(128)))), ((int)(((byte)(159))))); this.btnstudent.Normalcolor = Color.Transparent; this.btnfees.Normalcolor = Color.Transparent; this.btnsetting.Normalcolor = Color.Transparent; this.btnabout.Normalcolor = Color.Transparent; this.btnsetting.Normalcolor = Color.Transparent; break; case 1: this.btnstudent.Normalcolor = System.Drawing.Color.FromArgb(((int)(((byte)(157)))), ((int)(((byte)(128)))), ((int)(((byte)(159))))); this.btndashbaord.Normalcolor = Color.Transparent; this.btnfees.Normalcolor = Color.Transparent; this.btnsetting.Normalcolor = Color.Transparent; this.btnabout.Normalcolor = Color.Transparent; this.btnsetting.Normalcolor = Color.Transparent; break; case 2: this.btnstudent.Normalcolor = Color.Transparent; this.btndashbaord.Normalcolor = Color.Transparent; this.btnfees.Normalcolor = System.Drawing.Color.FromArgb(((int)(((byte)(157)))), ((int)(((byte)(128)))), ((int)(((byte)(159))))); this.btnsetting.Normalcolor = Color.Transparent; this.btnabout.Normalcolor = Color.Transparent; this.btnsetting.Normalcolor = Color.Transparent; break; case 3: this.btnstudent.Normalcolor = Color.Transparent; this.btndashbaord.Normalcolor = Color.Transparent; this.btnfees.Normalcolor = Color.Transparent; this.btnsetting.Normalcolor = Color.Transparent; this.btnabout.Normalcolor = System.Drawing.Color.FromArgb(((int)(((byte)(157)))), ((int)(((byte)(128)))), ((int)(((byte)(159))))); this.btnsetting.Normalcolor = Color.Transparent; break; } }
private void btnprintersave_Click(object sender, EventArgs e) { string filename = Application.StartupPath + @"\bin\User.config"; string[] lines = File.ReadAllLines(filename); lines[3] = "DefaultPrinter:" + comboboxprinters.Text; File.WriteAllLines(filename, lines); MessageBox.Show("Your Default printer is successfully changed. \nDefault Printer Name:" + comboboxprinters.Text, "Success - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); DbEntityRefresh.Refresh(db); FormMain_Shown(sender, e); }
private void Restore() { System.Threading.Thread.Sleep(5000); DbEntities newdb = new DbEntities(); DbEntityRefresh.Refresh(newdb); try { sourcepath = txtfilename.Text; File.Move(sourcepath, Path.ChangeExtension(sourcepath, ".db")); if (File.Exists(destpath + "/Database.db")) { File.Delete(destpath + "/Database.db"); } File.Copy(Path.GetDirectoryName(sourcepath) + "/Database.db", destpath + "/Database.db"); File.Move(Path.GetDirectoryName(sourcepath) + "/Database.db", Path.ChangeExtension(Path.GetDirectoryName(sourcepath) + "/Database.db", ".backupsms")); var schoolname = newdb.Randoms.Where(c => c.ID == 1).FirstOrDefault(); var schooladdress = newdb.Randoms.Where(c => c.ID == 2).FirstOrDefault(); var schoolcontact = newdb.Randoms.Where(c => c.ID == 3).FirstOrDefault(); var schoolemail = newdb.Randoms.Where(c => c.ID == 4).FirstOrDefault(); var ownername = newdb.Randoms.Where(c => c.ID == 5).FirstOrDefault(); var softid = newdb.Randoms.Where(c => c.ID == 18).FirstOrDefault(); string fileName = Application.StartupPath + @"\bin\License.lic"; // Check if file already exists. If yes, delete it. if (File.Exists(fileName)) { File.Delete(fileName); } // Create a new file using (StreamWriter sw = File.CreateText(fileName)) { sw.WriteLine("Owner Name:" + ownername.Text); sw.WriteLine("School Name:" + schoolname.Text); sw.WriteLine("School Address:" + schooladdress.Text); sw.WriteLine("School Contact:" + schoolcontact.Text); sw.WriteLine("School Email:" + schoolemail.Text); sw.WriteLine("Installation Date:" + DateTime.Now.ToString("dd/MM/yyyy")); sw.WriteLine("IsActivated:" + ClsTripleDES.Encrypt("False")); string ency = DateTime.Now.ToString("dd/MM/yyyy") + "," + DateTime.Now.AddDays(5).ToString("dd/MM/yyyy") + "," + softid.Text + "," + ownername.Text + "," + schoolname.Text + "," + "True"; sw.WriteLine("Licensed Hash:" + ClsTripleDES.Encrypt(ency)); } string[] lines = File.ReadAllLines(Application.StartupPath + @"\bin\User.Config"); lines[0] = "Owner Name:" + txtowner.Text; lines[1] = "School Name:" + txtschoolname.Text; lines[2] = "FirstRun:" + "False"; lines[3] = "DefaultPrinter:null"; File.WriteAllLines(Application.StartupPath + @"\bin\User.Config", lines); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Error - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { newdb.Dispose(); } }
private void FeeSetting_Activated(object sender, EventArgs e) { DbEntityRefresh.Refresh(db); FeeSetting_Load(sender, e); }
private void FormMain_Activated(object sender, EventArgs e) { DbEntityRefresh.Refresh(db); }
private void FormMain_Activated(object sender, EventArgs e) { DbEntityRefresh.Refresh(db); LicenseInformation(); FormMain_Shown(sender, e); }
private void btnsave_Click(object sender, EventArgs e) { if (job) { string mode = ""; if (checkBoxGraduated.Checked) { mode = "Graduated"; } if (checkBoxstruckoff.Checked) { mode = "Struck Off"; } DateTime date = Convert.ToDateTime(Admitdatepicker.Value); try { var data = db.StudentDatas.Where(c => c.ID == ID).FirstOrDefault(); var profile = db.StudentProfiles.Where(c => c.ID == ID).FirstOrDefault(); var fee = db.StudentFees.Where(c => c.ID == ID).FirstOrDefault(); PreStudent students = new PreStudent() { StudentID = ID, StudentName = StudentName, FatherName = data.FatherName, MotherName = data.MotherName, RegNo = data.RegNo, DateOfBirth = data.DateOfBirth, PlaceOfBirth = data.PlaceOfBirth, NIC = data.NIC, Gender = data.Gender, Religion = data.Religion, Address = data.Address, Contact = data.Contact, Class = data.Class, Section = data.Section, AdmitDate = data.AdmitDate, Session = data.Session, Mode = mode, StruckOffDate = date.ToString("dd/MM/yyyy") }; db.Entry(data).State = System.Data.Entity.EntityState.Deleted; db.Entry(fee).State = System.Data.Entity.EntityState.Deleted; db.Entry(profile).State = System.Data.Entity.EntityState.Deleted; db.PreviousStudents.Add(students); db.SaveChanges(); DbEntityRefresh.Refresh(db); labelresult.Text = "Successfully Saved!"; labelresult.ForeColor = Color.Green; labelresult.Visible = true; } catch (Exception ex) { MessageBox.Show("An error occured: " + ex.Message.ToString(), "Error - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btngenerate_Click(object sender, EventArgs e) { try { DbEntityRefresh.Refresh(db); var check = db.StudentDatas.Where(c => c.Class == comboboxclass.Text && c.Section == comboboxsection.Text).FirstOrDefault(); if (check != null) { foreach (var item in db.StudentDatas.Where(c => c.Class == comboboxclass.Text && c.Section == comboboxsection.Text)) { IDarrayList.Add(item.ID); } var cls = db.Randoms.Where(c => c.ID == 6).FirstOrDefault(); var clasarray = cls.Text.Split(','); for (int i = 0; i <= clasarray.Length - 1; i++) { if (comboboxclass.Text == clasarray[i]) { index = i; break; } } currentclass = clasarray[index].ToString(); if (clasarray.Length > (index + 1)) { nextclass = clasarray[index + 1].ToString(); } var fee = db.Randoms.Where(x => x.ID == 8).FirstOrDefault(); var feearray = fee.Text.Split(';'); var feearray1 = feearray[index + 1].ToString().Split(','); string fees = feearray1[0].ToString() + "," + feearray1[0].ToString() + "," + feearray1[0].ToString() + "," + feearray1[0].ToString() + "," + feearray1[0].ToString() + "," + feearray1[0].ToString() + "," + feearray1[0].ToString() + "," + feearray1[0].ToString() + "," + feearray1[0].ToString() + "," + feearray1[0].ToString() + "," + feearray1[0].ToString() + "," + feearray1[0].ToString(); for (int i = 0; i <= IDarrayList.ToArray().Length - 1; i++) { int id = Convert.ToInt32(IDarrayList[i].ToString()); var data = db.StudentDatas.Where(c => c.ID == id).FirstOrDefault(); var stdfee = db.StudentFees.Where(c => c.ID == id).FirstOrDefault(); data.Class = nextclass; data.Fees = fees; stdfee.ExamFee = Convert.ToInt32(feearray1[1].ToString()); db.Entry(data).State = System.Data.Entity.EntityState.Modified; db.Entry(stdfee).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); MessageBox.Show("Report of class: " + comboboxclass.Text + " " + comboboxsection.Text + " submitted successfully!", "Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { MessageBox.Show("Sorry! No record found with this class!", "Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show("An Error Occured: " + ex.Message.ToString(), "Student Management System", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void AnnualReport_Activated(object sender, EventArgs e) { DbEntityRefresh.Refresh(db); }