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