private void btndelete_Click(object sender, EventArgs e) { if (XtraMessageBox.Show("Are you sure to delete the record?", "Delete Record", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (proadmin_v1Entities db = new proadmin_v1Entities()) { var entity = db.Entry(model_class); if (entity.State == EntityState.Detached) { db.basicdata_class.Attach(model_class); } db.basicdata_class.Remove(model_class); db.SaveChangesAsync(); btndelete.Enabled = false; if (XtraMessageBox.Show("Do you want to delete all the addtendance for this class shedule too?", "Authentication Required!", MessageBoxButtons.YesNo) == DialogResult.Yes) { var data = db.data_attandance.Where(rec => rec.batch == cmbbatch.Text && rec.classdate == txtdate.Text); db.data_attandance.RemoveRange(data); db.SaveChanges(); } clear_feild(); message_popup_ok("Data Deleted!"); } } }
private void btndelete_Click(object sender, EventArgs e) { if (XtraMessageBox.Show("Are you sure to delete the record?", "Delete Record", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (proadmin_v1Entities db = new proadmin_v1Entities()) { var entity = db.Entry(model_feeschedule); if (entity.State == EntityState.Detached) { db.basicdate_feeschedule.Attach(model_feeschedule); } db.basicdate_feeschedule.Remove(model_feeschedule); db.SaveChangesAsync(); btndelete.Enabled = false; if (XtraMessageBox.Show("Do you want to delete all the fee records for this shedule too?", "Authentication Required!", MessageBoxButtons.YesNo) == DialogResult.Yes) { var data = db.data_feecollection.Where(rec => rec.batch == cmbbatch.Text && rec.feeschedule == lblmonth.Text); db.data_feecollection.RemoveRange(data); db.SaveChanges(); } clear_feild(); MessageBox.Show("Data Deleted!"); dgvpaymentschedule.DataSource = db.basicdate_feeschedule.Where(data => data.batch == cmbbatch.Text).ToList <basicdate_feeschedule>(); } } }
private void btnsubdelete_Click(object sender, EventArgs e) { if (XtraMessageBox.Show("Are you sure to delete the record?", "Delete Record", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (proadmin_v1Entities db = new proadmin_v1Entities()) { var entity = db.Entry(model_examschedule); if (entity.State == EntityState.Detached) { db.basicdate_schedule.Attach(model_examschedule); } db.basicdate_schedule.Remove(model_examschedule); db.SaveChangesAsync(); populate_examschedule_data_grid_view(); populate_all_examschedule_rich_data_grid_view(); btnsubsave.Text = "Save"; if (XtraMessageBox.Show("Do you want to delete all the Marks for this exam shedule too?", "Authentication Required!", MessageBoxButtons.YesNo) == DialogResult.Yes) { var data = db.data_examresults.Where(rec => rec.exam == txtexam.Text && rec.batch == cmbbatch.Text); db.data_examresults.RemoveRange(data); db.SaveChanges(); } clear_fields(); message_popup_ok("Data Deleted!"); } } }
private void btnfeesave_Click(object sender, EventArgs e) { if (cmbfeebatch.Text != "" || txtfeeamount.Text != "" || cmbfeestate.Text != "") { model_fee.batch_ = cmbfeebatch.Text; model_fee.amount = txtfeeamount.Text; model_fee.state = cmbfeestate.Text; using (proadmin_v1Entities db = new proadmin_v1Entities()) { if (model_fee.id == 0)//Insert { db.basicdate_fee.Add(model_fee); } else //Update { db.Entry(model_fee).State = EntityState.Modified; } db.SaveChangesAsync(); clear_fields(); message_popup_ok("Data Record Saved!"); populate_fee_data_grid_view(); //Reset normal after changes done model_fee.id = 0; btnfeesave.Text = "Save"; } } else { message_popup_ok("Empty fields found."); } }
private void btnsubsave_Click(object sender, EventArgs e) { if (txtsubject.Text != "" || txtteacher.Text != "") { model_subject.subject = txtsubject.Text.Trim(); model_subject.teacher = txtteacher.Text.Trim(); model_subject.log = DateTime.Now.ToString(); using (proadmin_v1Entities db = new proadmin_v1Entities()) { if (model_subject.subid == 0)//Insert { db.basicdata_subject.Add(model_subject); } else //Update { db.Entry(model_subject).State = EntityState.Modified; } db.SaveChangesAsync(); clear_fields(); message_popup_ok("Data Record Saved!"); populate_subject_data_grid_view(); //Reset normal after changes done model_subject.subid = 0; btnsubsave.Text = "Save"; } } else { message_popup_ok("Empty fields found."); } }
private void btnupdate_Click(object sender, EventArgs e) { decimal sub1 = decimal.Parse(txtsubject1.Text); decimal sub2 = decimal.Parse(txtsubject2.Text); decimal sub3 = decimal.Parse(txtsubject3.Text); decimal eng = decimal.Parse(txtenglish.Text); decimal git = decimal.Parse(txtgit.Text); decimal tot = decimal.Parse(txttotal.Text); decimal avg = decimal.Parse(txtaverage.Text); model_results.subject_1 = sub1; model_results.subject_2 = sub2; model_results.subject_3 = sub3; model_results.English = eng; model_results.git = git; model_results.total_marks = tot; model_results.average_marks = avg; model_results.avg_state = txtavgstate.Text; model_results.regid = txtstudentid.Text; model_results.exam = cmbexam.Text; model_results.batch = txtbatch.Text; using (proadmin_v1Entities db = new proadmin_v1Entities()) { if (cmbexam.Text != null) { model_examschedule.exam = cmbexam.Text; model_examschedule = db.basicdate_schedule.Where(x => x.exam == model_examschedule.exam).FirstOrDefault(); model_results.exam_date = model_examschedule.start_date; } else { message_popup_ok("Pleae fill all data fields!"); } if (db.data_examresults.Where(data => data.regid == txtstudentid.Text && data.exam == cmbexam.Text).Any())//Insert { db.Entry(model_results).State = EntityState.Modified; } else //Update { db.data_examresults.Add(model_results); } db.SaveChangesAsync(); message_popup_ok("Data Record Saved!"); } populate_all_student_exam_marks_data(); }
private void btnsubsave_Click(object sender, EventArgs e) { if (txtexam.Text == "" || dtpstartdate.Text == "" || dtpenddate.Text == "" || cmbstate.Text == "" || cmbexamtype.Text == "" || cmbbatch.Text == "") { message_popup_ok("Empty fields found."); } else { string exam = txtexam.Text + '_' + cmbexamtype.Text; model_examschedule.exam = exam; model_examschedule.start_date = dtpstartdate.Text; model_examschedule.end_date = dtpenddate.Text; model_examschedule.state = cmbstate.Text; model_examschedule.exam_type = cmbexamtype.Text; model_examschedule.batch = cmbbatch.Text; using (proadmin_v1Entities db = new proadmin_v1Entities()) { if (model_examschedule.id == 0)//Insert { db.basicdate_schedule.Add(model_examschedule); if (XtraMessageBox.Show("If you created this record, there will be students marks list also generated at the same time. Are you sure you want to shedule an exam?", "Authentication Required!", MessageBoxButtons.YesNo) == DialogResult.Yes) { generate_marks_list(cmbbatch.Text, exam); } } else //Update { db.Entry(model_examschedule).State = EntityState.Modified; } db.SaveChangesAsync(); clear_fields(); message_popup_ok("Data Record Saved!"); populate_examschedule_data_grid_view(); populate_all_examschedule_rich_data_grid_view(); //Reset normal after changes done model_examschedule.id = 0; btnsubsave.Text = "Save"; } } }
private void btnregister_Click(object sender, EventArgs e) { if (txtstudentid.Text != null) { model_student.regid = txtstudentid.Text; using (proadmin_v1Entities db = new proadmin_v1Entities()) { if (db.basicdata_student.Where(data => data.regid == txtstudentid.Text).Any()) { model_student = db.basicdata_student.Where(x => x.regid == model_student.regid).FirstOrDefault(); txtbatch.Text = model_student.Batch; } else { clear(); lblmessage.Text = "Invalid Class Entry.."; } } using (proadmin_v1Entities db = new proadmin_v1Entities()) { model_attandance.intime = DateTime.Now.ToString(); model_attandance.attandance = "Attend"; if (db.data_attandance.Where(data => data.regid == txtstudentid.Text && data.batch == txtbatch.Text && data.classdate == txttoday.Text).Any())//Update attandance { model_attandance = db.data_attandance.Where(x => x.regid == txtstudentid.Text && x.batch == txtbatch.Text && x.classdate == txttoday.Text).FirstOrDefault(); model_attandance.intime = DateTime.Now.ToString(); model_attandance.attandance = "Attend"; db.Entry(model_attandance).State = EntityState.Modified; db.SaveChanges(); lblmessage.Text = "Welcome : " + model_student.Firstname; } else { lblmessage.Text = "Invalid Class Entry.."; } } txtstudentid.Text = null; txtbatch.Text = null; } }
private void btnregister_Click(object sender, EventArgs e) { if (txtstudentid.Text != null) { model_student.regid = txtstudentid.Text; using (proadmin_v1Entities db = new proadmin_v1Entities()) { if (db.basicdata_student.Where(data => data.regid == txtstudentid.Text).Any()) { model_student = db.basicdata_student.Where(x => x.regid == model_student.regid).FirstOrDefault(); batch = model_student.Batch; } else { txtstudentid.Text = null; lblmessage.Text = "Invalid Entry.."; } model_fee = db.basicdate_fee.Where(data => data.batch_ == batch).FirstOrDefault(); amount = model_fee.amount; } using (proadmin_v1Entities db = new proadmin_v1Entities()) { if (db.data_feecollection.Where(data => data.regid == txtstudentid.Text && data.batch == batch && data.feeschedule == txtmonth.Text).Any())//Update attandance { model_feecollection = db.data_feecollection.Where(data => data.regid == txtstudentid.Text && data.batch == batch && data.feeschedule == txtmonth.Text).FirstOrDefault(); model_feecollection.payment = "Paid"; model_feecollection.payment_date = DateTime.Now.ToString(); model_feecollection.amount = amount; db.Entry(model_feecollection).State = EntityState.Modified; db.SaveChanges(); lblmessage.Text = "Payment Colleted for : " + model_student.Firstname; } else { lblmessage.Text = "Invalid Entry.."; } } txtstudentid.Text = null; } }
private void btnSave_Click(object sender, EventArgs e) { if (txtfullname.Text != "" || txtnic.Text != "" || txtemail.Text != "" || txtfullname.Text != "" || txtphone.Text != "" || txtusername.Text != "" || txtpassword.Text != "") { model_users.fullname = txtfullname.Text; model_users.nic = txtnic.Text; model_users.email = txtemail.Text; model_users.phone = Convert.ToInt32(txtphone.Text); model_users.role = cmbrole.SelectedItem.ToString(); model_users.status = cmbstate.SelectedItem.ToString(); model_users.username = txtusername.Text; model_users.password = txtpassword.Text; model_users.log = DateTime.Now.ToString(); using (proadmin_v1Entities db = new proadmin_v1Entities()) { if (model_users.id == 0)//Insert { db.basicdata_users.Add(model_users); } else //Update { db.Entry(model_users).State = EntityState.Modified; } db.SaveChangesAsync(); clear_fields(); message_popup_ok("Data Record Saved!"); populate_users_data_grid_view(); //Reset normal after changes done model_users.id = 0; btnSave.Text = "Save"; } } else { message_popup_ok("Empty fields found."); } }
private void btnDelete_Click(object sender, EventArgs e) { if (XtraMessageBox.Show("Are you sure to delete the record?", "Delete Record", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (proadmin_v1Entities db = new proadmin_v1Entities()) { var entity = db.Entry(model_users); if (entity.State == EntityState.Detached) { db.basicdata_users.Attach(model_users); } db.basicdata_users.Remove(model_users); db.SaveChangesAsync(); populate_users_data_grid_view(); clear_fields(); btnSave.Text = "Save"; message_popup_ok("Data Deleted!"); } } }
private void btnnewsave_Click(object sender, EventArgs e) { int seq_val = 0; using (proadmin_v1Entities db = new proadmin_v1Entities()) { var seq = db.GetNextSequenceValue(); int?nextSequenceValue = seq.Single(); seq_val = nextSequenceValue.Value; } if (txtnewfullname.Text == "" || txtnewlastname.Text == "" || txtnewnic.Text == "" || dtpnewdob.Text == "" || txtnewhomwaddress.Text == "" || txtnewhometell.Text == "" || txtnewfathername.Text == "" || txtnewparentsname.Text == "" || cmbnewolschool.Text == "" || cmbnewalschool.Text == "" || cmbnewbatch.Text == "" || cmbnewscol.Text == "" || cmbnewgender.Text == "" || txtnewstaytell.Text == "" || txtnewstayaddress.Text == "") { message_popup_ok("Empty fields found."); } else { string regid = cmbnewbatch.Text + "01" + seq_val; model_students.regid = regid; model_students.Firstname = txtnewfullname.Text; model_students.Lastname = txtnewlastname.Text; model_students.Nic = txtnewnic.Text; model_students.Dob = dtpnewdob.Text; model_students.home_address = txtnewhomwaddress.Text; model_students.Home_tell = txtnewhometell.Text; model_students.Staying_address = txtnewstayaddress.Text; model_students.Stay_home_tell = txtnewstaytell.Text; model_students.Father_name = txtnewfathername.Text; model_students.Parents_contact = txtnewparentsname.Text; model_students.Ol_School = cmbnewolschool.Text; model_students.Al_school = cmbnewalschool.Text; model_students.Ol_result = txtnewolresult.Text; model_students.JoinDate = txtnewjoiningdate.Text; model_students.Batch = cmbnewbatch.Text; model_students.Gender = cmbnewgender.Text; model_students.Scholarship = cmbnewscol.SelectedItem.ToString(); using (proadmin_v1Entities db = new proadmin_v1Entities()) { if (model_students.Id == 0)//Insert { db.basicdata_student.Add(model_students); } else //Update { db.Entry(model_students).State = EntityState.Modified; } db.SaveChangesAsync(); clear_fields(); message_popup_ok("Data Record Saved!"); populate_student_data_grid_view(); //Reset normal after changes done model_students.Id = 0; btnSave.Text = "Save"; txtmessage.Text = "New Student Reg ID : '" + regid + "'"; txtmessagbarcode.Text = regid; } } }