public JsonResult getSalaryDeduction(int PageIndex, int PageSize, string Search, string Sort)
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
ArrayList paramList = new ArrayList();
var salaryDeductionList = dataContext.SalaryDeduction_tbl.Select(c => new
{
c.id,
c.DeductionType,
c.Create_by,
c.Create_Date,
Status = c.Status == 1 ? "Active" : "In Active",
}).ToList();
//Sort
if (Sort == "salaryDeductionAsc")
{
salaryDeductionList = salaryDeductionList.OrderBy(x => x.DeductionType).ToList();
}
if (Sort == "salaryDeductionDesc")
{
salaryDeductionList = salaryDeductionList.OrderByDescending(x => x.DeductionType).ToList();
}
if (Sort == "")
{
salaryDeductionList = salaryDeductionList.OrderByDescending(x => x.Create_Date).ToList();
}
int RowCount = dataContext.SalaryDeduction_tbl.Count();
int tottCount = dataContext.SalaryDeduction_tbl.Count();
//Search
if (!String.IsNullOrEmpty(Search))
{
salaryDeductionList = salaryDeductionList
.Where(s => s.DeductionType.ToLower().Contains(Search.ToLower()))
.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
}
else
{
salaryDeductionList = salaryDeductionList.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
}
int startnum = (PageIndex - 1) * PageSize + 1;
int endnum = PageIndex * PageSize;
RowCount = String.IsNullOrEmpty(Search) ? RowCount : salaryDeductionList.Count();
double lastpage = Math.Ceiling(Convert.ToDouble(RowCount) / Convert.ToDouble(PageSize));
paramList.Add(salaryDeductionList);
listViewModel list_count = new listViewModel {
RowCnt = RowCount, Start_Num = startnum, End_Num = endnum, TotCnt = tottCount, LastPage = lastpage
};
paramList.Add(list_count);
return(Json(paramList, JsonRequestBehavior.AllowGet));
}
}
public string AddUpdateBranch(Branch_tbl branch)
{
if (branch != null)
{
if (branch.id == 0)
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
branch.Create_by = 1;
branch.Create_Date = DateTime.Now;
dataContext.Branch_tbl.Add(branch);
try
{
dataContext.SaveChanges();
err = "Branch Added Successfully";
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
else
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
int no = Convert.ToInt32(branch.id);
var branchList = dataContext.Branch_tbl.Where(x => x.id == no).FirstOrDefault();
branchList.Branch_Code = branch.Branch_Code;
branchList.Branch_Name = branch.Branch_Name;
branchList.Status = branch.Status;
branchList.Update_by = 1;
branchList.Update_Date = DateTime.Now;
try
{
dataContext.SaveChanges();
return("Branch Updated Successfully");
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
}
else
{
err = "Invalid Item";
}
return(err);
}
public string AddUpdateSalaryDeduction(SalaryDeduction_tbl sHead)
{
if (sHead != null)
{
if (sHead.id == 0)
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
sHead.Create_by = 1;
sHead.Create_Date = DateTime.Now;
dataContext.SalaryDeduction_tbl.Add(sHead);
try
{
dataContext.SaveChanges();
err = "Salary Head Added Successfully";
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
else
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
int no = Convert.ToInt32(sHead.id);
var salaryHeadList = dataContext.SalaryDeduction_tbl.Where(x => x.id == no).FirstOrDefault();
salaryHeadList.DeductionType = sHead.DeductionType;
salaryHeadList.Status = sHead.Status;
salaryHeadList.Update_by = 1;
salaryHeadList.Update_Date = DateTime.Now;
try
{
dataContext.SaveChanges();
return("Salary Head Updated Successfully");
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
}
else
{
err = "Invalid Item";
}
return(err);
}
public List <SelectListItem> drp_branch()
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
var content = dataContext.Branch_tbl.Select(d => new { name = d.Branch_Name, id = d.id }).OrderBy(d => d.id);
var x = content.ToList().Select(c => new SelectListItem
{
Text = c.name.ToString(),
Value = c.id.ToString(),
}).ToList();
return(x);
}
}
public string AddUpdateDesignation(Designation_tbl design)
{
if (design != null)
{
if (design.id == 0)
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
design.Create_by = 1;
design.Create_Date = DateTime.Now;
dataContext.Designation_tbl.Add(design);
try
{
dataContext.SaveChanges();
err = "Designation Added Successfully";
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
else
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
int no = Convert.ToInt32(design.id);
var designationList = dataContext.Designation_tbl.Where(x => x.id == no).FirstOrDefault();
designationList.Designation = design.Designation;
designationList.Status = design.Status;
designationList.Update_by = 1;
designationList.Update_Date = DateTime.Now;
try
{
dataContext.SaveChanges();
return("Designation Updated Successfully");
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
}
else
{
err = "Invalid Item";
}
return(err);
}
public List <SelectListItem> drp_desi()
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
var content = dataContext.Designation_tbl.Select(d => new { desination = d.Designation, id = d.id }).OrderBy(d => d.desination);
var x = content.ToList().Select(c => new SelectListItem
{
Text = c.desination.ToString(),
Value = c.id.ToString(),
}).ToList();
return(x);
}
}
public JsonResult getSalaryDeductionById(string ID)
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
int no = Convert.ToInt32(ID);
var salaryDeductionList = dataContext.SalaryDeduction_tbl
.Where(p => p.id == no)
.Select(p => new salaryDeduction()
{
id = p.id.ToString(),
DeductionType = p.DeductionType,
Status = p.Status.ToString()
}).ToList();
return(Json(salaryDeductionList, JsonRequestBehavior.AllowGet));
}
}
public JsonResult getBranchById(string ID)
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
int no = Convert.ToInt32(ID);
var branchList = dataContext.Employee_tbl
.Where(p => p.id == no)
.Select(p => new Employee_tbl()
{
id = p.id,
First_Name = p.First_Name,
Last_Name = p.Last_Name,
Status = p.Status,
Present_Address1 = p.Present_Address1,
DOB = p.DOB,
DOJ = p.DOJ
}).ToList();
return(Json(branchList, JsonRequestBehavior.AllowGet));
}
}
public JsonResult getEmployeeById(Employee_tbl emp)
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
int no = emp.id;
var employee = (from e in dataContext.Employee_tbl
where e.id == no
select new
{
e.id,
Branch = e.Branch.ToString(),
e.First_Name,
e.Last_Name,
DOB = e.DOB.ToString(),
DOJ = e.DOJ.ToString(),
Designation = e.Designation.ToString(),
e.Employee_Code,
Gender = e.Gender.ToString(),
e.ProfileImage,
e.Email,
e.Mobile,
e.Permanent_Address1,
e.Present_Address1,
e.Permanent_Address2,
e.Present_Address2,
e.Permanent_City,
e.Present_City,
e.Permanent_State,
e.Present_State,
e.Present_Pincode,
e.Permanent_Pincode,
e.Account_No,
e.Bank_Name,
e.IFSC_Code,
e.Branch_Name,
e.User_Id,
Status = e.Status.ToString(),
}).ToList();
return(Json(employee, JsonRequestBehavior.AllowGet));
}
}
public string AddUpdateEmployee(Employee_tbl employee, HttpPostedFileBase file)
{
if (employee != null)
{
if (employee.id == 0)
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
var allowedExtensions = new[] {
".Jpg", ".png", ".jpg", "jpeg"
};
//tbl.Id = fc["Id"].ToString();
//tbl.Image_url = file.ToString(); //getting complete url
//tbl.Name = fc["Name"].ToString();
//var fileName = Path.GetFileName(file.FileName); //getting only file name(ex-ganesh.jpg)
//var ext = Path.GetExtension(file.FileName); //getting the extension(ex-.jpg)
//if (allowedExtensions.Contains(ext)) //check what type of extension
//{
// string name = Path.GetFileNameWithoutExtension(fileName); //getting file name without extension
// string myfile = name + "_" + tbl.Id + ext; //appending the name with id
// // store the file inside ~/project folder(Img)
// var path = Path.Combine(Server.MapPath("~/Img"), myfile);
// tbl.Image_url = path;
// obj.tbl_details.Add(tbl);
// obj.SaveChanges();
// file.SaveAs(path);
//}
employee.Create_by = 1;
employee.Create_Date = DateTime.Now;
dataContext.Employee_tbl.Add(employee);
try
{
dataContext.SaveChanges();
err = "employee Added Successfully";
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
else
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
int no = Convert.ToInt32(employee.id);
var empList = dataContext.Employee_tbl.Where(x => x.id == no).FirstOrDefault();
empList.Employee_Code = employee.Employee_Code;
empList.First_Name = employee.First_Name;
empList.Last_Name = employee.Last_Name;
empList.Gender = employee.Gender;
empList.DOB = employee.DOB;
empList.DOJ = employee.DOJ;
empList.Email = employee.Email;
empList.Mobile = employee.Mobile;
empList.Designation = employee.Designation;
empList.Branch = employee.Branch;
empList.Present_Address1 = employee.Present_Address1;
empList.Present_Address2 = employee.Present_Address2;
empList.Present_City = employee.Present_City;
empList.Present_State = employee.Present_State;
empList.Present_Pincode = employee.Present_Pincode;
empList.Permanent_Address1 = employee.Permanent_Address1;
empList.Permanent_Address2 = employee.Permanent_Address2;
empList.Permanent_City = employee.Permanent_City;
empList.Permanent_State = employee.Permanent_State;
empList.Permanent_Pincode = employee.Permanent_Pincode;
empList.Bank_Name = employee.Bank_Name;
empList.Account_No = employee.Account_No;
empList.IFSC_Code = employee.IFSC_Code;
empList.Branch_Name = employee.Branch_Name;
empList.Status = employee.Status;
empList.User_Id = employee.User_Id;
empList.Update_by = 1;
empList.Update_Date = DateTime.Now;
empList.ProfileImage = employee.ProfileImage;
try
{
dataContext.SaveChanges();
return("Employee Updated Successfully");
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
}
else
{
err = "Invalid Item";
}
return(err);
}
public JsonResult getEmployees(int PageIndex, int PageSize, string Search, string Sort)
{
using (PayRoll_Entities dataContext = new PayRoll_Entities())
{
ArrayList paramList = new ArrayList();
var employeesList = dataContext.Employee_tbl.Select(c => new
{
c.id,
c.Employee_Code,
c.First_Name,
c.Last_Name,
Name = c.First_Name + " " + c.Last_Name,
c.Designation,
c.Mobile,
Status = c.Status == 1 ? "Active" : "In Active",
}).ToList();
//Sort
if (Sort == "codeAsc")
{
employeesList = employeesList.OrderBy(x => x.Employee_Code).ToList();
}
if (Sort == "codeDesc")
{
employeesList = employeesList.OrderByDescending(x => x.Employee_Code).ToList();
}
if (Sort == "nameAsc")
{
employeesList = employeesList.OrderBy(x => x.First_Name).ToList();
}
if (Sort == "nameDesc")
{
employeesList = employeesList.OrderByDescending(x => x.First_Name).ToList();
}
if (Sort == "")
{
employeesList = employeesList.OrderByDescending(x => x.Employee_Code).ToList();
}
int RowCount = dataContext.Employee_tbl.Count();
int tottCount = dataContext.Employee_tbl.Count();
//Search
if (!String.IsNullOrEmpty(Search))
{
employeesList = employeesList
.Where(s => s.First_Name.ToLower().Contains(Search.ToLower()) || s.Employee_Code.ToLower().Contains(Search.ToLower()))
.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
}
else
{
employeesList = employeesList.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
}
int startnum = (PageIndex - 1) * PageSize + 1;
int endnum = PageIndex * PageSize;
RowCount = String.IsNullOrEmpty(Search) ? RowCount : employeesList.Count();
double lastpage = Math.Ceiling(Convert.ToDouble(RowCount) / Convert.ToDouble(PageSize));
paramList.Add(employeesList);
listViewModel list_count = new listViewModel {
RowCnt = RowCount, Start_Num = startnum, End_Num = endnum, TotCnt = tottCount, LastPage = lastpage
};
paramList.Add(list_count);
return(Json(paramList, JsonRequestBehavior.AllowGet));
}
}