internal bool SessionReviewByStudent(StudentReviewModel 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));
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 = 0;
rating.knowledgable = 0;
rating.helpful = 0;
rating.review = objReq.reviewText;
db.tblTutorRatings.InsertOnSubmit(rating);
}
else
{
rating.userName = objReq.userName;
rating.updatedDate = DateTime.UtcNow;
rating.review = objReq.reviewText;
}
db.SubmitChanges();
return true;
}
}
public Response<string> SessionReviewByStudent(StudentReviewModel 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.SessionReviewByStudent(objReq))
response.Create(true, Messages.FormatMessage(Messages.Success, "You have reviewed"), 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;
}
