public ActionResult Edit([Bind(Include = "id,name,phone,email,address,logo")] tbldetail tbldetail, HttpPostedFileBase file, Helper Help) { if (ModelState.IsValid) { tbldetail.logo = file != null?Help.uploadfile(file) : img; #region delete file string fullPath = Request.MapPath("~/UploadedFiles/" + img); if (img == tbldetail.logo) { } else { if (System.IO.File.Exists(fullPath)) { System.IO.File.Delete(fullPath); } } #endregion db.Entry(tbldetail).State = EntityState.Modified; db.SaveChanges(); TempData["Success"] = "Updated Successfully"; return(RedirectToAction("Index")); } return(View(tbldetail)); }
public tbldetail CompanyName() { int per = Convert.ToInt32(Permission()); tbldetail rr = db.tbldetails.Where(x => x.franchid == per).FirstOrDefault(); return(rr); }
public ActionResult Create([Bind(Include = "id,name,phone,email,address,logo")] tbldetail tbldetail, HttpPostedFileBase file, Helper Help) { if (ModelState.IsValid) { tbldetail.logo = Help.uploadfile(file); db.tbldetails.Add(tbldetail); db.SaveChanges(); TempData["Success"] = "Saved Successfully"; return(RedirectToAction("Index")); } return(View(tbldetail)); }
// GET: Auth/OurDetail/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbldetail tbldetail = db.tbldetails.Find(id); if (tbldetail == null) { return(HttpNotFound()); } return(View(tbldetail)); }
public ActionResult Login(tblreceptionist model, string returnUrl, Helper Help, string ddltype) { dbcontext db = new dbcontext(); var otp = Help.otp(); tblreceptionist rr = db.tblreceptionists.FirstOrDefault(x => x.rid == model.rid); tbldetail dd = db.tbldetails.FirstOrDefault(); Help.sendsms(rr.contact, "Dear, " + rr.name + ". Login OTP Is " + otp + " "); tblreceptionist data = new tblreceptionist() { Type = ddltype, rid = model.rid, OTP = Convert.ToInt32(otp) }; Session["mydata"] = data; return(RedirectToAction("OTP", "Accounts")); }
public ActionResult DeleteConfirmed(int id) { tbldetail tbldetail = db.tbldetails.Find(id); img = tbldetail.logo; #region delete file string fullPath = Request.MapPath("~/UploadedFiles/" + img); if (img == tbldetail.logo) { } else { if (System.IO.File.Exists(fullPath)) { System.IO.File.Delete(fullPath); } } #endregion db.tbldetails.Remove(tbldetail); 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,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; } } }