public ActionResult Index(TIMEKEEPINGREPORT rp)
{
var tIMEKEEPINGREPORTs = db.TIMEKEEPINGREPORTs.Where(x => x.Month == rp.Month).ToList();
if (tIMEKEEPINGREPORTs == null)
{
return(View());
}
return(View(tIMEKEEPINGREPORTs));
}
public ActionResult UploadExcel(TIMEKEEPINGREPORT timekeepingsRP, HttpPostedFileBase FileUpload)
{
List <string> data = new List <string>();
if (FileUpload != null)
{
// tdata.ExecuteCommand("truncate table OtherCompanyAssets");
if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
string filename = FileUpload.FileName;
string targetpath = Server.MapPath("~/Doc/");
FileUpload.SaveAs(targetpath + filename);
string pathToExcelFile = targetpath + filename;
var connectionString = "";
if (filename.EndsWith(".xls"))
{
connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile);
}
else if (filename.EndsWith(".xlsx"))
{
connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile);
}
var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);
var ds = new DataSet();
adapter.Fill(ds, "ExcelTable");
DataTable dtable = ds.Tables["ExcelTable"];
string sheetName = "Sheet1";
var excelFile = new ExcelQueryFactory(pathToExcelFile);
var artistAlbums = from a in excelFile.Worksheet <TIMEKEEPINGREPORT>(sheetName) select a;
//DateTime date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 12, 0, 0, 0, 0);
foreach (var a in artistAlbums)
{
if (db.TIMEKEEPINGREPORTs.Count(x => x.EmployeeID == a.EmployeeID && x.Month == timekeepingsRP.Month) == 0)
{
try
{
if (a.EmployeeID != null)
{
TIMEKEEPINGREPORT TU = new TIMEKEEPINGREPORT();
TU.Month = timekeepingsRP.Month;
TU.EmployeeID = a.EmployeeID;
TU.SumWorkDay = a.SumWorkDay;
TU.SumAbsentHaveSalary = a.SumAbsentHaveSalary;
TU.SumAbsentNoSalary = a.SumAbsentNoSalary;
TU.SumHourNormal = a.SumHourNormal;
TU.SumHourDayOff = a.SumHourDayOff;
TU.SumHourSpecialDayOff = a.SumHourSpecialDayOff;
TU.SumHourNightSpecialDayOff = a.SumHourNightSpecialDayOff;
//TU.SumHourNightSpecialDayOffExtra = a.SumHourNightSpecialDayOff;
TU.SumHourNightNormal = a.SumHourNightNormal;
//TU.SumHourNightNormalExtra = a.SumHourNightNormalExtra;
TU.SumHourNightDayOff = a.SumHourNightDayOff;
//TU.SumHourNightDayOffExtra = a.SumHourNightDayOffExtra;
db.TIMEKEEPINGREPORTs.Add(TU);
db.SaveChanges();
}
else
{
break;
}
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
else
{
continue;
}
}
//deleting excel file from folder
if ((System.IO.File.Exists(pathToExcelFile)))
{
System.IO.File.Delete(pathToExcelFile);
}
return(RedirectToAction("Index"));
}
else
{
return(Content("<script language='javascript' type='text/javascript'>alert('Format file không đúng');</script>"));
}
}
else
{
return(Content("<script language='javascript' type='text/javascript'>alert('Chưa có file');</script>"));
}
}
public int CalculateNightNormalOvertimeSalary(TIMEKEEPINGREPORT rp, int hourPay)
{
return((int)(hourPay * rp.SumHourNightNormal * db.PARAMETERs.Find("HSLDemNgayThuong").Value / 100));
}
public int CalculateNightSpecialDayOffOvertimeSalary(TIMEKEEPINGREPORT rp, int hourPay)
{
return((int)(hourPay * rp.SumHourNightSpecialDayOff * db.PARAMETERs.Find("HSLDemNgayNghiCoLuong").Value / 100));
}
public int CalculateDayOffOvertimeSalary(TIMEKEEPINGREPORT rp, int hourPay)
{
return((int)(hourPay * rp.SumHourDayOff * db.PARAMETERs.Find("HSLNgayNghi").Value / 100));
}
