public HttpResponseMessage get() { int count = 0; Parallel.Invoke(() => { testdbEntities tdb = new testdbEntities(); ObjectParameter obj1 = new ObjectParameter("count", typeof(int)); tdb.usp_FetchEmployeecount(obj1); count += Convert.ToInt32(obj1.Value); }, () => { testdbEntities tdb = new testdbEntities(); ObjectParameter obj2 = new ObjectParameter("count", typeof(int)); tdb.usp_GetEmployeeCount(obj2); count += Convert.ToInt32(obj2.Value); }); var resp = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(count.ToString(), System.Text.Encoding.UTF8, "application/json") }; return(resp); }
public ActionResult Authorise(MVCLogin.Models.tblUser userModel) { using (testdbEntities db = new testdbEntities()) { var userDetails = db.tblUsers.Where(x => x.userName == userModel.userName && x.Password == userModel.Password).FirstOrDefault(); if (userDetails == null) { userModel.LoginErrorMessage = "Wrong username or password!"; return(View("Index", userModel)); } else { Session["userID"] = userDetails.UserID; Session["userName"] = userDetails.userName; return(RedirectToAction("Index", "Home")); } } }