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));
}
}
