public ActionResult ExportData()
{
if (Session["acc"] == null)
{
return(View("../Register/index"));
}
ViewBag.ACCOUNT = Session["acc"].ToString();
Error.Error error = null;
string[] top10Events;
WebHTCBackEnd.Models.Events.THC_EventExport objExport = new Models.Events.THC_EventExport();
objExport.queryTop10Events(out top10Events, out error);
if (error != null)
{
//ERROR Page
return(View());
}
else
{
DataTable rewardData = null;
var lanSet = new Language.Event_Export();
lanSet.CurrentZone = THC_Library.Language.LanguageBase.CURRENT_LANGUAGE;
ViewData["lan"] = lanSet;
ViewBag.TOP10_EVENTS = top10Events;
//ViewBag.reward_types = classes.RewardType.GetRewardType(Language.LanguageBase.CURRENT_LANGUAGE);
//ViewBag.reward_venders = classes.RewardVender.GetRewardVender(Language.LanguageBase.CURRENT_LANGUAGE);
return(View(rewardData));
}
}
public ActionResult EventExportSearch(string event_no, string event_name)
{
if (Session["acc"] == null)
{
return(View("../Register/index"));
}
ViewBag.ACCOUNT = Session["acc"].ToString();
Error.Error error = null;
//string strEventKey, strEventNo, strEventName, strVenderNo, strVenderName;
string[] top10Events;
string eventKey;
WebHTCBackEnd.Models.Events.THC_EventExport objExport = new Models.Events.THC_EventExport();
DataTable exportData = objExport.queryExportSearch(event_no, event_name, out eventKey, out top10Events, out error);
if (error != null)
{
return(View());
}
else
{
var lanSet = new Language.Event_Export();
lanSet.CurrentZone = THC_Library.Language.LanguageBase.CURRENT_LANGUAGE;
ViewData["lan"] = lanSet;
//ViewBag.product_types = classes.ProductType.GetProductType(Language.LanguageBase.CURRENT_LANGUAGE);
ViewBag.s_event_no = event_no;
ViewBag.s_event_name = event_name;
ViewBag.TOP10_EVENTS = top10Events;
ViewBag.EVENT_KEY = eventKey;
//ViewBag.reward_venders = classes.RewardVender.GetRewardVender(Language.LanguageBase.CURRENT_LANGUAGE);
return(View("ExportData", exportData));
}
}
public JsonResult EventExportLog(string event_key, string event_name)
{
Error.Error error = null;
WebHTCBackEnd.Models.Events.THC_EventExport objExport = new Models.Events.THC_EventExport();
DataTable logData = objExport.queryExportLog(event_key, out error);
string retJson;
if (error != null)
{
retJson = Newtonsoft.Json.JsonConvert.SerializeObject(error);
}
else
{
retJson = Newtonsoft.Json.JsonConvert.SerializeObject(logData);
}
return(Json(retJson, "application/json", JsonRequestBehavior.AllowGet));
}
public JsonResult NewEventDownload()
{
var EventKey = Request.Form["event_key"];
var EventName = Request["event_name"];
var Employee = Request.Form["txt_employee"];
Error.Error error = null;
int iNewId;
string completeTime;
string fileName = string.Format("{0}_{1}.txt", EventName, DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss"));
string csvFileName = string.Format("{0}\\{1}",
Server.MapPath("~/exports"),
fileName);
if (System.IO.File.Exists(csvFileName))
{
System.IO.File.Delete(csvFileName);
}
WebHTCBackEnd.Models.Events.THC_EventExport objExport = new Models.Events.THC_EventExport();
DataTable exportTable = objExport.addNewExport(csvFileName, EventKey, Employee, out iNewId, out completeTime, out error);
string retJson;
if (error != null)
{
retJson = Newtonsoft.Json.JsonConvert.SerializeObject(error);
}
else
{
//DateTime datCompleteTime = DateTime.Parse(completeTime);
//string fileName = string.Format("{0}_{1}.csv", EventName, DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss"));
//string csvFileName = string.Format("{0}\\{1}",
// Server.MapPath("~/exports"),
// fileName);
//EQC001,EQC002,EQC003,EQC004,EQC005,EC,AEP003,AEP004,AEP005,AEP006,AE003,AE013,AE014
//if (System.IO.File.Exists(csvFileName))
//{
// System.IO.File.Delete(csvFileName);
//}
//System.IO.StreamWriter csvWrite = new System.IO.StreamWriter(csvFileName, false, System.Text.Encoding.UTF8);
//string strLine;
//foreach (DataRow row in exportTable.Rows)
//{
// //EQC001,EQC002,EQC003,EQC004,EQC005,EC,AEP003,AEP004,AEP005,AEP006,AEP011,AEP012,AEP013,AE002,AE003,AE013,AE014,AE019
// strLine = string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16}",
// row["EQC001"], row["EQC002"], row["EQC003"], row["EQC004"], row["EQC005"],
// row["EC"], row["AEP003"], row["AEP004"], row["AEP005"], row["AEP006"],row["AEP011"],
// row["AEP012"], row["AEP013"], row["AE002"], row["AE003"], row["AE013"], row["AE014"], row["AE019"]);
// csvWrite.WriteLine(strLine);
//}
//csvWrite.Close();
retJson = string.Format("[{{ \"NewId\" : {0}, \"DateTime\" : \"{1}\" ,\"FILE\" : \"{2}\" }}]",
iNewId, completeTime, fileName);
}
return(Json(retJson, "application/json", JsonRequestBehavior.AllowGet));
}
