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"]))));
}
