public JsonResult templateUpload(HttpPostedFileBase file,string tmpData) { string tmpTable = tmpData.Split(',')[0]; string colRange = tmpData.Split(',')[1]; try { dcAppProfile dc = new dcAppProfile(); appProfile ap = dc.GetInfo(); excelConnectionString = ap.excel_conn_str; var path = "c:\\temp\\"; var fullPath = path; if (file != null && file.ContentLength > 0) { if (Directory.Exists(ap.excel_folder)) path = ap.excel_folder; var fileName = Path.GetFileName(file.FileName); fullPath = Path.Combine(path, fileName); file.SaveAs(fullPath); DataHelper.execute("temp_data_del @table_name='" + tmpTable + "'", false); MigrateExcelFile(fullPath, colRange, tmpTable); DataHelper.execute("temp_data_upd @table_name='" + tmpTable + "'", false); } } catch (Exception ex) { return Json(new { isSuccess = false, errMsg = ex.Message }); } return Json(new { isSuccess = true, msg = "ok" }); }
public ActionResult Index() { if (Session["isAuthenticated"] != null) { using (new impersonate()) { dcAppProfile dc = new dcAppProfile(); appProfile info = dc.GetInfo(); return Redirect(Url.Content("~/") + "page/name/" + info.default_page); } } else return View(); }
public ActionResult loginAdmin() { if (Request["user_name"] == "zsidev" && Request["user_pwd"] == "1&7TBbyX") { dcAppProfile dc = new dcAppProfile(); appProfile info = dc.GetInfo(); Session["zsi_login"] = "******"; Response.Cookies["zsi_login"].Value = "Y"; Response.Cookies["zsi_login"].Expires = DateTime.Now.AddDays(1); return Redirect("/page/name/" + info.default_page); } else { Session["zsi_login"] = "******"; return Redirect("/page/name/zsiUserLogin"); } }
public ActionResult Index() { dcAppProfile dc = new dcAppProfile(); appProfile info = dc.GetInfo(); return Redirect("/page/name/" + info.default_page); }
public ContentResult checkFile(string fileName) { appProfile ap = new dcAppProfile().GetInfo(); var path = "c:\\temp\\"; if (Directory.Exists(ap.image_folder)) path = ap.image_folder; var fullPath = Path.Combine(path, fileName); return Content(System.IO.File.Exists(fullPath).ToString(), "text/plain", System.Text.Encoding.UTF8); }
public FileResult loadFile(string fileName) { appProfile ap = new dcAppProfile().GetInfo(); var path = "c:\\temp\\"; if (Directory.Exists(ap.image_folder)) path = ap.image_folder; var fullPath = Path.Combine(path, fileName); string contentType = MimeMapping.GetMimeMapping(fileName); return File(fullPath, contentType); }
public JsonResult UploadImage(HttpPostedFileBase file, string prefixKey) { try { appProfile ap = new dcAppProfile().GetInfo(); var path = "c:\\temp\\"; var fullPath = path; var fileNameOrg = ""; if (file != null && file.ContentLength > 0) { if (Directory.Exists(ap.image_folder)) path = ap.image_folder; fileNameOrg = Path.GetFileName(file.FileName); fullPath = Path.Combine(path, prefixKey + fileNameOrg); file.SaveAs(fullPath); } } catch (Exception ex) { return Json(new { isSuccess = false, errMsg = ex.Message }); } return Json(new { isSuccess = true, msg = "ok" }); }
public JsonResult projectImageUpload(HttpPostedFileBase file, HttpPostedFileBase file_thumbnail, int project_id) { try { appProfile ap = new dcAppProfile().GetInfo(); var path = "c:\\temp\\"; var fullPath = path; var fileNameThumbNails = ""; var fileNameOrg = ""; if (file_thumbnail != null && file_thumbnail.ContentLength > 0) { if (Directory.Exists(ap.image_folder)) path = ap.image_folder; fileNameThumbNails = Path.GetFileName(file_thumbnail.FileName); fullPath = Path.Combine(path + "thumbnails\\", fileNameThumbNails); file_thumbnail.SaveAs(fullPath); } if (file != null && file.ContentLength > 0) { if (Directory.Exists(ap.image_folder)) path = ap.image_folder; fileNameOrg = Path.GetFileName(file.FileName); fullPath = Path.Combine(path, fileNameOrg); file.SaveAs(fullPath); } DataHelper.toJSON( "dbo.image_file_project_upd @project_id=" + project_id + ",@img_filename_thumbnail='" + fileNameThumbNails + "'" + ",@img_filename_org='" + fileNameOrg + "'" , false); } catch (Exception ex) { return Json(new { isSuccess = false, errMsg = ex.Message }); } return Json(new { isSuccess = true, msg = "ok" }); }
public ActionResult viewImage(string fileName, string isThumbNail = "n") { appProfile ap = new dcAppProfile().GetInfo(); var path = "c:\\temp\\"; var fullPath = path; if (Directory.Exists(ap.image_folder)) path = ap.image_folder; if (isThumbNail.ToLower() == "y") path = path + "thumbnails\\"; fullPath = Path.Combine(path, fileName); if (!System.IO.File.Exists(fullPath)) fullPath = "/images/no-image.jpg"; return base.File(fullPath, "image/jpeg"); }