public bool CheckEmployeeID(string empid) { objemployeeproperty = new EmployeeProperty(); objemployeeproperty.Employee_ID = empid; objEmployeeBll = new Employee_BLL(objemployeeproperty); return(objEmployeeBll.CheckEmployeeID()); }
public JsonResult GetEmployees() { objEmployeeBll = new Employee_BLL(); DataTable Employee = objEmployeeBll.SelectAll(); var EmployeeJson = JsonConvert.SerializeObject(Employee); var deserilize = JsonConvert.DeserializeObject(EmployeeJson); return(Json(new { Employee = EmployeeJson, Employeedeserialize = deserilize }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetEmployeesDepandants(int id) { Depandants_Property dpndnt = new Depandants_Property(); dpndnt.Employee_Primary_Id = id; objEmployeeBll = new Employee_BLL(dpndnt); DataTable depandants = objEmployeeBll.SelectDepandant(); var EmployeeDepandant = JsonConvert.SerializeObject(depandants); var deserilize = JsonConvert.DeserializeObject(EmployeeDepandant); return(Json(new { Employee = EmployeeDepandant }, JsonRequestBehavior.AllowGet)); }
public ActionResult ShowEmployee(int id) { objemployeeproperty = new EmployeeProperty(); objemployeeproperty.Id = id; objEmployeeBll = new Employee_BLL(objemployeeproperty); DataTable dt = objEmployeeBll.SelectOne(); ViewBag.Employee = dt; ViewBag.EmployeeID = objemployeeproperty.Id; GetDesignations(); GetDepartments(); GetDeputaion(); GetEmptype(); return(View("AddEmployee", objemployeeproperty)); }
public void GetEmployee() { Employee_BLL objemployeeBLL = new Employee_BLL(); DataTable dt = objemployeeBLL.SelectAll(); List <EmployeeProperty> objEmployeePropertylistItems = new List <EmployeeProperty>(); foreach (DataRow dr in dt.Rows) { EmployeeProperty objEmployeeProperty = new EmployeeProperty(); objEmployeeProperty.EmpName = dr["EmployeeName"].ToString(); objEmployeeProperty.Id = Convert.ToInt32(dr["ID"].ToString()); objEmployeePropertylistItems.Add(objEmployeeProperty); } ViewBag.EmployeelistItems = objEmployeePropertylistItems; }
public ActionResult ShowEmployeeInfo() { objemployeeproperty = new EmployeeProperty(); objemployeeproperty.Id = Convert.ToInt32(Session["Emp_ID"].ToString()); objemployeeproperty.EmployeeLogin = true; objEmployeeBll = new Employee_BLL(objemployeeproperty); DataTable dt = objEmployeeBll.SelectOne(); ViewBag.Employee = dt; ViewBag.EmployeeID = objemployeeproperty.Id; GetDesignations(); GetDepartments(); GetDeputaion(); GetEmptype(); return(View("AddEmployee", objemployeeproperty)); }
public JsonResult GetAttendanceRepotrt(int year, int month) { int employeeid = Convert.ToInt32(Session["Emp_ID"].ToString()); string from = year + "-" + month + "-" + 01; string to = year + "-" + month + "-" + 31; EmployeeProperty emp = new EmployeeProperty(); emp.Id = employeeid; Employee_BLL empbll = new Employee_BLL(emp); int empattendanceid = empbll.GetEmployeeAttendanceId(); objattendancebll = new Attendance_BLL(); DataTable dt = objattendancebll.SelectEmployeeAttendance(from, to, empattendanceid); var dtserialize = JsonConvert.SerializeObject(dt); return(Json(new { data = dtserialize }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetEmployeeByID(int id) { objemployeeproperty = new EmployeeProperty(); objemployeeproperty.Id = id; objEmployeeBll = new Employee_BLL(objemployeeproperty); DataTable dt = objEmployeeBll.SelectOne(); if (dt.Rows.Count > 0) { var Empserialize = JsonConvert.SerializeObject(dt); return(Json(new { status = true, code = 200, message = "No user Found", data = Empserialize }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = true, code = 404, message = "No user Found", data = "" }, JsonRequestBehavior.AllowGet)); } }
public FileResult DownloadAttendance(int year, int month) { int employeeid = Convert.ToInt32(Session["Emp_ID"].ToString()); string from = year + "-" + month + "-" + 01; string to = year + "-" + month + "-" + 31; EmployeeProperty emp = new EmployeeProperty(); emp.Id = employeeid; Employee_BLL empbll = new Employee_BLL(emp); int empattendanceid = empbll.GetEmployeeAttendanceId(); objattendancebll = new Attendance_BLL(); DataTable dt = objattendancebll.SelectEmployeeAttendance(from, to, empattendanceid); string fullName = Server.MapPath("~" + "/AttendanceFiles/Attendance Report" + from + to + employeeid); bool flag = WriteDataTableToExcel(dt, "Attendance Report" + employeeid, fullName); if (flag) { try { byte[] fileBytes = System.IO.File.ReadAllBytes(fullName + ".xlsx"); string fileName = Path.GetFileName(fullName + ".xlsx"); return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName)); } catch (Exception ex) { //StringBuilder sb = new StringBuilder(); //sb.Append("log something"); //File.AppendAllText(filePath + "log.txt", sb.ToString()); //sb.Clear(); byte[] fileBytes = new byte[1]; return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, "")); } } else { byte[] fileBytes = System.IO.File.ReadAllBytes(fullName); string fileName = Path.GetFileName(""); return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, "abc Else Case")); } }
public JsonResult DeleteEmployee(int id) { objemployeeproperty = new EmployeeProperty(); objemployeeproperty.Id = id; objemployeeproperty.TableName = "tbl_Employee"; objemployeeproperty.Status = "Deleted"; objemployeeproperty.U_id = SessionManager.CurrentUser.ID; objEmployeeBll = new Employee_BLL(objemployeeproperty); var flag = objEmployeeBll.UpdateStatus(); if (flag) { return(Json(new { success = true, statuscode = 200, msg = "Successfull" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet)); } }
public void GetEmployeeInfo() { int employeeId = Convert.ToInt32(Session["Emp_ID"]); EmployeeProperty objemployeeproperty = new EmployeeProperty(); objemployeeproperty.Id = employeeId; Employee_BLL objEmployeeBll = new Employee_BLL(objemployeeproperty); DataTable dt = objEmployeeBll.SelectOne(); List <EmployeeProperty> EmployeeProperty = new List <EmployeeProperty>(); foreach (DataRow dr in dt.Rows) { EmployeeProperty objEmployeeProperty = new EmployeeProperty(); objEmployeeProperty.Casual_Leaves = Convert.ToInt32(dr["Casual_Leaves"].ToString()); objEmployeeProperty.Annual_Leaves = Convert.ToInt32(dr["Annual_Leaves"].ToString()); EmployeeProperty.Add(objEmployeeProperty); } ViewBag.EmployeeInfo = EmployeeProperty; }
public JsonResult AddEmployee(EmployeeProperty empployeepropertys) { //if (ModelState.IsValid) //{ //add new employee if (empployeepropertys.Id == null || empployeepropertys.Id <= 0) { if (empployeepropertys.ImageFile != null) { var file = empployeepropertys.ImageFile; UploadProfilePicture(empployeepropertys); } empployeepropertys.CreatedDate = DateTime.Now; empployeepropertys.IsActive = true; empployeepropertys.Status = "Active"; empployeepropertys.U_id = SessionManager.CurrentUser.ID; objEmployeeBll = new Employee_BLL(empployeepropertys); var flag = objEmployeeBll.Insert(); if (flag) { return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet)); } } //when id <0 update case else { if (empployeepropertys.ImageFile != null) { UploadProfilePicture(empployeepropertys); } empployeepropertys.CreatedDate = DateTime.Now; empployeepropertys.IsActive = true; empployeepropertys.Status = "Active"; objEmployeeBll = new Employee_BLL(empployeepropertys); empployeepropertys.U_id = SessionManager.CurrentUser.ID; if (empployeepropertys.Depandants != null) { try { var Depandant = JsonConvert.SerializeObject(empployeepropertys.Depandants); // List<RootObject> l = new List<RootObject>(); // List<Depandants_Property> myDeserializedObjList = (List<Depandants_Property>)JsonConvert.DeserializeObject(empployeepropertys.Depandants); List <RootObject> l = JsonConvert.DeserializeObject <List <RootObject> >(empployeepropertys.Depandants); var targetList = l.Select(x => new Depandants_Property() { ID = x.ID, Depand_Name = x.Depand_Name, RelationShip = x.RelationShip, Dob = Convert.ToDateTime(x.Dob), Medical = Convert.ToBoolean(x.Medical), Nic = x.Nic, Employee_Primary_Id = x.Employee_Primary_Id, Employee_Key = x.Employee_Key }) .ToList(); empployeepropertys.DepandantsList = UtilityClass.ToDataTable(targetList); } catch (Exception ex) { } } var flag = objEmployeeBll.Update(); if (flag) { return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet)); } } //} //when model state is not valid //else //{ // return Json(new { success = false, statuscode = 500, msg = "Please Enter According To Instructions" }, JsonRequestBehavior.AllowGet); // } }
public JsonResult AddTask(Project_Property Project) { if (ModelState.IsValid) { EmployeeProperty objempproperty = new EmployeeProperty(); objempproperty.Id = Project.Resource_Id; Employee_BLL objemployeebll = new Employee_BLL(objempproperty); DataTable dt = objemployeebll.SelectOne(); foreach (DataRow dr in dt.Rows) { Project.Employee_Cost = Math.Round(Convert.ToDecimal(dr["TotalSalary"].ToString()) / 270, 2); } //add new employee if (Project.Project_Id == null || Project.Project_Id <= 0) { Project.DateCreated = DateTime.Now; Project.Status = "Active"; Project.Is_Active = true; Project.In_Progress = false; Project.Is_Completed = false; Project.Remarks = ""; //Project.Employee_Cost= objProjectBll = new Project_BLL(Project); var flag = objProjectBll.InsertTask(); if (flag) { return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet)); } } //when id <0 update case else { Project.DateCreated = DateTime.Now; Project.Status = "Active"; objProjectBll = new Project_BLL(Project); var flag = objProjectBll.Insert(); if (flag) { return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet)); } } } //when model state is not valid else { var errors = ModelState.Select(x => x.Value.Errors) .Where(y => y.Count > 0) .ToList(); return(Json(new { success = false, statuscode = 500, msg = "Please Enter According To Instructions" }, JsonRequestBehavior.AllowGet)); } }