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