public JsonResult GetFAQDetail()
{
try
{
db = new CourseDataContext();
var list = (from faq in db.tblUserFAQs
select new
{
faq
}).ToList();
var data = list.Select(x => new
{
x.faq.Query,
x.faq.Name,
x.faq.Mobile,
x.faq.UserFAQId,
x.faq.Email,
DateCreated = x.faq.DateCreated.ToString("dd/MM/yyyy")
}).ToList();
if (data != null)
{
return(Json(data, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
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 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;
}
}
// Get Course For Intern Tutor
public JsonResult InternshipForInternTutor()
{
try
{
db = new CourseDataContext();
Int64 intInternTutorId = 0;
Int64.TryParse(Session["InternTutorId"].ToString(), out intInternTutorId);
var InternId = (from tut in db.SITSPL_tblTutors
join intrtut in db.tblInternTutors
on tut.TutorId equals intrtut.TutorId
join intr in db.SITSPL_tblInternships
on intrtut.InternshipId equals intr.InternshipId
select new
{
intrtut.InternshipId,
intr.InternshipName
}).ToList();
var data = InternId.Select(x => new
{
x.InternshipId,
x.InternshipName
}).Distinct().ToList();
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public JsonResult FAQByAdmin()
{
try
{
db = new CourseDataContext();
var list = (from faq in db.tblFAQs
where faq.IsPublished == true
select new
{
faq
}).ToList();
var data = list.Select(x => new
{
x.faq.FAQId,
x.faq.Question,
x.faq.QuestionType,
x.faq.Answer,
x.faq.IsPublished,
x.faq.CreatedBy,
DateCreated = x.faq.DateCreated.ToString("dd/MM/yyyy"),
LastUpdated = x.faq.LastUpdated.HasValue ? x.faq.LastUpdated.Value.ToString("dd/MM/yyyy") : null,
x.faq.UpdatedBy
}).OrderByDescending(x => x.FAQId).ToList();
return(Json(data, 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 List <tblActivity> GetContacts(DateTime afterDate)
{
using (CourseDataContext obj = new CourseDataContext())
{
return(obj.tblActivities.Where(d => d.ActivityDate > afterDate).OrderByDescending(d => d.ActivityDate).ToList());
}
}
// Download Resources For Intern Student
public JsonResult DownloadResourcesForInternStudent()
{
try
{
db = new CourseDataContext();
Int64 intInternStudentId = 0;
Int64.TryParse(Session["InterApllyId"].ToString(), out intInternStudentId);
var InternshipStructureId = (from apply in db.tblInternApplies
where apply.InterApllyId == intInternStudentId
select new
{
apply.InternshipStructureId
}).FirstOrDefault();
var list = (from d in db.tblResources
join c in db.SITSPL_tblInternships
on d.InternshipId equals c.InternshipId
join intrstr in db.SITSPL_tblInternshipStructures
on c.InternshipId equals intrstr.InternshipId
where intrstr.InternStructureId == InternshipStructureId.InternshipStructureId
where d.UserType == "InternTutor"
// from d in db.tblResources
// join c in db.SITSPL_tblCourses
// on d.CourseId equals c.CourseId
// join cd in db.SITSPL_tblCourseDetails
// on d.CourseId equals cd.CourseId
// join std in db.SITSPL_tblStudentProfiles
//on cd.StudentId equals std.StudentId
// where d.UserType == "BrandTutor" && std.StudentId == intStudentId
select
new
{
d,
c
}).ToList();
var data = list.Select(x => new
{
x.d.ResourceId,
x.d.ResourceName,
x.d.ResourceType,
x.d.IsPubllished,
DateCreated = x.d.DateCreated.ToString("dd/MM/yyyy"),
x.d.CreatedBy,
x.d.UserType,
x.c.InternshipName
}).OrderByDescending(x => x.ResourceId).Distinct().ToList();
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
protected void Page_Load(object sender, EventArgs e)
{
CourseDataContext cources = new CourseDataContext();
GridView1.DataSource = from course in cources.Del_Courses
where course.CoursePK > 10
select cources;
}
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 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 GetMessagesToInternStudent()
{
try
{
db = new CourseDataContext();
var InternTutorId = Session["InternTutorId"].ToString();
var list = (from comm in db.tblCommunications
join intr in db.SITSPL_tblInternships
on comm.InternshipId equals intr.InternshipId
join apply in db.tblInternApplies
on comm.Id equals apply.InterApllyId
join instr in db.SITSPL_tblInternshipStructures
on apply.InternshipStructureId equals instr.InternStructureId
where comm.CreatedBy == "Intern Tutor" && comm.TutorId == Convert.ToInt32(InternTutorId)
select new
{
comm,
intr,
apply
}).ToList();
var data = list.Select(x => new
{
x.comm.CommunicationId,
x.comm.CategoryType,
x.comm.InternshipId,
x.intr.InternshipName,
x.apply.Name,
x.apply.Email,
DOB = x.apply.DOB.ToString("dd/MM/yyyy"),
x.comm.Id,
x.comm.Message,
x.comm.IsAllInternStudent,
DateCreated = x.comm.DateCreated.ToString("dd/MM/yyyy"),
x.comm.CreatedBy,
x.comm.UserType,
}).OrderByDescending(x => x.CommunicationId).Distinct().ToList();
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SendOtpForEnquiry(string Name, string Email, string UserType)
{
try
{
db = new CourseDataContext();
bool result = false;
SendOTPForEnqueryContactFAQ(Name, Email, "Enquiry", "");
result = true;
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetInternStudents()
{
try
{
db = new CourseDataContext();
// select apply.InterApllyId,Name,DOB,Email,Image,CollegeUniv,
//Qualification,YearOfPassing,apply.DateCreated,HowDoYouKnow
//from tblInternApply as apply
//INNER JOIN SITSPL_tblUser as us
//on us.Id = apply.InterApllyId
var InternTutorId = Session["InternTutorId"].ToString();
var list = (from apply in db.tblInternApplies
join us in db.SITSPL_tblUsers
on apply.InterApllyId equals us.Id
select new
{
apply,
us
}).ToList();
var data = list.Select(x => new
{
x.apply.InterApllyId,
x.apply.Name,
DOB = x.apply.DOB.ToString("dd/MM/yyyy"),
x.apply.Email,
x.apply.Image,
x.apply.CollegeUniv,
x.apply.Qualification,
x.apply.YearOfPassing,
DateCreated = x.apply.DateCreated.HasValue ? x.apply.DateCreated.Value.ToString("dd/MM/yyyy") : null,
x.apply.HowDoYouKnow,
x.us.UserType,
x.us.UserName
}).ToList();
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
// Getting data from Course Master
public JsonResult GetAddedCourses()
{
try
{
db = new CourseDataContext();
var data = db.SITSPL_AddCourse().Where(x => x.IsDeleted = true).OrderByDescending(x => x.CourseId).ToList();
if (data != null)
{
return(Json(data, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
// Edit Course
public JsonResult EditCourse(int Id)
{
try
{
db = new CourseDataContext();
var data = db.SITSPL_tblCourses.Where(x => x.CourseId == Id).Select(x => x.CourseName).FirstOrDefault();
if (data != null)
{
return(Json(data, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
// 5 September Get Duration
public JsonResult GetDuration()
{
try
{
db = new CourseDataContext();
var data = (from dur in db.tblDurations
select new
{
dur.DurationId,
dur.DurationName
}).ToList();
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetBatchDetails()
{
try
{
db = new CourseDataContext();
var data = (from batch in db.SITSPL_tblBatches
where batch.IsPublished == true
select new
{
batch.BatchId,
batch.BatchSize
}).ToList();
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
// Edit Course Structure
public JsonResult EditCourseDetail(string CourseId, string StructureId)
{
try
{
db = new CourseDataContext();
if (CourseId != "" && StructureId != "" && StructureId != null)
{
var Dur = db.SITSPL_tblCourseStructures.Where(x => x.CourseId == Convert.ToInt32(CourseId) &&
x.StructureId == Convert.ToInt32(StructureId)).Select(x => new { x.DurationId }).FirstOrDefault();
var data2 = (from c in db.SITSPL_tblCourses
join cs in db.SITSPL_tblCourseStructures on c.CourseId equals cs.CourseId
join dur in db.tblDurations on cs.DurationId equals dur.DurationId
join tut in db.tblCourseTutors on cs.TutorId equals tut.TutorId into tutor// Added By Dilshad A. on 16 Dec 2020
from tut in tutor.DefaultIfEmpty()
where (cs.CourseId == Convert.ToInt32(CourseId) && cs.StructureId == Convert.ToInt32(StructureId))
select new
{
Course = cs.CourseId,
Duration = cs.DurationName,
Month = cs.Months,
cs.Fees,
Discount = cs.DiscountPercent,
cs.NetAmount,
cs.ValidFrom,
cs.ValidTo,
cs.StdCatgId,
cs.StructureId,
dur.DurationId,
dur.DurationName,
cs.TutorId, // Added By Dilshad A. on 16 Dec 2020
cs.BatchId, // Added By Dilshad A. on 16 Dec 2020
cs.StudentSubCategoryId,
cs.IsPublished
}).FirstOrDefault();
return(Json(data2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
return(Json("", 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 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 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 GetSubHeadingByStudentCategoryId()
{
try
{
db = new CourseDataContext();
var data = (from d in db.tblStudentSubCategories
join d1 in db.tblStudentCategories on d.StudedetSubCategoryId equals d1.StudentCategoryId into Cat
from d1 in Cat.DefaultIfEmpty()
where d.IsPublished == true
select new
{
d.StudedetSubCategoryId,
d.StudentCategoryId,
d.SubCategoryName
}).ToList();
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult Internship()
{
try
{
db = new CourseDataContext();
var data = (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
select new
{
intr.InternshipId,
intr.InternshipName
}).Distinct().ToList();
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetFeeDetailsByBatchId(int intCourseStrucId)
{
try
{
db = new CourseDataContext();
var data = (from d in db.SITSPL_tblBatches
join d1 in db.SITSPL_tblCourseStructures on d.BatchId equals d1.BatchId
where d1.IsPublished == true &&
d1.StructureId == intCourseStrucId
select new
{
d.BatchId,
d1.Fees,
d1.DiscountPercent,
d1.NetAmount,
}).SingleOrDefault();
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult ViewInternTutorResourceDetails()
{
try
{
db = new CourseDataContext();
Int64 intInternTutorId = 0;
Int64.TryParse(Session["InternTutorId"].ToString(), out intInternTutorId);
var list = (from d in db.tblResources
join c in db.SITSPL_tblInternships
on d.InternshipId equals c.InternshipId
where d.UserType == "InternTutor" && d.TutorId == intInternTutorId
select
new
{
d,
c
}).ToList();
var data = list.Select(x => new
{
x.d.ResourceId,
x.d.ResourceName,
x.d.ResourceType,
x.d.IsPubllished,
DateCreated = x.d.DateCreated.ToString("dd/MM/yyyy"),
x.d.CreatedBy,
x.d.UserType,
x.c.InternshipName
}).OrderByDescending(x => x.ResourceId).ToList();
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetSubCategory(int CategoryId)
{
try
{
db = new CourseDataContext();
if (CategoryId > 0)
{
var data = (from subcatg in db.tblStudentSubCategories
join catg in db.tblStudentCategories
on subcatg.StudentCategoryId equals catg.StudentCategoryId
where subcatg.StudentCategoryId == CategoryId && subcatg.IsPublished == true
select new
{
subcatg.StudedetSubCategoryId,
subcatg.SubCategoryName
}).Distinct().ToList();
return(Json(data, JsonRequestBehavior.AllowGet));
}
else
{
var data = (from subcatg in db.tblStudentSubCategories
where subcatg.IsPublished == true
select new
{
subcatg.StudedetSubCategoryId,
subcatg.SubCategoryName
}).Distinct().ToList();
return(Json(data, 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));
}
}
