public bool CheckEmployeeID(string empid)
{
objemployeeproperty = new EmployeeProperty();
objemployeeproperty.Employee_ID = empid;
objEmployeeBll = new Employee_BLL(objemployeeproperty);
return(objEmployeeBll.CheckEmployeeID());
}
public void UploadProfilePicture(EmployeeProperty empprofilepic)
{
var file = empprofilepic.ImageFile;
string filename = "";
string filepath = "";
try
{
filename = System.IO.Path.GetFileName(System.IO.Path.GetRandomFileName() + file.FileName);
file.SaveAs(Server.MapPath("/ProfileImages/" + filename));
filepath = "/ProfileImages/" + filename;
//file.SaveAs(Server.MapPath(filepath));
string fullPath = Request.MapPath(empprofilepic.ImgPath);
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
empprofilepic.ImgPath = filepath;
}
catch (Exception ex)
{
}
}
public ActionResult AddEmployee()
{
GetDesignations();
GetDepartments();
GetEmptype();
string employeeid = RandomString(8);
if (CheckEmployeeID(employeeid))
{
AddEmployee();
}
else
{
objemployeeproperty = new EmployeeProperty()
{
Attndnc_id = 0,
Benefit1 = 0,
Benefit2 = 0,
Allownce1 = 0,
Allownce2 = 0,
Allownce3 = 0,
Total_Package = 0,
TotalSalary = 0
};
objemployeeproperty.Employee_ID = employeeid;
}
return(View(objemployeeproperty));
}
private void RemoveUncheckedEmployees()
{
foreach (var EmployeeProperty in ProjectAddcheckedListBox.Items)
{
if (ProjectAddcheckedListBox.CheckedItems.Contains(EmployeeProperty))
{
continue;
}
if (EmployeesOnProject.IsEmployeeOnProject(EmployeeProperty.ToString().GetOIBInCheck(), OldName))
{
EmployeesOnProject.Remove(EmployeesOnProject.GetRelation(EmployeeProperty.ToString().GetOIBInCheck(), OldName));
}
}
}
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 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 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"));
}
}
private void EmployeeDeleteButton_Click(object sender, EventArgs e)
{
var Employee = new List <Employees>();
foreach (var EmployeeProperty in EmployeeMenucheckedListBox.CheckedItems)
{
Employee.Add(EmployeesList.FindEmployeeByOIB(EmployeeProperty.ToString().GetOIBInCheck()));
}
if (Employee.Count == 0)
{
return;
}
if (DialogResult.Yes == MessageBox.Show("Jeste li sigurni da zelite izbrisati odabrane stavke?", "Oprez!", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation))
{
foreach (var employees in Employee)
{
DeleteEmployee(employees);
/*var ErrorCounter = 0;
* foreach (var Project in EmployeesOnProject.GetProjectsByEmployee(employee.OIB))
* {
* if (EmployeesOnProject.TryRemove(
* EmployeesOnProject.GetRelation(employee.OIB, Project.Name))) continue;
* ErrorCounter++;
* EmployeeDeleteError LastEmployeeError = new EmployeeDeleteError();
* LastEmployeeError.ShowDialog();
*
* break;
* }
* if (ErrorCounter == 0)
* EmployeesList.EmployeeDelete(employee);*/
}
}
RefreshEmployeesListBox();
}
public Employee_DAL(EmployeeProperty objEmp_prop)
{
objEmpProp = objEmp_prop;
}
public Employee_BLL(EmployeeProperty objEmp_Prop)
{
objEmpProp = objEmp_Prop;
}
private void btnOK_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(txtUserID.Text))
{
CommonClassLibraryGlobal.showError("กรุณากรอก UserID");
txtUserID.Focus();
return;
}
if (String.IsNullOrWhiteSpace(txtPassword.Text))
{
CommonClassLibraryGlobal.showError("กรุณากรอก Password");
txtPassword.Focus();
return;
}
if (txtUserID.Text.Substring(0, 1) != "S")
{
CommonClassLibraryGlobal.showError("UserID นี้ไม่สามารถแก้ไขข้อมูลได้");
txtPassword.Text = "";
txtUserID.Text = "";
txtUserID.Focus();
return;
}
EmployeeProperty employeeProperty = new EmployeeProperty();
employeeProperty.EmpCode = txtUserID.Text;
employeeProperty = employeeController.SearchOne(employeeProperty);
if (employeeProperty == null)
{
CommonClassLibraryGlobal.showError("ไม่พบข้อมูล UserID");
txtPassword.Text = "";
txtUserID.Text = "";
txtUserID.Focus();
return;
}
if (txtPassword.Text != "FL12345")
{
CommonClassLibraryGlobal.showError("UserID / Password ไม่ถูกต้อง");
txtPassword.Text = "";
txtUserID.Text = "";
txtUserID.Focus();
return;
}
CommonClassLibraryGlobal.OPERATOR_ID = txtUserID.Text;
switch (CommonClassLibraryGlobal.Login_TYPE_FORM)
{
case "Product Spec":
frmProductSpecSetting frmProduct = new frmProductSpecSetting();
frmProduct.ShowDialog();
this.Dispose();
frmProduct.Close();
break;
case "System Spec":
frmSystem frmSystem = new frmSystem();
frmSystem.ShowDialog();
this.Dispose();
frmSystem.Close();
break;
}
}
set => SetValue(EmployeeProperty, value);
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));
}
}
