public FileResult DownloadFile(int?fileId) { DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3(); Leave_request file = db.Leave_request.ToList().Find(model => model.id == fileId.Value); return(File(file.file_data, file.Content_type, file.file_name)); }
public ActionResult Index(Employee sc) { DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3(); if (db.Employees.Any(x => x.id == sc.id)) { ViewBag.message = "This Employee with id " + sc.id + " already exists"; return(View()); } else { HttpClient hc = new HttpClient(); hc.BaseAddress = new Uri("https://localhost:44327/api/employee"); var insertemployee = hc.PostAsJsonAsync <Employee>("employee", sc); var saveemployee = insertemployee.Result; if (saveemployee.IsSuccessStatusCode) { TempData["message"] = "Employee with id " + sc.id + " has been created successfully!"; return(RedirectToAction("Index", "InsertEmployee")); } else { //ViewBag.message = "Please give the required fields"; } return(View()); } }
// GET: Crud/Delete/5 public ActionResult Delete(int id) { using (DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3()) { return(View(db.Employees.Where(x => x.id == id).FirstOrDefault())); } }
public ActionResult Edit1(int id) { using (DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3()) { return(View(db.Leave_request.Where(x => x.id == id).FirstOrDefault())); } }
public ActionResult Index(HttpPostedFileBase postedFile, Leave_request leave_Request) { DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3(); if (String.IsNullOrEmpty(leave_Request.emp_id.ToString()) || String.IsNullOrEmpty(leave_Request.emp_name) || String.IsNullOrEmpty(leave_Request.start_date) || String.IsNullOrEmpty(leave_Request.end_date) || String.IsNullOrEmpty(leave_Request.ref_no) || String.IsNullOrEmpty(leave_Request.reason)) { return(View()); } else if (String.IsNullOrEmpty(leave_Request.start_date) || String.IsNullOrEmpty(leave_Request.end_date) || String.IsNullOrEmpty(leave_Request.leave_type)) { //ViewBag.Notification = "start date, end date and leave type are required"; return(View()); } else if (db.Employees.All(x => x.id != leave_Request.emp_id) || db.Employees.All(x => x.Name != leave_Request.emp_name)) { ViewBag.Notification = "This employee name does not exists"; return(View()); } else if (db.Employees.Any(x => x.id != leave_Request.emp_id && x.Name == leave_Request.emp_name) || db.Employees.Any(x => x.id == leave_Request.emp_id && x.Name != leave_Request.emp_name)) { ViewBag.Notification = "This employee name does not match with id"; return(View()); } else { byte[] bytes; using (BinaryReader br = new BinaryReader(postedFile.InputStream)) { bytes = br.ReadBytes(postedFile.ContentLength); } db.Leave_request.Add(new Leave_request { id = leave_Request.id, emp_id = leave_Request.emp_id, emp_name = leave_Request.emp_name, start_date = leave_Request.start_date, end_date = leave_Request.end_date, leave_type = leave_Request.leave_type, reason = leave_Request.reason, ref_no = leave_Request.ref_no, status = "submitted", file_name = Path.GetFileName(postedFile.FileName), Content_type = postedFile.ContentType, file_data = bytes, Active = 1, Comments = "" }); db.SaveChanges(); //ViewBag.Notification1 = "Your leave request has created. Please wait for approval/rejection"; TempData["message"] = "Leave Request has been created successfully!"; return(RedirectToAction("Index", "Leave_Request")); } }
public ActionResult Passupd(Admin admin) { using (DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3()) { ViewBag.msg1 = admin.PasswordUs; ViewBag.msg2 = admin.NewPasswordUs; ViewBag.msg3 = admin.ReNewPasswordUs; if (String.IsNullOrEmpty(admin.IdUs.ToString()) || String.IsNullOrEmpty(admin.PasswordUs) || String.IsNullOrEmpty(admin.NewPasswordUs) || String.IsNullOrEmpty(admin.ReNewPasswordUs) || admin.NewPasswordUs != admin.ReNewPasswordUs) { return(View(admin)); } else if (db.Admins.All(x => x.IdUs != admin.IdUs)) { ViewBag.Message1 = "The admin with id " + admin.IdUs + " does not exists"; return(View(admin)); } var valid = (from c in db.Admins where c.IdUs.Equals(admin.IdUs) select c).SingleOrDefault(); ScryptEncoder encoder = new ScryptEncoder(); bool isvalid = encoder.Compare(admin.PasswordUs, valid.PasswordUs); if (valid != null) { Admin admin1 = db.Admins.Where(x => x.IdUs == admin.IdUs).FirstOrDefault(); if (admin1 != null && isvalid && admin.NewPasswordUs == admin.ReNewPasswordUs) { Admin k = db.Admins.Find(admin1.IdUs); String s1 = admin1.UserNameUs; db.Admins.Remove(k); db.SaveChanges(); String k1 = admin.NewPasswordUs; String k2 = encoder.Encode(k1); db.Admins.Add(new Admin() { IdUs = admin.IdUs, UserNameUs = s1, PasswordUs = k2, NewPasswordUs = k2, RePasswordUs = k2, ReNewPasswordUs = k2 }); db.SaveChanges(); TempData["message"] = "Password for admin Id " + admin.IdUs + " has been updated successfully!"; return(RedirectToAction("Passupd", "Home")); } else { ViewBag.Message1 = "Old password is incorrect"; } } } return(View()); }
public ActionResult Delete(int id, FormCollection collection) { try { using (DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3()) { Employee employee = db.Employees.Where(x => x.id == id).FirstOrDefault(); db.Employees.Remove(employee); db.SaveChanges(); } TempData["message"] = "Employee details for employee id " + id + " has been deleted successfully!"; return(RedirectToAction("Delete", "EmployeeInsert")); } catch { return(View()); } }
public ActionResult Edit(int id, Employee employee) { try { using (DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3()) { db.Entry(employee).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Employee details for employee id " + id + " has been updated successfully!"; return(RedirectToAction("Edit", "EmployeeInsert")); } //return View(); } catch { return(View()); } }
public ActionResult Delete(int id, FormCollection collection) { try { using (DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3()) { Task_report task_Report = db.Task_report.Where(x => x.id == id).FirstOrDefault(); task_Report.Active = 0; //db.Task_report.Remove(task_Report); db.SaveChanges(); } TempData["message"] = "Task Report has been deleted successfully!"; return(RedirectToAction("Delete", "Task_Report")); } catch { return(View()); } }
public IHttpActionResult insertemployees(Employee sc) { DBuserSignupLoginEntities3 nd = new DBuserSignupLoginEntities3(); nd.Employees.Add(new Employee() { id = sc.id, Name = sc.Name, Date_of_birth = sc.Date_of_birth, Father_Name = sc.Father_Name, Mother_Name = sc.Mother_Name, Address = sc.Address, Salary = sc.Salary, Fresher = sc.Fresher, Role = sc.Role, Notes = sc.Notes }); nd.SaveChanges(); return(Ok()); }
public ActionResult Delete(int id, Leave_request leave_Request) { try { using (DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3()) { var user = db.Leave_request.Single(model => model.id == id); user.Active = 0; //db.Task_report.Remove(task_Report); db.SaveChanges(); } TempData["message"] = "Leave Request has been deleted successfully!"; return(RedirectToAction("Delete", "Leave_Request")); } catch { ViewBag.Notification = "The record is not deleted"; return(View()); } }
public ActionResult Index2(string searchBy, string search) { DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3(); if (searchBy == "Employee Id") { var insert1 = from Leave_request in db.Leave_request select Leave_request; if (searchBy == "Employee Id" && !String.IsNullOrEmpty(search) && search != "") { insert1 = insert1.Where(x => x.emp_id.ToString() == search && x.Active == 1 && x.status == "submitted"); Session["insert1"] = insert1.ToList <Leave_request>(); } else if (search == "" || String.IsNullOrEmpty(search)) { insert1 = insert1.Where(x => x.Active == 1 && x.status == "submitted"); Session["insert1"] = insert1.ToList <Leave_request>(); } return(View(db.Leave_request.Where(x => x.Active == 1 && x.status == "submitted" && (x.emp_id.ToString() == search || search == null || search == "")).ToList())); } else if (searchBy == "Employee Name") { var insert1 = from Leave_request in db.Leave_request select Leave_request; if (searchBy == "Employee Name" && !String.IsNullOrEmpty(search) && search != "") { insert1 = insert1.Where(x => x.emp_name.StartsWith(search) && x.Active == 1 && x.status == "submitted"); Session["insert1"] = insert1.ToList <Leave_request>(); } else if (search == "" || String.IsNullOrEmpty(search)) { insert1 = insert1.Where(x => x.Active == 1 && x.status == "submitted"); Session["insert1"] = insert1.ToList <Leave_request>(); } return(View(db.Leave_request.Where(x => x.Active == 1 && x.status == "submitted" && (x.emp_name.StartsWith(search) || search == null || search == "")).ToList())); } else if (searchBy == "Start Date") { var insert1 = from Leave_request in db.Leave_request select Leave_request; if (searchBy == "Start Date" && !String.IsNullOrEmpty(search) && search != "") { insert1 = insert1.Where(x => x.start_date == search && x.Active == 1 && x.status == "submitted"); Session["insert1"] = insert1.ToList <Leave_request>(); } else if (search == "" || String.IsNullOrEmpty(search)) { insert1 = insert1.Where(x => x.Active == 1 && x.status == "submitted"); Session["insert1"] = insert1.ToList <Leave_request>(); } return(View(db.Leave_request.Where(x => x.Active == 1 && x.status == "submitted" && (x.start_date == search || search == null || search == "")).ToList())); } else if (searchBy == "End Date") { var insert1 = from Leave_request in db.Leave_request select Leave_request; if (searchBy == "End Date" && !String.IsNullOrEmpty(search) && search != "") { insert1 = insert1.Where(x => x.end_date == search && x.Active == 1 && x.status == "submitted"); Session["insert1"] = insert1.ToList <Leave_request>(); } else if (search == "" || String.IsNullOrEmpty(search)) { insert1 = insert1.Where(x => x.Active == 1 && x.status == "submitted"); Session["insert1"] = insert1.ToList <Leave_request>(); } return(View(db.Leave_request.Where(x => x.Active == 1 && x.status == "submitted" && (x.end_date == search || search == null || search == "")).ToList())); } else if (searchBy == "Leave Type") { var insert1 = from Leave_request in db.Leave_request select Leave_request; if (searchBy == "Leave Type" && !String.IsNullOrEmpty(search) && search != "") { insert1 = insert1.Where(x => x.leave_type.StartsWith(search) && x.Active == 1 && x.status == "submitted"); Session["insert1"] = insert1.ToList <Leave_request>(); } else if (search == "" || String.IsNullOrEmpty(search)) { insert1 = insert1.Where(x => x.Active == 1 && x.status == "submitted"); Session["insert1"] = insert1.ToList <Leave_request>(); } return(View(db.Leave_request.Where(x => x.Active == 1 && x.status == "submitted" && (x.leave_type.StartsWith(search) || search == null || search == "")).ToList())); } return(View(db.Leave_request.ToList().Where(x => x.Active == 1 && x.status == "submitted"))); }
//admin public ActionResult Index1() { DBuserSignupLoginEntities3 db = new DBuserSignupLoginEntities3(); return(View(db.Leave_request.ToList().Where(x => x.Active == 1 && x.emp_id == Convert.ToInt32(Session["IdUsSS1"])))); }