internal bool SessionRatingByStudent(StudentRatingwModel objReq)
{
using (var db = new WizzDataContext())
{
tblTutorRating rating = new tblTutorRating();
var sessionData = db.tblSessions.FirstOrDefault(x => x.pkSessionId == Convert.ToInt64(objReq.sessionId));
rating = db.tblTutorRatings.FirstOrDefault(x => x.sessionId == objReq.sessionId && x.fkStudentId == Convert.ToInt32(objReq.userId));
var tutorRating = db.tblUsers.Where(x => x.pkUserId == Convert.ToInt64(sessionData.tutorId)).FirstOrDefault();
if (rating == null)
{
rating = new tblTutorRating();
rating.createdDate = DateTime.UtcNow;
rating.sessionId = objReq.sessionId;
rating.userName = objReq.userName;
rating.fkStudentId = Convert.ToInt32(objReq.userId);
rating.fkTutorId = sessionData.tutorId;
rating.updatedDate = DateTime.UtcNow;
rating.punctual = Convert.ToInt16(objReq.punctual);
rating.knowledgable = Convert.ToInt16(objReq.knowledge);
rating.helpful = Convert.ToInt16(objReq.helpFul);
rating.review = "";
tutorRating.avgRatingTutor = ((tutorRating.avgRatingTutor) + (rating.punctual + rating.knowledgable + rating.helpful) / 3) / 2;
db.tblTutorRatings.InsertOnSubmit(rating);
}
else
{
rating.userName = objReq.userName;
rating.updatedDate = DateTime.UtcNow;
rating.punctual = Convert.ToInt16(objReq.punctual);
rating.knowledgable = Convert.ToInt16(objReq.knowledge);
rating.helpful = Convert.ToInt16(objReq.helpFul);
tutorRating.avgRatingTutor = ((tutorRating.avgRatingTutor) + (rating.punctual + rating.knowledgable + rating.helpful) / 3) / 2;
}
db.SubmitChanges();
return true;
}
}
public Response<string> SessionRatingByStudent(StudentRatingwModel objReq)
{
Response<string> response = new Response<string>();
List<string> objResp = new List<string>();
try
{
Session obj = new Session();
if (CheckRequestIsvalidornot(this.Request))
{
if (ModelState.IsValid)
{
if (obj.SessionRatingByStudent(objReq))
response.Create(true, Messages.FormatMessage(Messages.Success, "You have rated"), Messages.AppVersion, objResp);
else
response.Create(false, Messages.FormatMessage(Messages.InvalidReq), Messages.AppVersion, objResp);
}
else
response.Create(false, ModelState.Values.FirstOrDefault().Errors.FirstOrDefault().ErrorMessage, Messages.AppVersion, objResp);
}
}
catch (Exception ex)
{
object session = new JavaScriptSerializer().Serialize(objReq);
LogManager.Error("Error occured while Processing Webservice request :{0}", ex, session, ex.Message);
response.Create(false, Messages.FormatMessage(Messages.ErrorOccure), Messages.AppVersion, objResp);
}
return response;
}