public ActionResult Read_AvoidCallingTimeFrame([DataSourceRequest] DataSourceRequest request) { if (asset.View) { var data = DC_DetailAvoidCallingTimeFrame.GetAll(); return(Json(data.ToDataSourceResult(request))); } else { return(RedirectToAction("NoAccessRights", "Error")); } }
public ActionResult Export([DataSourceRequest] DataSourceRequest request) { if (asset.Export) { var data = DC_DetailAvoidCallingTimeFrame.GetAll().ToList(); IEnumerable datas = data.ToDataSourceResult(request).Data; //using (ExcelPackage excelPkg = new ExcelPackage()) FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportExcelFile\DC_AvoidCallingTimeCompany.xlsx")); var excelPkg = new ExcelPackage(fileInfo); ExcelWorksheet dataSheet = excelPkg.Workbook.Worksheets["AvoidCallingTimeCompany"]; int rowData = 1; foreach (DC_DetailAvoidCallingTimeFrame item in datas) { int i = 1; rowData++; dataSheet.Cells[rowData, i++].Value = item.Item; dataSheet.Cells[rowData, i++].Value = item.FromHour; dataSheet.Cells[rowData, i++].Value = item.ToHour; dataSheet.Cells[rowData, i++].Value = item.Monday; dataSheet.Cells[rowData, i++].Value = item.Tuesday; dataSheet.Cells[rowData, i++].Value = item.Wednesday; dataSheet.Cells[rowData, i++].Value = item.Thursday; dataSheet.Cells[rowData, i++].Value = item.Friday; dataSheet.Cells[rowData, i++].Value = item.Saturday; dataSheet.Cells[rowData, i++].Value = item.Sunday; dataSheet.Cells[rowData, i++].Value = item.RowCreatedUser; dataSheet.Cells[rowData, i++].Value = item.RowCreatedTime; dataSheet.Cells[rowData, i++].Value = item.RowLastUpdatedUser; dataSheet.Cells[rowData, i++].Value = item.RowLastUpdatedTime; } MemoryStream output = new MemoryStream(); excelPkg.SaveAs(output); string fileName = "DC_AvoidCallingTimeCompany_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"; string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; output.Position = 0; return(File(output.ToArray(), contentType, fileName)); } else { ModelState.AddModelError("", "You don't have permission to export data"); return(File("", //The binary data of the XLS file "application/vnd.ms-excel", //MIME type of Excel files "DC_AvoidCallingTimeCompany_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xls")); //Suggested file name in the "Save as" dialog which will be displayed to the end user } }
public ActionResult DeleteDetail(string data) { using (var dbConn = Helpers.OrmliteConnection.openConn()) if (asset.Delete) { int success = 0; int error = 0; try { string[] separators = { "@@" }; var listRowID = data.Split(separators, StringSplitOptions.RemoveEmptyEntries); var data1 = new DC_DetailAvoidCallingTimeFrame(); foreach (var item in listRowID) { //var checkexist = dbConn.Select<DC_Org_AvoidCallingTime>("SELECT TOP 1 * FROM DC_Org_AvoidCallingTime WHERE DetailHeaderID = '" + item + "'").FirstOrDefault(); //if (checkexist == null) //{ data1.Id = Int32.Parse(item); dbConn.Delete(data1); success++; //} //else //{ // error++; // return Json(new { success = false, alert = "You can't delete this record" }); //} } success++; } catch (Exception ex) { return(Json(new { success = false, alert = ex.Message })); } return(Json(new { success = true, totalSuccess = success, totalError = error })); } else { return(Json(new { success = false, alert = "You don't have permission to delete record" })); } }
public ActionResult Save_DetailAvoidCallingTimeFrame([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <DC_DetailAvoidCallingTimeFrame> listDetailAvoiCalling, string HeaderID) { using (var dbConn = Helpers.OrmliteConnection.openConn()) using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted)) if (asset.Create) { try { if (listDetailAvoiCalling != null && ModelState.IsValid) { foreach (var de in listDetailAvoiCalling) { //if (String.IsNullOrEmpty(de.FromHourDate.ToString()) || String.IsNullOrEmpty(de.ToHourDate.ToString())) //{ // ModelState.AddModelError("", "Please input FromHour or ToHour name"); // return Json(listDetailAvoiCalling.ToDataSourceResult(request, ModelState)); //} string id = ""; var data = new DC_DetailAvoidCallingTimeFrame(); var checkID = dbConn.Select <DC_DetailAvoidCallingTimeFrame>("SELECT * FROM dbo.DC_DetailAvoidCallingTimeFrame ORDER BY Id DESC").FirstOrDefault(); if (checkID != null) { var nextNo = Int32.Parse(checkID.DetailHeaderID.Substring(5, checkID.DetailHeaderID.Length - 5)) + 1; id = "DACTF" + String.Format("{0:00000}", nextNo); } else { id = "DACTF00001"; } data.DetailHeaderID = id; data.HeaderID = HeaderID; data.FromHour = de.FromHour; data.ToHour = de.ToHour; data.RowCreatedTime = DateTime.Now; data.RowCreatedUser = currentUser.UserName; data.RowLastUpdatedTime = DateTime.Parse("1900-01-01"); data.RowLastUpdatedUser = ""; dbConn.Insert(data); } dbTrans.Commit(); return(Json(new { success = true })); } else { ModelState.AddModelError("error", ""); dbTrans.Rollback(); return(Json(new { success = false })); } } catch (Exception e) { ModelState.AddModelError("error", e.Message); dbTrans.Rollback(); return(Json(listDetailAvoiCalling.ToDataSourceResult(request, ModelState))); } } else { ModelState.AddModelError("", "You don't have permission to create record"); dbTrans.Rollback(); return(Json(listDetailAvoiCalling.ToDataSourceResult(request, ModelState))); } }