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