public ActionResult Upload()
{
if (Request != null)
{
HttpPostedFileBase file = Request.Files["file-0"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
var salaryWorkingdayList = new List <SalaryWorkingday>();
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
if (currentSheet.Count() > 0)
{
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
var salaryWorkingday = new SalaryWorkingday();
salaryWorkingday.Month = Convert.ToInt32(workSheet.Cells[rowIterator, 1].Value.ToString()); //int
salaryWorkingday.Year = Convert.ToInt32(workSheet.Cells[rowIterator, 2].Value.ToString()); //int
salaryWorkingday.StaffCode = workSheet.Cells[rowIterator, 4].Value.ToString(); //string
salaryWorkingday.WorkingAdjusted = workSheet.Cells[rowIterator, 14].Value == null ? (double?)null : Convert.ToDouble(workSheet.Cells[rowIterator, 14].Value.ToString()); //double
salaryWorkingday.NoteAdjusted = workSheet.Cells[rowIterator, 15].Value == null ? null : workSheet.Cells[rowIterator, 15].Value.ToString(); //string
salaryWorkingdayList.Add(salaryWorkingday);
}
}
}
var db = new TimekeepingDal();
var result = db.ImportExcelSalaryWorkingday(salaryWorkingdayList);
if (result.IsSuccess == true)
{
result.Message = AppRes.ImportExcelSuccess;
}
else
{
result.Message = AppRes.ImportExcelFailed;
}
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
}
return(View("Index"));
}
public ActionResult _SaveTimeKeeping(SalaryWorkingday obj)
{
var db = new TimekeepingDal();
var result = db.SaveTimeKeeping(obj);
if (result.IsSuccess == true && obj.StaffID == 0)
{
result.Message = AppRes.MSG_INSERT_SUCCESSFUL;
}
else if (result.IsSuccess == true && obj.StaffID != 0)
{
result.Message = AppRes.MS_Update_success;
}
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public SystemMessage SaveTimeKeeping(SalaryWorkingday obj)
{
SystemMessage systemMessage = new SystemMessage();
try
{
var param = new DynamicParameters();
param.Add("@SalaryID", obj.AutoID);
param.Add("@StaffID", obj.StaffID);
param.Add("@month", obj.Month);
param.Add("@year", obj.Year);
param.Add("@WorkingAdjusted", obj.WorkingAdjusted);
param.Add("@NoteAdjusted", obj.NoteAdjusted);
UnitOfWork.ProcedureExecute("TimeKeeping_Save", param);
systemMessage.IsSuccess = true;
return(systemMessage);
}
catch (Exception e)
{
systemMessage.IsSuccess = false;
systemMessage.Message = e.ToString();
return(systemMessage);
}
}
