public Int64 UpdateEmployeeDetl(Int64 EmpSalryID, Int64 Emp_ID, double EmpSalary, Int32 MonthID, Int32 year, bool Status, DateTime DateAdd) { Int64 intValue = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblEmpSalary objSal = (from mast in db.tblEmpSalaries where mast.EmpSal_ID == EmpSalryID select mast).FirstOrDefault(); if (objSal != null) { objSal.EmpSal_EmpID = Emp_ID; objSal.EmpSal_Salary = EmpSalary; objSal.EmpSal_Month = MonthID; objSal.EmpSal_Year = year; objSal.EmpSal_Status = Status; objSal.Date_Modified = DateAdd; //if (IsExists(EmpName, EmpSalryID) == true) //{ // intValue = -1; //} //else //{ db.SaveChanges(); intValue = EmpSalryID; //} } } return(intValue); }
public Int64 InsertEmployeeDetl(Int64 Emp_ID, double EmpSalary, Int32 MonthID, Int32 year, bool Status, DateTime DateAdd) { Int64 intValue = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblEmpSalary objSal = new tblEmpSalary(); objSal.EmpSal_EmpID = Emp_ID; objSal.EmpSal_Salary = EmpSalary; objSal.EmpSal_Month = MonthID; objSal.EmpSal_Year = year; objSal.EmpSal_Status = Status; objSal.Date_Added = DateAdd; //if (IsExists(EmpName, 0) == true) //{ // intValue = -1; //} //else //{ db.tblEmpSalaries.AddObject(objSal); db.SaveChanges(); intValue = objSal.EmpSal_ID; // } } return(intValue); }
public DataTable addData(DataTable data, string loaihopdong) { foreach (DataRow row in data.Rows) { if (row != null) { string loaiHD = ""; tblEmpContract empCT = null; if (loaihopdong == "0" || loaihopdong == "1") { loaiHD = "TV"; empCT = db.tblEmpContracts.Where(p => p.EmployeeID == row["EmployeeID"].ToString() && p.ContractID != null && p.ContractID.Length > 2 && p.ContractID.Substring(0, 2).ToUpper() == "TV" ).OrderByDescending(p => p.BeginDate).FirstOrDefault(); } if (loaihopdong == "2" || loaihopdong == "3") { loaiHD = "CT"; empCT = db.tblEmpContracts.Where(p => p.EmployeeID == row["EmployeeID"].ToString() && p.ContractID != null && p.ContractID.Length > 2 && p.ContractID.Substring(0, 2).ToUpper() == "CT" && p.ContractTypeID == "05" ).OrderByDescending(p => p.BeginDate).FirstOrDefault(); } if (loaihopdong == "4" || loaihopdong == "5") { loaiHD = "CT"; empCT = db.tblEmpContracts.Where(p => p.EmployeeID == row["EmployeeID"].ToString() && p.ContractID != null && p.ContractID.Length > 2 && p.ContractID.Substring(0, 2).ToUpper() == "CT" && p.ContractTypeID == "14" ).OrderByDescending(p => p.BeginDate).FirstOrDefault(); } if (empCT != null) { row["TuNgay"] = empCT.BeginDate.ToString("dd/MM/yyyy"); row["DenNgay"] = empCT.EndDate.Value.ToString("dd/MM/yyyy"); tblEmpSalary empSal = db.tblEmpSalaries.Where(p => p.EmployeeID == row["EmployeeID"].ToString() && p.DateChange >= empCT.BeginDate && p.DateChange <= empCT.EndDate && p.ContractCode != null && p.ContractCode != "" && p.ContractCode.Length > 2 && p.ContractCode.Substring(0, 2).ToUpper() == loaiHD ).OrderBy(p => p.DateChange).FirstOrDefault(); if (empSal != null) { row["BasicSalary"] = empSal.BasicSalary; row["RegularAllowance"] = empSal.BasicSalary_Ins; } } } } return(data); }
public Int32 Delete(Int32 Emp_ID) { Int32 retVal = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblEmpSalary objsal = (from obj in db.tblEmpSalaries where obj.EmpSal_ID == Emp_ID select obj).FirstOrDefault(); if (objsal != null) { db.tblEmpSalaries.DeleteObject(objsal); db.SaveChanges(); retVal = Emp_ID; } } return(retVal); }
public Int32 UpdateStatus(Int32 Emp_ID, bool bStatus) { Int32 intValue = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblEmpSalary objSal = (from mast in db.tblEmpSalaries where mast.EmpSal_ID == Emp_ID select mast).FirstOrDefault(); if (objSal != null) { objSal.EmpSal_Status = bStatus; db.SaveChanges(); intValue = Emp_ID; } } return(intValue); }
public DataTable addData(DataTable data, string loaihopdong) { foreach (DataRow row in data.Rows) { string depID = row["DepID"].ToString(); string depParent = db.tblRef_Departments.Where(p => p.DepID == depID).First().DepParent; if (db.tblRef_Departments.Where(p => p.DepID == depParent).First().DepName == "Khối văn phòng / Office") { row["TgTu"] = "08:00 AM"; row["TgDen"] = "05:00 PM"; } else { row["TgTu"] = "07:30 AM"; row["TgDen"] = "04:30 PM"; } if (row != null) { tblEmpContract empCT = null; string loaiHD = ""; if (loaihopdong == "0" || loaihopdong == "1") { loaiHD = "TV"; empCT = db.tblEmpContracts.Where(p => p.EmployeeID == row["EmployeeID"].ToString() && p.ContractID != null && p.ContractID.Length > 2 && p.ContractID.Substring(0, 2).ToUpper() == "TV" ).OrderByDescending(p => p.BeginDate).FirstOrDefault(); } if (loaihopdong == "2" || loaihopdong == "3") { loaiHD = "CT"; empCT = db.tblEmpContracts.Where(p => p.EmployeeID == row["EmployeeID"].ToString() && p.ContractID != null && p.ContractID.Length > 2 && p.ContractID.Substring(0, 2).ToUpper() == "CT" && p.ContractTypeID == "05" ).OrderByDescending(p => p.BeginDate).FirstOrDefault(); } if (loaihopdong == "4" || loaihopdong == "5") { loaiHD = "CT"; empCT = db.tblEmpContracts.Where(p => p.EmployeeID == row["EmployeeID"].ToString() && p.ContractID != null && p.ContractID.Length > 2 && p.ContractID.Substring(0, 2).ToUpper() == "CT" && p.ContractTypeID == "14" ).OrderByDescending(p => p.BeginDate).FirstOrDefault(); } if (empCT != null) { row["TuNgay"] = empCT.BeginDate.ToString("dd/MM/yyyy"); row["DenNgay"] = empCT.EndDate.Value.ToString("dd/MM/yyyy"); tblEmpSalary empSal = db.tblEmpSalaries.Where(p => p.EmployeeID == row["EmployeeID"].ToString() && p.DateChange >= empCT.BeginDate && p.DateChange <= empCT.EndDate && p.ContractCode != null && p.ContractCode != "" && p.ContractCode.Length > 2 && p.ContractCode.Substring(0, 2).ToUpper() == loaiHD ).OrderBy(p => p.DateChange).FirstOrDefault(); if (empSal != null) { row["BasicSalary"] = empSal.BasicSalary; } } } } return(data); }