public JsonResult UpdateCourse(int intId, string strCourse) { try { db = new CourseDataContext(); bool isResult = false; // string Cour = Course.Trim(); if (intId > 0) { SITSPL_tblCourse course = db.SITSPL_tblCourses.Where(x => x.CourseId == intId).SingleOrDefault(); var data = db.SITSPL_tblCourses.Select(x => x.CourseName).ToList(); var alldata = db.SITSPL_tblCourses.Where(x => x.CourseId == intId).Select(x => new { x.CourseId, x.CourseName }).FirstOrDefault(); if (data.Contains(strCourse.Trim(), StringComparer.OrdinalIgnoreCase)) { if (intId == alldata.CourseId && strCourse.ToLower() == alldata.CourseName.ToLower()) { course.CourseName = strCourse; db.SubmitChanges(); isResult = true; return(Json(isResult, JsonRequestBehavior.AllowGet)); } else { isResult = false; return(Json(isResult, JsonRequestBehavior.AllowGet)); } } else { if (!string.IsNullOrEmpty(strCourse.Trim())) { course.CourseName = strCourse; db.SubmitChanges(); isResult = true; return(Json(isResult, JsonRequestBehavior.AllowGet)); } } } return(Json("", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult DeleteCourse(int Id) { try { db = new CourseDataContext(); if (Id > 0) { SITSPL_tblCourse course = db.SITSPL_tblCourses.Where(x => x.CourseId == Id).FirstOrDefault(); if (course != null) { db.SITSPL_tblCourses.DeleteOnSubmit(course); db.SubmitChanges(); return(Json(Id.ToString(), JsonRequestBehavior.AllowGet)); } } return(Json("", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); string str = ex.Message; string err = str.Substring(0, 61); if (err == "The DELETE statement conflicted with the REFERENCE constraint") { return(Json("strcoursedepend", JsonRequestBehavior.AllowGet)); } else { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } // return Json(ex.Message, JsonRequestBehavior.AllowGet); } }
public JsonResult AddReferFriend(tblRefer objRefer) { try { if (objRefer != null) { db = new CourseDataContext(); tblRefer refer = new tblRefer(); refer.EmailReferBy = objRefer.EmailReferBy; refer.ReferBy = objRefer.ReferBy; refer.MobileRefereBy = objRefer.MobileRefereBy; refer.ReferTo = objRefer.ReferTo; refer.EmailReferTo = objRefer.EmailReferTo; refer.MobileReferTo = objRefer.MobileReferTo; refer.DateCreated = DateTime.Now; refer.CreatedBy = objRefer.ReferBy; refer.IsPublished = true; db.tblRefers.InsertOnSubmit(refer); db.SubmitChanges(); Int64 intReferId = refer.ReferId; SendOTPForEnqueryContactFAQ(objRefer.ReferBy, objRefer.EmailReferBy, "Refer", "ReferRes"); return(Json(intReferId, JsonRequestBehavior.AllowGet)); } return(Json("", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult AddForContact(tblContact tblContact) { //return null; try { if (tblContact != null) { if (string.IsNullOrEmpty(tblContact.Name) && string.IsNullOrEmpty(tblContact.Email) && string.IsNullOrEmpty(tblContact.Mobile) && string.IsNullOrEmpty(tblContact.Message) && string.IsNullOrEmpty(tblContact.Country) && string.IsNullOrEmpty(tblContact.Subject)) { return(Json("AllFieldsRequired", JsonRequestBehavior.AllowGet)); } db = new CourseDataContext(); tblContact.DateCreated = DateTime.Now; tblContact.CreatedBy = tblContact.Name; tblContact.IsPublished = true; db.tblContacts.InsertOnSubmit(tblContact); db.SubmitChanges(); SendOTPForEnqueryContactFAQ(tblContact.Name, tblContact.Email, "Contact", "ContactRes"); return(Json(tblContact.ContactId, JsonRequestBehavior.AllowGet)); } return(Json("Failed", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
public JsonResult ChangePasswordForInternTutors(string strOldPassword, string strNewPassword) { try { db = new CourseDataContext(); Int64 intInternTutorId = 0; if (Session["InternTutorId"].ToString() != null) { Int64.TryParse(Session["InternTutorId"].ToString(), out intInternTutorId); } var data = (from d in db.SITSPL_tblUsers where d.Id == intInternTutorId && d.Password == strOldPassword select d).FirstOrDefault(); if (data != null) { data.Password = strNewPassword; db.SubmitChanges(); return(Json(intInternTutorId.ToString(), JsonRequestBehavior.AllowGet)); } else { return(Json("OldPasswordNotMatch", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult UpdateCourseDetailsMaster(SITSPL_tblCourseStructure cs, int Course, decimal Fees, int Discount, decimal NetAmount, DateTime ValidFrom, DateTime ValidTo, int StructureId, int DurationId, string DurationName , int StudentCategoryId, bool IsPublished, Int64?BatchId, int StudentSubCategoryId) { try { db = new CourseDataContext(); bool result = false; SITSPL_tblCourseStructure coursestr = db.SITSPL_tblCourseStructures.Where(x => x.CourseId == Course && x.StructureId == StructureId && x.IsDeleted == false).FirstOrDefault(); DateTime ValidFromdate = DateTime.Parse(Convert.ToDateTime(ValidFrom).ToShortDateString()); DateTime ValidTodate = DateTime.Parse(Convert.ToDateTime(ValidTo).ToShortDateString()); if (ValidFromdate > ValidTodate) { return(Json("ValidTo")); } else if (coursestr != null) { coursestr.CourseId = Course; coursestr.Fees = Fees; coursestr.DiscountPercent = Discount; coursestr.NetAmount = NetAmount; coursestr.ValidFrom = ValidFrom; coursestr.ValidTo = ValidTo; coursestr.DurationId = DurationId; coursestr.StdCatgId = StudentCategoryId; coursestr.StudentSubCategoryId = StudentSubCategoryId; coursestr.BatchId = BatchId; if (IsPublished) { if (!coursestr.IsPublished) { coursestr.DatePublished = DateTime.Now; coursestr.PublishedBy = "Admin"; } } coursestr.IsPublished = IsPublished; coursestr.LastUpdated = DateTime.Now; coursestr.UpdatedBy = "Admin"; db.SubmitChanges(); result = true; return(Json(result, JsonRequestBehavior.AllowGet)); } else { result = false; return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult AddEnquiry(tblEnquiry objEnquiry) { try { if (objEnquiry != null) { db = new CourseDataContext(); tblEnquiry addenquiry = new tblEnquiry(); addenquiry.CandidateType = objEnquiry.CandidateType; addenquiry.Name = objEnquiry.Name; addenquiry.Mobile = objEnquiry.Mobile; addenquiry.Email = objEnquiry.Email; addenquiry.EnquiryType = objEnquiry.EnquiryType; addenquiry.Message = objEnquiry.Message; if (objEnquiry.EnquiryType == "Intern") { addenquiry.InternshipId = objEnquiry.InternshipId; } else if (objEnquiry.EnquiryType == "Course") { addenquiry.StudentCategoryId = objEnquiry.StudentCategoryId; addenquiry.CourseId = objEnquiry.CourseId; } addenquiry.DateCreated = DateTime.Now; addenquiry.CreatedBy = objEnquiry.Name; addenquiry.IsPublished = true; db.tblEnquiries.InsertOnSubmit(addenquiry); db.SubmitChanges(); SendOTPForEnqueryContactFAQ(objEnquiry.Name, objEnquiry.Email, "Enquiry", "EnquiryRes"); return(Json(addenquiry.EnquiryId, JsonRequestBehavior.AllowGet)); } return(Json("Failed", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }
public ContentResult FileUploadByInternTutor(int InternshipId) { string path = Server.MapPath("~/InternTutor/Resource/"); tblResource objResource = null; db = new CourseDataContext(); Int64 intInternTutorId = 0; Int64.TryParse(Session["InternTutorId"].ToString(), out intInternTutorId); foreach (string key in Request.Files) { HttpPostedFileBase postedFileBase = Request.Files[key]; postedFileBase.SaveAs(path + postedFileBase.FileName); objResource = new tblResource(); objResource.DateCreated = DateTime.Now; objResource.CreatedBy = Session["InternTutorUser"].ToString(); objResource.ResourceName = postedFileBase.FileName; objResource.ResourceType = postedFileBase.ContentType; objResource.TutorId = intInternTutorId; // objResource.CourseId = CourseId; objResource.InternshipId = InternshipId; objResource.CreatedBy = Session["InternTutorUser"].ToString(); objResource.UserType = "InternTutor"; db.tblResources.InsertOnSubmit(objResource); db.SubmitChanges(); } if (Request.Files.Count > 0) { if (objResource.ResourceId > 0) { return(Content("Successfully")); } return(Content("Failed")); } return(Content("Failed")); }
public JsonResult AddUserFAQDetails(tblUserFAQ tblUserFAQ) { try { if (tblUserFAQ != null) { db = new CourseDataContext(); tblUserFAQ.DateCreated = DateTime.Now; tblUserFAQ.CreatedBy = "Public User"; tblUserFAQ.IsPublished = true; db.tblUserFAQs.InsertOnSubmit(tblUserFAQ); db.SubmitChanges(); SendOTPForEnqueryContactFAQ(tblUserFAQ.Name, tblUserFAQ.Email, "FAQ", "FAQRes"); return(Json(tblUserFAQ.UserFAQId, JsonRequestBehavior.AllowGet)); } return(Json("Failed", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet));; } }
public JsonResult AddCourseStructure(SITSPL_tblCourseStructure courseStructure) { try { bool result = false; db = new CourseDataContext(); courseStructure.DateCreated = DateTime.Now; if (courseStructure.IsPublished == true) { courseStructure.DatePublished = DateTime.Now; } courseStructure.CreatedBy = "Admin"; db.SITSPL_tblCourseStructures.InsertOnSubmit(courseStructure); db.SubmitChanges(); result = true; return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult CreateCourse(SITSPL_tblCourse objCourse) { try { db = new CourseDataContext(); bool result = false; string Cour = objCourse.CourseName; var data = db.SITSPL_tblCourses.Select(x => new { x.CourseName }).ToList(); var Cours = data.Select(x => x.CourseName); if (Cour != null && !Cours.Contains(Cour, StringComparer.OrdinalIgnoreCase)) { objCourse.DateCreated = DateTime.Now; objCourse.DatePublished = DateTime.Now; objCourse.IsPublished = true; objCourse.CreatedBy = "Admin"; db.SITSPL_tblCourses.InsertOnSubmit(objCourse); db.SubmitChanges(); result = true; return(Json(result, JsonRequestBehavior.AllowGet)); } else if (Cour != null && Cours.Contains(Cour, StringComparer.OrdinalIgnoreCase)) { ViewBag.InsertMessage = "Course already exists"; result = false; return(Json(result, JsonRequestBehavior.AllowGet)); } else { return(Json("empty", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult AddMessageForInternStudentCommunication(int InternshipId, bool IsAllInternStudent, List <InternStudentsForTutor> lstInternStudent, string StudentMsg) { try { db = new CourseDataContext(); tblCommunication objComm = null; var InternTutorsId = Session["InternTutorId"].ToString(); ArrayList alAllEmail = new ArrayList(); if (IsAllInternStudent == false) { objComm = new tblCommunication(); // Course Student List if (lstInternStudent != null) { ArrayList alEmail = new ArrayList(); for (int i = 0; i < lstInternStudent.Count; i++) { alEmail.Add(lstInternStudent[i].Email); objComm = new tblCommunication(); objComm.IsAllInternStudent = IsAllInternStudent; objComm.Id = lstInternStudent[i].StudentId; objComm.UserType = "All-Intern-Students"; objComm.TutorId = Convert.ToInt32(InternTutorsId); objComm.DateCreated = DateTime.Now; objComm.CreatedBy = "Intern Tutor"; objComm.Message = StudentMsg; objComm.MessageAllStudents = "-"; objComm.MessageAllTeachers = "-"; objComm.InternshipId = lstInternStudent[i].InternshipId; objComm.TutorId = Convert.ToInt32(InternTutorsId); objComm.CategoryType = "Intern Tutor"; db.tblCommunications.InsertOnSubmit(objComm); db.SubmitChanges(); } if (alEmail.Count > 0) { SendMailToAll(alEmail); } return(Json(objComm.CommunicationId, JsonRequestBehavior.AllowGet)); } } else if (IsAllInternStudent == true) { objComm = new tblCommunication(); ArrayList alEmail = new ArrayList(); var InternTutorId = Session["InternTutorId"].ToString(); var InternAllStudents = (from apply in db.tblInternApplies join instr in db.SITSPL_tblInternshipStructures on apply.InternshipStructureId equals instr.InternStructureId join intr in db.SITSPL_tblInternships on instr.InternshipId equals intr.InternshipId join inttut in db.tblInternTutors on instr.InternshipId equals inttut.InternshipId where inttut.TutorId == Convert.ToInt32(InternTutorId) // where inttut.InternshipId == InternshipId && select new { apply.InterApllyId, apply.Name, instr.InternshipId, apply.Email }).Distinct().ToList(); if (InternAllStudents != null) { for (int i = 0; i < InternAllStudents.Count; i++) { alEmail.Add(InternAllStudents[i].Email); objComm = new tblCommunication(); objComm.IsAllInternStudent = IsAllInternStudent; objComm.Id = InternAllStudents[i].InterApllyId; objComm.UserType = "All-Intern-Students"; objComm.TutorId = Convert.ToInt32(InternTutorsId); objComm.DateCreated = DateTime.Now; objComm.CreatedBy = "Intern Tutor"; objComm.Message = StudentMsg; objComm.CategoryType = "Intern Tutor"; objComm.TutorId = Convert.ToInt32(InternTutorsId); objComm.InternshipId = InternAllStudents[i].InternshipId; db.tblCommunications.InsertOnSubmit(objComm); db.SubmitChanges(); } if (alEmail.Count > 0) { SendMailToAll(alEmail); } return(Json(objComm.CommunicationId, JsonRequestBehavior.AllowGet)); } } return(Json("", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }