private void btnsave_Click(object sender, EventArgs e)
{
if (txtstdname.Text != null && txtstdname.Text != "" && txtathername.Text != null && txtathername.Text != "" && txtregno.Text != null && txtregno.Text != "" &&
txtmothername.Text != null && txtmothername.Text != "" && DateofBirthPicker.Text != null && DateofBirthPicker.Text != "" && txtaddress.Text != null && txtaddress.Text != "" &&
txtplaceofbirth.Text != null && txtplaceofbirth.Text != "" && txtcnic.Text != null && txtcnic.Text != "" &&
ComboBoxGender.Text != null && ComboBoxGender.Text != "" && txtreligion.Text != null && txtreligion.Text != "" &&
txtcontact.Text != null && txtcontact.Text != "" && comboboxclass.Text != null && comboboxclass.Text != "" &&
comboboxsection.Text != null && comboboxsection.Text != "" && Admitdatepicker.Text != null && Admitdatepicker.Text != "")
{
try
{
var i = db.StudentDatas.Where(c => c.ID == ModifyStudent.STUDENT_ID).FirstOrDefault();
var j = db.StudentProfiles.Where(d => d.ID == ModifyStudent.STUDENT_ID).FirstOrDefault();
i.StudentName = txtstdname.Text;
i.FatherName = txtathername.Text;
i.RegNo = txtregno.Text;
i.MotherName = txtmothername.Text;
i.DateOfBirth = DateofBirthPicker.Value.ToString();
i.PlaceOfBirth = txtplaceofbirth.Text;
i.Address = txtaddress.Text;
i.NIC = txtcnic.Text;
i.Gender = ComboBoxGender.Text;
i.Religion = txtreligion.Text;
i.Contact = txtcontact.Text;
i.Class = comboboxclass.Text;
i.Section = comboboxsection.Text;
i.AdmitDate = Admitdatepicker.Value.ToString();
if (bimage != null)
{
j.Profile = bimage;
}
db.Entry(i).State = System.Data.Entity.EntityState.Modified;
db.Entry(j).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
catch (Exception ex)
{
MessageBoxAdv.Show(ex.Message.ToString(), "Something Went wrong!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
db.Dispose();
MessageBox.Show("You have successfully updated a new record named as: " + txtstdname.Text, "New record added - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.None);
RESET = true;
this.Hide();
}
}
else
{
MessageBox.Show("All fields are mandatory!", "Error - Student Management Sytem", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnsave_Click(object sender, EventArgs e)
{
if (txtstdname.Text != null && txtstdname.Text != "" && txtathername.Text != null && txtathername.Text != "" && txtregno.Text != null && txtregno.Text != "" &&
txtmothername.Text != null && txtmothername.Text != "" && DateofBirthPicker.Text != null && DateofBirthPicker.Text != "" && txtaddress.Text != null && txtaddress.Text != "" &&
txtplaceofbirth.Text != null && txtplaceofbirth.Text != "" && txtcnic.Text != null && txtcnic.Text != "" &&
ComboBoxGender.Text != null && ComboBoxGender.Text != "" && txtreligion.Text != null && txtreligion.Text != "" &&
txtcontact.Text != null && txtcontact.Text != "" && comboboxclass.Text != null && comboboxclass.Text != "" &&
comboboxsection.Text != null && comboboxsection.Text != "" && Admitdatepicker.Text != null && Admitdatepicker.Text != "")
{
try
{
var data = db.Randoms.Where(x => x.ID == 6).FirstOrDefault();
ArrayList arrayList = new ArrayList();
arrayList.AddRange(data.Text.Split(','));
bool classcheck = false;
for (int i = 0; i <= arrayList.ToArray().Length - 1; i++)
{
if (comboboxclass.Text == arrayList[i].ToString())
{
classcheck = true;
}
}
if (classcheck)
{
int index = 0;
for (int x = 0; x <= arrayList.ToArray().Length - 1; x++)
{
if (comboboxclass.Text == arrayList[x].ToString())
{
index = x;
break;
}
}
var othersfee = db.Randoms.Where(x => x.ID == 10).FirstOrDefault();
var latefee = db.Randoms.Where(x => x.ID == 11).FirstOrDefault();
var fee = db.Randoms.Where(x => x.ID == 8).FirstOrDefault();
var feearray = fee.Text.Split(';');
var feearray1 = feearray[index].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();
DateTime dob = Convert.ToDateTime(DateofBirthPicker.Value);
DateTime admit = Convert.ToDateTime(Admitdatepicker.Value);
var i = db.StudentDatas.Where(c => c.ID == ModifyStudent.STUDENT_ID).FirstOrDefault();
var j = db.StudentProfiles.Where(d => d.ID == ModifyStudent.STUDENT_ID).FirstOrDefault();
var k = db.StudentFees.Where(c => c.ID == ModifyStudent.STUDENT_ID).FirstOrDefault();
i.StudentName = txtstdname.Text;
i.FatherName = txtathername.Text;
i.RegNo = txtregno.Text;
i.MotherName = txtmothername.Text;
i.DateOfBirth = dob.ToString("dd/MM/yyyy");
i.PlaceOfBirth = txtplaceofbirth.Text;
i.Address = txtaddress.Text;
i.NIC = txtcnic.Text;
i.Gender = ComboBoxGender.Text;
i.Religion = txtreligion.Text;
i.Contact = txtcontact.Text;
i.Class = comboboxclass.Text;
i.Section = comboboxsection.Text;
i.AdmitDate = admit.ToString("dd/MM/yyyy");
i.Fees = fees;
if (bimage != null)
{
j.Profile = bimage;
}
k.ExamFee = Convert.ToInt32(feearray1[1].ToString());
db.Entry(i).State = System.Data.Entity.EntityState.Modified;
db.Entry(j).State = System.Data.Entity.EntityState.Modified;
db.Entry(k).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
}
}
catch (Exception ex)
{
MessageBoxAdv.Show(ex.Message.ToString(), "Something Went wrong!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
db.Dispose();
MessageBox.Show("You have successfully updated a new record named as: " + txtstdname.Text, "New record added - Student Management System", MessageBoxButtons.OK, MessageBoxIcon.None);
RESET = true;
this.Hide();
}
}
else
{
MessageBox.Show("All fields are mandatory!", "Error - Student Management Sytem", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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();
}
}