public ActionResult DeleteConfirmed(int id) { using (DbContextTransaction dbTran = db.Database.BeginTransaction()) { try { string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist(); StudentCourse student_Course = db.StudentCourses.Find(id); Fees_Master feemaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == student_Course.RollNo && x.franchid == a && x.CourseId == student_Course.CourseId); db.Fees_Master.Remove(feemaster); db.SaveChanges(); db.StudentCourses.Remove(student_Course); db.SaveChanges(); dbTran.Commit(); TempData["Success"] = "Deleted Successfully"; return(RedirectToAction("Index", new { roll = rollno })); } catch (Exception) { dbTran.Rollback(); return(RedirectToAction("Index", new { roll = rollno })); throw; } } }
public ActionResult Create(int Amount, int Discount, int CourseId, DateTime Alert, DateTime date, Recipt_Details receiptdetail) { try { // TODO: Add insert logic here Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == rollno); feesmaster.discount = (Convert.ToInt32(feesmaster.discount) + Convert.ToInt32(Discount)); feesmaster.Date = date; feesmaster.AlertDate = Alert; feesmaster.PaidFees += Amount; feesmaster.Status = true; db.Entry(feesmaster).State = EntityState.Modified; db.SaveChanges(); receiptdetail.RollNo = rollno; receiptdetail.ReciptNo = receiptno; receiptdetail.CourseId = CourseId; receiptdetail.Date = date; receiptdetail.Amount = Amount; receiptdetail.Active = true; db.Recipt_Details.Add(receiptdetail); db.SaveChanges(); TempData["Success"] = "Saved Successfully"; return(RedirectToAction("invoice", new { id = receiptno })); } catch { return(View()); } }
public ActionResult Edit([Bind(Include = "Id,CourseId,Admitdate,enddate,Fees,RoomId,Status,Days,Token")] StudentCourse student_Course) { if (ModelState.IsValid) { string a = help.Permission(); Course cc = db.Courses.First(x => x.CourseId == student_Course.CourseId && x.franchid == a); student_Course.RollNo = rollno; student_Course.Uid = a; student_Course.enddate = Convert.ToDateTime(student_Course.Admitdate).AddDays(student_Course.Days); student_Course.Fees = (Convert.ToInt32(cc.Fees) * Convert.ToInt32(student_Course.Days)).ToString(); db.Entry(student_Course).State = EntityState.Modified; db.SaveChanges(); Fees_Master feemaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == rollno && x.franchid == a && x.Token == student_Course.Token && x.Status == true); //feemaster.RollNo = student_Course.RollNo; feemaster.Date = System.DateTime.Now; feemaster.CourseId = student_Course.CourseId; feemaster.AlertDate = System.DateTime.Now.AddDays(2); feemaster.Status = true; feemaster.TotalFees = (Convert.ToInt32(cc.Fees) * Convert.ToInt32(student_Course.Days)); // feemaster.TotalFees += Convert.ToInt32(student_Course.Fees); db.Entry(feemaster).State = EntityState.Modified; db.SaveChanges(); TempData["Success"] = "Updated Successfully"; ViewBag.CourseId = new SelectList(db.Courses.Where(x => x.franchid == a), "CourseId", "CourseName"); return(RedirectToAction("Index", new { roll = rollno })); } return(View(student_Course)); }
public ActionResult DeleteConfirmed(int id) { if (User.IsInRole("Receptionist")) { roles = help.Receptionist(); } else { roles = help.Franchisee(); } tblstudentdata tblstudentdata = db.tblstudentdata.Find(id); int roll = tblstudentdata.rollno; ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName"); img = tblstudentdata.image; if (tblstudentdata.password != null) { tblstudentdata.password = help.DecryptData(tblstudentdata.password); } #region delete file string fullPath = Request.MapPath("~/UploadedFiles/" + img); if (img == tblstudentdata.image) { } else { if (System.IO.File.Exists(fullPath)) { System.IO.File.Delete(fullPath); } } #endregion db.tblstudentdata.Remove(tblstudentdata); db.SaveChanges(); Fees_Master feemaster = new Fees_Master(); feemaster = db.Fees_Master.Where(x => x.RollNo == roll && x.franchid == roles).FirstOrDefault(); if (feemaster != null) { db.Fees_Master.Remove(feemaster); db.SaveChanges(); } StudentCourse studentcourse = new StudentCourse(); studentcourse = db.StudentCourses.Where(x => x.RollNo == roll && x.Uid == roles).FirstOrDefault(); if (studentcourse != null) { db.StudentCourses.Remove(studentcourse); db.SaveChanges(); } Recipt_Details rr = db.Recipt_Details.Where(x => x.RollNo == roll && x.franchid == roles).FirstOrDefault(); if (rr != null) { db.Recipt_Details.Remove(rr); db.SaveChanges(); } TempData["Success"] = "Deleted Successfully"; return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "Id,rollno,name,dob,fathername,address,phone,fatherphn,language,board,qualification,coaching,institutename,type,refferedby,image,uid,Status,username,password,gender,remarks,email,discount,date")] tblstudentdata tblstudentdata, HttpPostedFileBase file, Helper Help, DateTime joining, DateTime enddate, string addmission, int CourseId, int RoomId) { if (ModelState.IsValid) { tblstudentdata studentdata = db.tblstudentdata.FirstOrDefault(); if (studentdata == null) { tblstudentdata.rollno = 1; } else { var ab = db.tblstudentdata.Max(x => x.rollno); tblstudentdata.rollno = Convert.ToInt32(ab) + 1; } tblstudentdata.uid = User.Identity.Name; tblstudentdata.image = Help.uploadfile(file); if (tblstudentdata.password != null) { tblstudentdata.password = Help.EncryptData(tblstudentdata.password); } db.tblstudentdata.Add(tblstudentdata); db.SaveChanges(); //Recipt_Details receiptdetail = new Recipt_Details(); //receiptdetail.RollNo = tblstudentdata.rollno; Fees_Master feemaster = new Fees_Master(); feemaster.RollNo = tblstudentdata.rollno; feemaster.Date = tblstudentdata.date; //feemaster.CourseId = CourseId; feemaster.AlertDate = System.DateTime.Now.AddDays(2); feemaster.discount = tblstudentdata.discount; feemaster.Status = tblstudentdata.Status; feemaster.TotalFees = Convert.ToInt32(addmission); db.Fees_Master.Add(feemaster); db.SaveChanges(); StudentCourse studentcourse = new StudentCourse(); studentcourse.RollNo = tblstudentdata.rollno; studentcourse.RoomId = RoomId; studentcourse.CourseId = CourseId; studentcourse.Admitdate = joining; studentcourse.enddate = enddate; studentcourse.Fees = addmission; studentcourse.Uid = Session["User"].ToString(); studentcourse.Status = tblstudentdata.Status; db.StudentCourses.Add(studentcourse); db.SaveChanges(); TempData["Success"] = "Saved Successfully"; return(RedirectToAction("Index")); } return(View(tblstudentdata)); }
public ActionResult DeleteConfirmed(int id) { Recipt_Details receiptdetail = db.Recipt_Details.Find(id); db.Recipt_Details.Remove(receiptdetail); db.SaveChanges(); Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == receiptdetail.RollNo && x.CourseId == receiptdetail.CourseId && x.Status == true && x.franchid == receiptdetail.franchid); feesmaster.PaidFees = (Convert.ToInt32(feesmaster.PaidFees) - Convert.ToInt32(receiptdetail.Amount)); db.Entry(feesmaster).State = EntityState.Modified; db.SaveChanges(); TempData["Success"] = "Deleted Successfully"; return(RedirectToAction("Index", new { roll = receiptdetail.RollNo })); }
public ActionResult DeleteConfirmed(int id) { Recipt_Details receiptdetail = db.Recipt_Details.Find(id); db.Recipt_Details.Remove(receiptdetail); db.SaveChanges(); Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == receiptdetail.RollNo); feesmaster.PaidFees = feesmaster.PaidFees - receiptdetail.Amount; db.Entry(feesmaster).State = EntityState.Modified; db.SaveChanges(); TempData["Success"] = "Deleted Successfully"; return(RedirectToAction("Index", new { roll = receiptdetail.RollNo })); }
public ActionResult SMS(int id, Helper Help) { tblstudentdata ss = db.tblstudentdata.FirstOrDefault(x => x.rollno == id); Fees_Master fm = db.Fees_Master.FirstOrDefault(x => x.RollNo == id); tblsms sms = db.tblsms.FirstOrDefault(); float pending = fm.TotalFees - fm.PaidFees; if (ss.phone != null) { string msg = "Dear, " + Convert.ToString(ss.name) + ". Reminder That Your Course Fee is still Due Rs." + pending + ". Thanks for Joining Us. visit www.englishtreemoga.com."; string result = Help.apicall("http://sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + ss.phone + "&apikey=" + sms.Api + ""); TempData["Success"] = "SMS Send Successfully"; } return(RedirectToAction("Index")); }
public ActionResult AddDays(StudentCourse course) { string a = help.Permission(); StudentCourse ss = db.StudentCourses.FirstOrDefault(x => x.Token == course.Token && x.Uid == a && x.Status == true); Course cc = db.Courses.FirstOrDefault(x => x.CourseId == ss.CourseId && x.franchid == a); string daysfee = (Convert.ToInt32(course.Days) * Convert.ToInt32(cc.Fees)).ToString(); string fee = (Convert.ToInt32(ss.Fees) + Convert.ToInt32(daysfee)).ToString(); ss.Fees = fee; ss.enddate = Convert.ToDateTime(ss.enddate).AddDays(course.Days); db.Entry(ss).State = EntityState.Modified; db.SaveChanges(); Fees_Master fm = db.Fees_Master.FirstOrDefault(x => x.Token == course.Token && x.franchid == a && x.Status == true); fm.TotalFees = Convert.ToInt32(fee); fm.AlertDate = System.DateTime.Now.AddDays(2); db.Entry(fm).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("CourseFinishAlert", "Default")); }
public ActionResult Edit([Bind(Include = "Id,rollno,name,dob,fathername,address,phone,fatherphn,language,board,qualification,coaching,institutename,type,refferedby,image,uid,Status,username,password,gender,remarks,email,discount,date")] tblstudentdata tblstudentdata, HttpPostedFileBase file, Helper Help) { if (ModelState.IsValid) { tblstudentdata.image = file != null?Help.uploadfile(file) : img; if (tblstudentdata.password != null) { tblstudentdata.password = Help.EncryptData(tblstudentdata.password); } #region delete file string fullPath = Request.MapPath("~/UploadedFiles/" + img); if (img == tblstudentdata.image) { } else { if (System.IO.File.Exists(fullPath)) { System.IO.File.Delete(fullPath); } } #endregion db.Entry(tblstudentdata).State = EntityState.Modified; db.SaveChanges(); Fees_Master feemaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == tblstudentdata.rollno); feemaster.Status = tblstudentdata.Status; db.Entry(feemaster).State = EntityState.Modified; db.SaveChanges(); StudentCourse studentcourse = db.StudentCourses.FirstOrDefault(x => x.RollNo == tblstudentdata.rollno); studentcourse.Status = tblstudentdata.Status; db.Entry(studentcourse).State = EntityState.Modified; db.SaveChanges(); TempData["Success"] = "Updated Successfully"; return(RedirectToAction("Index")); } return(View(tblstudentdata)); }
public ActionResult DeleteConfirmed(int id) { StudentCourse student_Course = db.StudentCourses.Find(id); rollno = student_Course.RollNo; db.StudentCourses.Remove(student_Course); db.SaveChanges(); Fees_Master feemaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == student_Course.RollNo); feemaster.RollNo = student_Course.RollNo; feemaster.Date = System.DateTime.Now; //feemaster.CourseId = student_Course.CourseId; feemaster.AlertDate = System.DateTime.Now.AddDays(2); feemaster.Status = true; feemaster.TotalFees -= Convert.ToInt32(student_Course.Fees); db.Entry(feemaster).State = EntityState.Modified; db.SaveChanges(); TempData["Success"] = "Deleted Successfully"; return(RedirectToAction("Index", new { roll = rollno })); }
public ActionResult Edit([Bind(Include = "Id,RollNo,CourseId,Admitdate,enddate,Fees,Uid,RoomId,Status")] StudentCourse student_Course) { if (ModelState.IsValid) { student_Course.RollNo = rollno; student_Course.Uid = Session["User"].ToString(); db.Entry(student_Course).State = EntityState.Modified; db.SaveChanges(); Fees_Master feemaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == student_Course.RollNo); feemaster.RollNo = student_Course.RollNo; feemaster.Date = System.DateTime.Now; //feemaster.CourseId = student_Course.CourseId; feemaster.AlertDate = System.DateTime.Now.AddDays(2); feemaster.Status = true; feemaster.TotalFees += Convert.ToInt32(student_Course.Fees); db.Entry(feemaster).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", new { roll = rollno })); } return(View(student_Course)); }
public ActionResult Create([Bind(Include = "Id,rollno,name,dob,fathername,address,phone,fatherphn,language,board,qualification,coaching,institutename,type,refferedby,image,uid,Status,username,password,gender,remarks,email,discount,date,Time,UserId,Material,By")] tblstudentdata tblstudentdata, HttpPostedFileBase file, Helper Help, [Bind(Include = "CourseId,AdmitDate,Fees,enddate,Days,FixedFee,Reason")] StudentCourse scourse, int CourseId) { using (var transaction = db.Database.BeginTransaction()) { try { if (ModelState.IsValid) { if (User.IsInRole("Receptionists")) { DataTable dd2 = objsql.GetTable("select * from tblstudentdatas where name='" + tblstudentdata.name + "' and fathername='" + tblstudentdata.fathername + "' and phone='" + tblstudentdata.phone + "'"); if (dd2.Rows.Count > 0) { goto xx; } else { transaction.Rollback(); TempData["danger"] = "Student Not Exist"; return(View()); } } xx: scourse.CourseId = CourseId; Course co = db.Courses.FirstOrDefault(x => x.CourseId == scourse.CourseId); int alter = Convert.ToInt32(co.Days); string a = help.Permission(); StudentCourse studentcourse = new StudentCourse(); #region insert student table tblstudentdata studentdata = db.tblstudentdata.FirstOrDefault(x => x.uid == a && x.Status == true); #region Create Rollno if (studentdata == null) { tblstudentdata.rollno = 1; } else { var ab = db.tblstudentdata.Where(x => x.uid == a).Max(x => x.rollno); tblstudentdata.rollno = Convert.ToInt32(ab) + 1; } #endregion tblstudentdata.uid = help.Permission(); //franchid Detail tblstudentdata.image = Help.uploadfile(file); tblstudentdata.role = HttpContext.User.Identity.Name; db.tblstudentdata.Add(tblstudentdata); db.SaveChanges(); #endregion #region Insert Fee table and studentcourse var token = db.Fees_Master.Where(x => x.franchid == a && x.Status == true).Max(x => x.Token); if (token != null) { if (scourse.FixedFee == 0) { studentcourse.FixedFee = studentcourse.FixedFee; } else { if (scourse.Reason == null) { TempData["danger"] = "Please Update Reason"; transaction.Rollback(); ViewBag.CourseId = new SelectList(db.Courses.Where(x => x.franchid == a), "CourseId", "CourseName", scourse.CourseId); ViewBag.UserId = new SelectList(db.tblreceptionists.Where(x => x.franchid == a && x.Type == "Teacher"), "Id", "Name", studentdata.UserId); ViewBag.Time = new SelectList(db.Timings.Where(x => x.franchid == a), "Tid", "BatchTime", studentdata.Time); return(View(tblstudentdata)); } studentcourse.FixedFee = scourse.FixedFee; studentcourse.Reason = scourse.Reason; } token += 1; Fees_Master feemaster = new Fees_Master(); feemaster.RollNo = tblstudentdata.rollno; feemaster.role = HttpContext.User.Identity.Name; feemaster.Date = tblstudentdata.date; feemaster.CourseId = scourse.CourseId; //feemaster.CourseId = CourseId; feemaster.AlertDate = System.DateTime.Now.AddDays(alter); feemaster.discount = tblstudentdata.discount; feemaster.Status = tblstudentdata.Status; feemaster.TotalFees = Convert.ToInt32(scourse.Fees); feemaster.franchid = help.Permission(); feemaster.Token = token; db.Fees_Master.Add(feemaster); db.SaveChanges(); studentcourse.RollNo = tblstudentdata.rollno; studentcourse.CourseId = scourse.CourseId; studentcourse.Admitdate = studentdata.date; studentcourse.enddate = Convert.ToDateTime(studentdata.date).AddDays(Convert.ToInt32(co.Days)); studentcourse.Fees = Convert.ToInt32(scourse.Fees).ToString(); studentcourse.Uid = help.Permission(); studentcourse.Token = token; studentcourse.role = HttpContext.User.Identity.Name; studentcourse.Status = tblstudentdata.Status; db.StudentCourses.Add(studentcourse); db.SaveChanges(); } else { token = 1; if (studentcourse.FixedFee != 0) { studentcourse.FixedFee = studentcourse.FixedFee; } else { if (studentcourse.Reason == null) { TempData["danger"] = "Please Update Reason"; transaction.Rollback(); ViewBag.CourseId = new SelectList(db.Courses.Where(x => x.franchid == a), "CourseId", "CourseName", scourse.CourseId); return(View(tblstudentdata)); } } Fees_Master feemaster = new Fees_Master(); feemaster.RollNo = tblstudentdata.rollno; feemaster.Date = tblstudentdata.date; feemaster.CourseId = scourse.CourseId; feemaster.role = HttpContext.User.Identity.Name; //feemaster.CourseId = CourseId; feemaster.AlertDate = System.DateTime.Now.AddDays(alter); feemaster.discount = tblstudentdata.discount; feemaster.Status = tblstudentdata.Status; feemaster.TotalFees = Convert.ToInt32(scourse.Fees); feemaster.franchid = help.Permission(); feemaster.Token = token; db.Fees_Master.Add(feemaster); db.SaveChanges(); studentcourse.RollNo = tblstudentdata.rollno; studentcourse.CourseId = scourse.CourseId; studentcourse.Admitdate = studentdata.date; studentcourse.role = HttpContext.User.Identity.Name; studentcourse.enddate = Convert.ToDateTime(studentdata.date).AddDays(Convert.ToInt32(co.Days)); studentcourse.Fees = Convert.ToInt32(scourse.Fees).ToString(); studentcourse.Uid = help.Permission(); studentcourse.Token = token; studentcourse.Status = tblstudentdata.Status; db.StudentCourses.Add(studentcourse); db.SaveChanges(); } #endregion #region Send Message To Student tbldetail dd = db.tbldetails.FirstOrDefault(); // help.sendsms(studentdata.phone, "Dear " + Convert.ToString(tblstudentdata.name) + ". Welcome to " + dd.name + " . Your Course EndDate is (" + Convert.ToString(studentcourse.enddate) + "). Thanks for Joining Us."); TempData["Success"] = "Saved Successfully"; ViewBag.CourseId = new SelectList(db.Courses.Where(x => x.franchid == help.Permission()), "CourseId", "CourseName", scourse.CourseId); // ViewBag.UserId = new SelectList(db.tblreceptionists.Where(x => x.franchid == help.Permission() && x.Type == "Teacher"), "Id", "Name", studentdata.UserId); // ViewBag.Time = new SelectList(db.Timings.Where(x => x.franchid == help.Permission()), "Tid", "BatchTime", studentdata.Time); transaction.Commit(); return(RedirectToAction("Index")); #endregion } return(View(tblstudentdata)); } catch (Exception e) { var mesaage = e.Message; transaction.Rollback(); TempData["danger"] = "Error Occur ! " + mesaage; throw; } } }
public ActionResult Create([Bind(Include = "Type")] Recipt_Details receiptdetail, int Amount, int Discount, int CourseId, DateTime?Alert, DateTime date, Helper Help) { using (TransactionScope ts = new TransactionScope()) { try { DateTime today = System.DateTime.Now; DataTable dt = objsql.GetTable("select * from expenselocks where lockdate='" + today + "'"); if (dt.Rows.Count > 0) { TempData["danger"] = "Sorry DayEnd"; return(View()); } else { string franchid = help.Permission(); tblreceptionist re = db.tblreceptionists.FirstOrDefault(x => x.rid == franchid); if (re.StartTime != null || re.EndTime != null) { if (help.Checklock() == true) { #region data string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist(); // TODO: Add insert logic here Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == rollno && x.franchid == a && x.Status == true && x.CourseId == CourseId); int pending = (Convert.ToInt32(feesmaster.TotalFees) - Convert.ToInt32(feesmaster.PaidFees)); if (feesmaster.PaidFees < feesmaster.TotalFees) { #region condition greater than feesmaster.discount = (Convert.ToInt32(feesmaster.discount) + Convert.ToInt32(Discount)); feesmaster.Date = date; feesmaster.AlertDate = Alert; feesmaster.PaidFees += Amount; feesmaster.Status = true; db.Entry(feesmaster).State = EntityState.Modified; db.SaveChanges(); receiptdetail.RollNo = rollno; receiptdetail.ReciptNo = receiptno; receiptdetail.discount = Discount; receiptdetail.CourseId = CourseId; receiptdetail.Date = date; receiptdetail.role = HttpContext.User.Identity.Name; receiptdetail.Amount = Amount; receiptdetail.Active = true; receiptdetail.franchid = User.IsInRole("Franchisee") ? Help.Franchisee() : Help.Receptionist(); db.Recipt_Details.Add(receiptdetail); db.SaveChanges(); TempData["roll"] = rollno; ViewData["Receipt"] = recp1; TempData["Success"] = "Saved Successfully"; tblsms sms = db.tblsms.FirstOrDefault(); tblstudentdata ss = db.tblstudentdata.FirstOrDefault(x => x.rollno == rollno); if (ss.phone != null) { if (sms != null) { string msg = "Dear, " + Convert.ToString(ss.name) + ". Thank You for Deposit Rs." + Amount + ". Thanks for Joining Us."; string result = Help.apicall("http://sms.sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + ss.phone + "&apikey=" + sms.Api + ""); } TempData["Success"] = "SMS Send Successfully"; } StudentCourse course = db.StudentCourses.Where(x => x.RollNo == rollno && x.Status == true).FirstOrDefault(); var courses = db.Courses.Where(x => x.CourseId == course.CourseId); ViewBag.CourseId = new SelectList(courses, "CourseId", "CourseName"); ts.Complete(); ts.Dispose(); return(RedirectToAction("invoice", new { id = receiptno })); #endregion } else { TempData["danger"] = "Please Check Amount First"; return(View()); } #endregion } else { TempData["danger"] = "Sorry DayEnd"; return(View()); } } else { #region data string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist(); // TODO: Add insert logic here Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == rollno && x.franchid == a && x.Status == true && x.CourseId == CourseId); int pending = (Convert.ToInt32(feesmaster.TotalFees) - Convert.ToInt32(feesmaster.PaidFees)); if (feesmaster.PaidFees < feesmaster.TotalFees) { #region condition greater than feesmaster.discount = (Convert.ToInt32(feesmaster.discount) + Convert.ToInt32(Discount)); feesmaster.Date = date; feesmaster.AlertDate = Alert; feesmaster.PaidFees += Amount; feesmaster.Status = true; db.Entry(feesmaster).State = EntityState.Modified; db.SaveChanges(); receiptdetail.RollNo = rollno; receiptdetail.ReciptNo = receiptno; receiptdetail.discount = Discount; receiptdetail.CourseId = CourseId; receiptdetail.Date = date; receiptdetail.Amount = Amount; receiptdetail.Active = true; receiptdetail.franchid = User.IsInRole("Franchisee") ? Help.Franchisee() : Help.Receptionist(); db.Recipt_Details.Add(receiptdetail); db.SaveChanges(); TempData["roll"] = rollno; ViewData["Receipt"] = recp1; TempData["Success"] = "Saved Successfully"; tblsms sms = db.tblsms.FirstOrDefault(); tblstudentdata ss = db.tblstudentdata.FirstOrDefault(x => x.rollno == rollno); if (ss.phone != null) { if (sms != null) { string msg = "Dear " + Convert.ToString(ss.name) + ". Thank You for Deposit Rs." + Amount + ". Thanks for Joining Us."; string result = Help.apicall("http://sms.sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + ss.phone + "&apikey=" + sms.Api + ""); } TempData["Success"] = "SMS Send Successfully"; } StudentCourse course = db.StudentCourses.Where(x => x.RollNo == rollno && x.Status == true).FirstOrDefault(); var courses = db.Courses.Where(x => x.CourseId == course.CourseId); ViewBag.CourseId = new SelectList(courses, "CourseId", "CourseName"); ts.Complete(); ts.Dispose(); return(RedirectToAction("invoice", new { id = receiptno })); #endregion } else { TempData["danger"] = "Please Check Amount First"; return(View()); } #endregion } } } catch (Exception a) { return(View()); } } }
public ActionResult Create([Bind(Include = "Id,RollNo,CourseId,Admitdate,enddate,Fees,Uid,RoomId,Status,Days")] StudentCourse student_Course) { if (ModelState.IsValid) { using (DbContextTransaction dbTran = db.Database.BeginTransaction()) { string a = help.Permission(); try { //StudentCourse sc = db.StudentCourses.FirstOrDefault(x => x.CourseId == student_Course.CourseId && x.RollNo == rollno && x.Uid == a); //Fees_Master fm = db.Fees_Master.FirstOrDefault(x => x.CourseId == student_Course.CourseId && x.RollNo == rollno && x.franchid == a); //if (sc!=null) //{ // objsql.ExecuteNonQuery("update studentcourses set status='0' where id='" + sc.Id + "'"); // objsql.ExecuteNonQuery("update fees_master set status='0' where id='" + fm.Id + "'"); //} var token = db.Fees_Master.Where(x => x.franchid == a && x.Status == true).Max(x => x.Token); if (token != null) { token += 1; //string a= User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist(); student_Course.Uid = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist(); student_Course.enddate = Convert.ToDateTime(student_Course.Admitdate).AddDays(student_Course.Days); student_Course.Fees = (Convert.ToInt32(student_Course.Fees)).ToString(); student_Course.RollNo = rollno; student_Course.Token = token; db.StudentCourses.Add(student_Course); db.SaveChanges(); Fees_Master feemaster1 = new Fees_Master(); feemaster1.RollNo = student_Course.RollNo; feemaster1.Date = System.DateTime.Now; feemaster1.CourseId = student_Course.CourseId; feemaster1.AlertDate = System.DateTime.Now.AddDays(2); feemaster1.discount = 0; feemaster1.Status = true; feemaster1.TotalFees = int.Parse(student_Course.Fees); feemaster1.franchid = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist(); feemaster1.Token = token; // feemaster.franchid= HttpContext.User.Identity.Name; db.Fees_Master.Add(feemaster1); db.SaveChanges(); dbTran.Commit(); TempData["Success"] = "Saved Successfully"; return(RedirectToAction("Index", new { roll = rollno })); } else { dbTran.Rollback(); TempData["danger"] = "Invalid Token ! Conceren With Developer"; } } catch (Exception) { dbTran.Rollback(); return(RedirectToAction("Index", new { roll = rollno })); throw; } } } return(View(student_Course)); }