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 generate_marks_list(string batch, string exam) { using (proadmin_v1Entities db = new proadmin_v1Entities()) { var selectedStudents = db.basicdata_student.Where(i => i.Batch == batch).ToList(); foreach (basicdata_student student in selectedStudents) { model_results.subject_1 = 0; model_results.subject_2 = 0; model_results.subject_3 = 0; model_results.English = 0; model_results.git = 0; model_results.total_marks = 0; model_results.average_marks = 0; model_results.avg_state = ""; model_results.regid = student.regid; model_results.exam = exam; model_results.batch = batch; model_results.exam_date = dtpstartdate.Text; db.data_examresults.Add(model_results); db.SaveChanges(); } } }
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 generate_attandance_records() { using (proadmin_v1Entities db = new proadmin_v1Entities()) { var selectedStudents = db.basicdata_student.Where(i => i.Batch == cmbbatch.Text).ToList(); foreach (basicdata_student student in selectedStudents) { model_attandance.classdate = txtdate.Text; model_attandance.attandance = "Not Attend"; model_attandance.batch = cmbbatch.Text; model_attandance.intime = "0"; model_attandance.regid = student.regid; db.data_attandance.Add(model_attandance); db.SaveChanges(); } } }
private void generate_payment_records() { using (proadmin_v1Entities db = new proadmin_v1Entities()) { var selectedStudents = db.basicdata_student.Where(i => i.Batch == cmbbatch.Text && i.Scholarship == "NO").ToList(); foreach (basicdata_student student in selectedStudents) { model_feedata.amount = "0"; model_feedata.batch = cmbbatch.Text; model_feedata.feeschedule = txtmonth.Text; model_feedata.payment = "Not Paid"; model_feedata.payment_date = ""; model_feedata.regid = student.regid; model_feedata.year = txtyear.Text; db.data_feecollection.Add(model_feedata); db.SaveChanges(); } } }