public ActionResult mysalary() { var context = new myPayrollEntities(); //var mytotalSalaries = context.sp_TotalSalaries(); var mytotalSalaries = context.sp_CalculateIndividualSalary(4); foreach (var mms in mytotalSalaries) { mms.ToString(); } return(View()); }
public bool isValidUser(string useremail, string userpassword) { tblEmployee emp = new tblEmployee(); using (myPayrollEntities md = new myPayrollEntities()) { emp = md.tblEmployees.Where(q => q.emp_email.Contains(useremail) && q.emp_password.Contains(userpassword)).SingleOrDefault(); } if (emp == null) { return(false); } else { return(true); } }