public IHttpActionResult PostNewTest([FromBody] IESQuestionPaper value)
{
CustomResponse cr = new CustomResponse();
try
{
var context = new xPenEntities();
var old = (from q in context.IESQuestionPapers
where q.UniversityID == value.UniversityID && q.SubjectID == value.SubjectID && q.Year == value.Year
select q).ToList();
if (old.Count > 0)
{
cr.Response = "Paper Already Exist";
return(BadRequest(cr.Response));
}
else
{
cr.Response = "Updated";
context.IESQuestionPapers.Add(value);
context.SaveChanges();
return(Ok(cr));
}
}
catch (Exception ex)
{
return(InternalServerError(ex.InnerException));
}
}
public IHttpActionResult PostQuestion([FromBody] IESQuestion question, int PaperID)
{
try
{
var context = new xPenEntities();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
if (question.QuestionID <= 0)
{
context.IESQuestions.Add(question);
context.SaveChanges();
}
context.IESPaper_Question.Add(new IESPaper_Question {
PaperID = PaperID,
QuesID = question.QuestionID
});
context.SaveChanges();
dbContextTransaction.Commit();
}
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError());
}
}
public College_Courses GetCollegeDetails(int collegeid)
{
var context = new xPenEntities();
var CollegeDetails = (from c in context.ViewIESColleges
where c.CollegeID == collegeid
select c).First();
var sid = (from s in context.IESCourses
where s.CollegeID == collegeid
select s).ToList();
var listStream = (from i in sid
join st in context.IESStreams
on i.StreamID equals st.StreamID
select new IESStream {
StreamID = (int)i.StreamID, StreamName = st.StreamName, Description = st.Description
}).ToList();
College_Courses collegecourse = new College_Courses();
collegecourse.UnivID = CollegeDetails.UniversityID;
collegecourse.CollegeName = CollegeDetails.CollegeName;
collegecourse.Streams = listStream;
return(collegecourse);
}
public IHttpActionResult PostProfile([FromBody] IESAcademicProfile profile)
{
try
{
var context = new xPenEntities();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
var ac = (from ap in context.IESAcademicProfiles
where ap.UserID == profile.UserID
select ap).ToList();
if (ac.Count > 0)
{
context.IESAcademicProfiles.RemoveRange(ac);
context.SaveChanges();
}
context.IESAcademicProfiles.Add(profile);
context.SaveChanges();
dbContextTransaction.Commit();
}
CustomResponse cr = new CustomResponse();
cr.Response = "Ok";
return(Ok(cr));
}
catch (Exception Ex)
{
CustomResponse cr = new CustomResponse();
cr.Response = "Fail";
return(InternalServerError());
}
}
public IEnumerable <Object> GetQuestionforProfile(int UniversityID, int streamID, int SubjectId, int Year, int Unit, int UserId)
{
var context = new xPenEntities();
var order = (from o in context.IESOrders
where o.UserID == UserId
select o).ToList();
var test = (from s in context.ViewIESQuestionPapers
where s.UniversityID == UniversityID && s.StreamID == streamID &&
s.SubjectID == SubjectId && s.Year == Year && s.Unit == Unit
select s).ToList();
//var myTest = from t in test
// join o in order.DefaultIfEmpty(new IESOrder {Paid=0, PurchaseDate = DateTime.Now.AddYears(1), ClosureDate= DateTime.Now.AddYears(1) }) on t.PaperID equals o.PaperID
// select new { t.PaperID, t.UniversityName, t.SubjectName, t.Unit, t.CollegeName, t.Year, o.Paid , o.PurchaseDate, o.ClosureDate };
var qry = test.GroupJoin(
order,
t1 => t1.PaperID,
o1 => o1.PaperID,
(x, y) => new { test = x, order = y })
.SelectMany(
y => y.order.DefaultIfEmpty(new IESOrder {
OrderID = 0, PaperID = 0, UserID = 0, Paid = 0, PurchaseDate = DateTime.Now.AddYears(1), ClosureDate = DateTime.Now.AddYears(1)
}),
(x, y) => new { test = x.test, order = y }
).ToList();
return(qry);
}
public IHttpActionResult PostOTP([FromBody] OTP value)
{
try
{
var context = new xPenEntities();
string Message = "Register with IES Master using OTP " + value.String_OTP;
var user = (from u in context.IESUserProfiles
where u.MobileNumber == value.MobileNumber
select u).ToList();
if (user.Count == 1)
{
String result = Utility.sendSMS(Message, value.MobileNumber);
JObject json = JObject.Parse(result);
String status = json.GetValue("status").ToString();
return(Ok(json));
}
else if (user.Count == 0)
{
CustomResponse cr = new CustomResponse();
cr.Response = "Mobile number is not registered";
return(BadRequest());
}
else
{
return(BadRequest());
}
}
catch (Exception Ex)
{
return(InternalServerError());
}
}
public IHttpActionResult UpdateCollegeStream([FromBody] IESCourse[] courses)
{
try
{
var context = new xPenEntities();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
int collID = (int)courses.First().CollegeID;
var c = (from a in context.IESCourses
where a.CollegeID == collID
select a).ToList();
context.IESCourses.RemoveRange(c);
context.SaveChanges();
context.IESCourses.AddRange(courses);
context.SaveChanges();
dbContextTransaction.Commit();
}
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError());
}
}
public IEnumerable <Object> GetUniversityAll()
{
var context = new xPenEntities();
//var University = from u in context.IESUniversities
// join c in context.IESColleges
// on u.UnivID equals c.UnivID into pj
// from sub in pj.DefaultIfEmpty()
// select new { u.UnivID, u.UniversityName, sub.CollegeID };
//var uni = (from c in University
// group c by new { c.UnivID, c.UniversityName} into UnivGroup
// select new
// {
// UniversityName = UnivGroup.Key.UniversityName,
// UnivID = UnivGroup.Key.UnivID,
// CollegeCount = UnivGroup.Count()
// });
var uni = (from s in context.ViewIESUniversityWithCounts
select s).ToList();
return(uni);
}
public IHttpActionResult PostOrder([FromBody] IESOrder value)
{
List <IESOrder> list = new List <IESOrder>();
var context = new xPenEntities();
var prev = (from s in context.IESOrders
where s.PaperID == value.PaperID && s.UserID == value.UserID
select s).ToList();
if (prev.Count > 0)
{
return(InternalServerError());
}
else
{
context.IESOrders.Add(value);
context.SaveChanges();
return(Ok());
}
//try
//{
// var context = new xPenEntities();
// context.IESOrders.Add(value);
// context.SaveChanges();
// return Ok();
//}
//catch (Exception ex)
//{
// return InternalServerError(ex.InnerException);
//}
}
public IHttpActionResult PostLogin([FromBody] Login profile)
{
try
{
var context = new xPenEntities();
var user = (from u in context.IESUserProfiles
where u.Email.ToLower() == profile.Email.ToLower() && u.Password == profile.Password
select u).ToList();
if (user.Count == 0)
{
var _user = new IESUserProfile {
UserID = 0, Name = "", Address = "", Email = "", Password = "", Token = "", MobileNumber = "", ActivationDate = DateTime.Now
};
return(Ok(_user));
}
else if (user.Count > 1)
{
return(BadRequest("Multiple Existence"));
}
else
{
return(Ok(user.First()));
}
}
catch (Exception Ex)
{
return(InternalServerError());
}
}
public IEnumerable <ViewIESCollegeWithCount> GetCollegeCount()
{
//Select* from IESCollege as c
//left join
//(Select CollegeID, COUNT(UserID) as NoOfStudent from IESAcademicProfile group by CollegeID) as a
//on c.CollegeID = a.CollegeID
var context = new xPenEntities();
//var no = (from c in context.IESColleges
// join p in (from profiles in context.IESAcademicProfiles
// group profiles by profiles.CollegeID into profilegroup
// select new
// {
// collegekey = profilegroup.Key,
// collegecount = profilegroup.Count(),
// }) on c.CollegeID equals p.collegekey into collegeinfo
// from college in collegeinfo.DefaultIfEmpty()
// select new
// {
// CollegeID = c.CollegeID,
// CollegeName = c.CollegeName,
// UniversityID = c.UnivID,
// NumberOfStudents = (college.collegecount==0)?0: college.collegecount
// //c.CollegeID, c.CollegeName ,c.UnivID ,isnull(a.CollegeID ,0) ,isnull(NoOfStudent ,0)
// }).ToList();
return(null);
}
// GET: api/Semester
public IEnumerable <Object> Get()
{
var context = new xPenEntities();
var stream = (from q in context.IESSemesters
select q).ToList();
return(stream);
}
// GET: api/Subject
public IEnumerable <IESSubject> GetSubjects()
{
var context = new xPenEntities();
var subjects = (from s in context.IESSubjects
select s).ToList();
return(subjects);
}
public IEnumerable <Object> GetcollegeList()
{
var context = new xPenEntities();
var collegeList = (from s in context.ViewIESUniversityWithCounts
select s).ToList();
return(collegeList);
}
public IESUserProfile GetUserProfilebyMobile(String Mobile)
{
var context = new xPenEntities();
var soc = (from s in context.IESUserProfiles
where s.MobileNumber == Mobile
select s).FirstOrDefault();
return(soc);
}
public IEnumerable <ViewIESPaperQuestion> GetQuestionsForPaper(int paperId)
{
var context = new xPenEntities();
var stream = (from q in context.ViewIESPaperQuestions
where q.PaperID == paperId
select q).ToList();
return(stream);
}
public IEnumerable <ViewIESQuestionPaper> GetForYear(int UnivID, int StreamId, int SubId, int Year)
{
var context = new xPenEntities();
var stream = (from q in context.ViewIESQuestionPapers
where q.UniversityID == UnivID && q.StreamID == StreamId && q.SubjectID == SubId && q.Year == Year
select q).ToList();
return(stream);
}
public IEnumerable <ViewIESSubject> GetSubjectID(int collegeID, int streamID, int Semesterid)
{
var context = new xPenEntities();
var subject = (from s in context.ViewIESSubjects
where s.CollegeID == collegeID && s.StreamID == streamID && s.SemesterID == Semesterid
select s).ToList();
return(subject);
}
public IEnumerable <IESCollege> Get(int UniversityID, String CollegeName)
{
var context = new xPenEntities();
var soc = (from s in context.IESColleges
where s.UniversityID == UniversityID && s.CollegeName.Contains(CollegeName)
select s).ToList();
return(soc);
}
public IEnumerable <ViewIESStream> GetAllStream(int UniversityID, String StreamName)
{
var context = new xPenEntities();
var soc = (from s in context.ViewIESStreams
where s.UniversityID == UniversityID && s.StreamName.Contains(StreamName)
select s).ToList();
return(soc);
}
public IEnumerable <object> GetTop3()
{
var context = new xPenEntities();
var result = (from s in context.ViewIESUniversityWithCounts
orderby s.StudentCount descending
select s).Take(3);
return(result);
}
// GET: api/Stream/5
public IEnumerable <ViewIESStream> GetStreamofCollege(int collegeid)
{
var context = new xPenEntities();
var stream = (from s in context.ViewIESStreams
where s.CollegeID == collegeid
select s).ToList();
return(stream);
}
public IEnumerable <IESCollege> Get(int univId)
{
var context = new xPenEntities();
var college = (from s in context.IESColleges
where s.UniversityID == univId
select s).ToList();
return(college);
}
public IEnumerable <Object> GetUniversityByPaper()
{
var context = new xPenEntities();
var subjects = (from s in context.ViewIESQuestionPapers
group s by new { s.UniversityID, s.UniversityName, s.CollegeID, s.CollegeName } into unilist
select new { unilist.Key.UniversityID, unilist.Key.UniversityName, unilist.Key.CollegeID, unilist.Key.CollegeName }).ToList();
return(subjects);
}
public IEnumerable <Object> GetStreamByPaperForUniversity(int UniversityID)
{
var context = new xPenEntities();
var subjects = (from s in context.ViewIESQuestionPapers
where s.UniversityID == UniversityID
group s by new { s.StreamID, s.StreamName } into streamlist
select new { streamlist.Key.StreamID, streamlist.Key.StreamName }).ToList();
return(subjects);
}
public IEnumerable <Object> GetUnitforProfile(int UniversityID, int streamID, int SubjectId, int Year)
{
var context = new xPenEntities();
var test = (from s in context.ViewIESQuestionPapers
where s.UniversityID == UniversityID && s.StreamID == streamID && s.SubjectID == SubjectId && s.Year == Year
group s by s.Unit into unitGroup
select new { Unit = unitGroup.Key }).ToList();
return(test);
}
public IEnumerable <Object> GetSubjectsfromQuestionPaperforUniversity(int UniversityID, int StreamID)
{
var context = new xPenEntities();
var subjects = (from s in context.ViewIESQuestionPapers
where s.UniversityID == UniversityID && s.StreamID == StreamID
group s by new { s.SubjectID, s.SubjectName } into subjectlist
select new { SubjectId = subjectlist.Key.SubjectID, SubjectName = subjectlist.Key.SubjectName }).ToList();
return(subjects);
}
public IEnumerable <Object> GetSubjectsfromQuestionPaper(int CollegeID, int StreamID)
{
var context = new xPenEntities();
var subjects = (from s in context.ViewIESQuestionPapers
where s.CollegeID == CollegeID && s.StreamID == StreamID
group s by s.SubjectName into subjectlist
select new { subjectname = subjectlist.Key }).ToList();
return(subjects);
}
public IEnumerable <IESUniversity> GetUniversities()
{
Utility.log("Reading University List");
var context = new xPenEntities();
var soc = (from s in context.IESUniversities
select s).ToList();
Utility.log("Found " + soc.Count);
return(soc);
}
public IEnumerable <object> GetCout()
{
var context = new xPenEntities();
var countresult = (from s in context.IESOrders
group s.UserID by DbFunctions.TruncateTime(s.PurchaseDate) into usergroup
select new {
Date = usergroup.Key,
UserCount = usergroup.Count()
}
).ToList();
return(countresult);
}
