public GenericValidator EditCompany(ImporterObject company)
{
var gVal = new GenericValidator();
try
{
var appStatus = new ImporterServices().UpdateImporter(company);
if (appStatus < 1)
{
gVal.Code = -1;
gVal.Error = appStatus == -2 ? "Company failed. Please try again." : "Company Information already exists";
return(gVal);
}
gVal.Code = appStatus;
gVal.Error = "Company was successfully updated.";
return(gVal);
}
catch (Exception)
{
gVal.Error = "Company processing failed. Please try again later";
gVal.Code = -1;
return(gVal);
}
}
public ActionResult Index(string id)
{
int noPages = 0, noRecords = 0;
BlockUIExcelUploadModel uiModel = new BlockUIExcelUploadModel();
try
{
uiModel.CurrentPage = Int32.Parse(Request.Params["page"]);
}
catch (Exception)
{
uiModel.CurrentPage = 1;
}
this.CheckPermission();
ViewData["pagename"] = "upload_excel";
ViewData["action_block"] = "Excels/block_upload_excel";
this.SetCommonData();
this.GetLanguage();
//DECLARE PAGE MODEL
BI_Project.Models.UI.PageModel pageModel = new Models.UI.PageModel("upload_excel");
pageModel.SetLanguage(this.LANGUAGE_OBJECT);
pageModel.H1Title = pageModel.GetElementByPath("page_excel.menu" + id + ".h1");
pageModel.Title = pageModel.GetElementByPath("page_excel.menu" + id + ".title");
ViewData["page_model"] = pageModel;
BlockLangExcelUpload blockLang = new BlockLangExcelUpload();
BI_Project.Models.UI.BlockModel blockModel = new Models.UI.BlockModel("block_upload_excel", this.LANGUAGE_OBJECT, blockLang);
BlockDataExcelUploadModel blockData = new BlockDataExcelUploadModel();
blockData.PermissionID = id;
//BI_Project.Helpers.Utility.JTokenHelper.GetLanguage("~/" + this.LANGUAGE_FOLDER, this.LANGUAGE);
string xmlConfigFilePath = this.CONFIG_FOLDER + "\\excel_format_" + blockData.PermissionID.ToString() + ".xml";
blockData.HelpDoc = BI_Project.Helpers.Utility.JTokenHelper.GetElementValue(xmlConfigFilePath, "excel_source.HelpDocumentPath");
blockData.Note = BI_Project.Helpers.Utility.JTokenHelper.GetElementValue(xmlConfigFilePath, "excel_source.Note.#cdata-section");
ImporterServices services = new ImporterServices(this.DBConnection);
blockData.ListHistory = services.GetHistoryList(uiModel.CurrentPage, uiModel.PerPage, id, ref noPages, ref noRecords, uiModel.Month, uiModel.Year);
blockData.NumberPages = noPages;
blockData.NumberRecords = noPages;
blockData.CurrentPage = uiModel.CurrentPage;
blockData.FolderUpload = pageModel.GetElementByPath("page_excel.menu" + id + ".UploadedDirectory");
blockModel.DataModel = blockData;
//blockModel.DataModel = ViewData["block_menu_left_data"];
if (services.ERROR != null)
{
FileHelper.SaveFile(services.ERROR, this.LOG_FOLDER + "/ERROR_" + this.GetType().ToString() + APIStringHelper.GenerateFileId() + ".txt");
}
ViewData["BlockData"] = blockModel;
return(View("~/" + this.THEME_FOLDER + "/" + this.THEME_ACTIVE + "/index.cshtml"));
}
public ActionResult Import(FileUploadModel model)
{
this.GetLanguage();
//DECLARE PAGE MODEL
try
{
//************************** CHECK PERMISSION **************************
this.SetConnectionDB();
//var test = model.FileObj;
//************************** GET CONFIG
ImporterServices services = new ImporterServices(this.DBConnection, this.CONNECT_STRING_STAGING);
string tablename = "", sheetActive = "", uploadFolder = "", fileNativeName = "";
string note = "", helpDocumentPath = "";
int startRow = 0, numberRow = 0, numberCell = 0;
List <string> lstCellName = new List <string>();
string xmlFilePath = this.CONFIG_FOLDER + "\\excel_format_" + model.PermissionId.ToString() + ".xml";
List <MappingExcelDB> lstColumns = services.GetColumnList(xmlFilePath, ref uploadFolder, ref tablename,
ref startRow, ref sheetActive, ref helpDocumentPath, ref note, ref fileNativeName, ref numberRow, ref numberCell, ref lstCellName);
//************************** UPLOAD FILE TO THE UPLOAD FOLDER***********************************************
string excelfilename = BI_Project.Helpers.Utility.APIStringHelper.GenerateId() + Path.GetExtension(model.FileObj.FileName);
string excelFilePath = System.Web.Hosting.HostingEnvironment.MapPath(this.EXCEL_UPLOAD_FOLDER) + uploadFolder + "/" + excelfilename;
model.FileObj.SaveAs(excelFilePath);
//************************ INSERT DATA TO DATABASE ********************
int userid = (int)Session[this.SESSION_NAME_USERID];
int uploadRoleId = model.PermissionId;
//services.Import2Database(userid,excelFilePath, tablename, startRow, sheetActive,helpDocumentPath,
// note,fileNativeName,fileNativeName,uploadRoleId, lstColumns,excelfilename);
services.Import2Database(userid, excelFilePath, tablename, startRow, sheetActive, helpDocumentPath,
note, fileNativeName, fileNativeName, uploadRoleId, lstColumns, excelfilename, numberRow, numberCell, lstCellName);
if (services.ERROR != null)
{
throw new Exception(services.ERROR);
}
Session["msg_text"] = BlockLanguageModel.GetElementLang(this.LANGUAGE_OBJECT, "messages.block_upload_excel.success");
Session["msg_code"] = 1;
}
catch (Exception ex)
{
FileHelper.SaveFile(new { ERROR = ex }, this.LOG_FOLDER + "/ERROR_" + this.GetType().ToString() + APIStringHelper.GenerateFileId() + ".txt");
Session["msg_text"] = BlockLanguageModel.GetElementLang(this.LANGUAGE_OBJECT, "messages.block_upload_excel.error");
Session["msg_code"] = -1;
}
return(RedirectToAction("Index/" + model.PermissionId));
}
public ActionResult GetUserRecertificationObjects(JQueryDataTableParamModel param)
{
try
{
//get the id of logged in user
var userId = User.Identity.GetUserId();
var importer = new ImporterServices().GetImporterByLoggedOnUser(userId, true);
var importerId = importer.Id;
IEnumerable <RecertificationObject> filteredParentMenuObjects;
var countG = 0;
var pagedParentMenuObjects = GetUserRecertifications(param.iDisplayLength, param.iDisplayStart, out countG, importerId);
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredParentMenuObjects = new RecertificationServices().Search(param.sSearch, importerId);
}
else
{
filteredParentMenuObjects = pagedParentMenuObjects;
}
if (!filteredParentMenuObjects.Any())
{
return(Json(new List <RecertificationObject>(), JsonRequestBehavior.AllowGet));
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <RecertificationObject, string> orderingFunction = (c => sortColumnIndex == 1 ? c.ReferenceCode : c.DateApplied.ToString());
var sortDirection = Request["sSortDir_0"]; // asc or desc
filteredParentMenuObjects = sortDirection == "desc" ? filteredParentMenuObjects.OrderBy(orderingFunction) : filteredParentMenuObjects.OrderByDescending(orderingFunction);
var displayedPersonnels = filteredParentMenuObjects;
var result = from c in displayedPersonnels
select new[] { Convert.ToString(c.Id), c.ReferenceCode, c.DateApplied.ToString(), c.StatusStr };
return(Json(new
{
param.sEcho,
iTotalRecords = countG,
iTotalDisplayRecords = countG,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(Json(new List <RecertificationObject>(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetImporterObjects(JQueryDataTableParamModel param)
{
try
{
IEnumerable <ImporterObject> filteredParentMenuObjects;
var countG = 0;
var pagedParentMenuObjects = GetImporters(param.iDisplayLength, param.iDisplayStart, out countG);
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredParentMenuObjects = new ImporterServices().Search(param.sSearch);
countG = filteredParentMenuObjects.Count();
}
else
{
filteredParentMenuObjects = pagedParentMenuObjects;
}
if (!filteredParentMenuObjects.Any())
{
return(Json(new List <ImporterObject>(), JsonRequestBehavior.AllowGet));
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <ImporterObject, string> orderingFunction = (c => sortColumnIndex == 1 ? c.Name : sortColumnIndex == 2 ? c.TIN : sortColumnIndex == 3 ? c.RCNumber : sortColumnIndex == 4? c.DateAdded : c.StatusStr);
var sortDirection = Request["sSortDir_0"]; // asc or desc
filteredParentMenuObjects = sortDirection == "desc" ? filteredParentMenuObjects.OrderBy(orderingFunction) : filteredParentMenuObjects.OrderByDescending(orderingFunction);
var displayedPersonnels = filteredParentMenuObjects;
var result = from c in displayedPersonnels
select new[] { Convert.ToString(c.Id), c.Name, c.TIN, c.RCNumber, c.DateAdded, c.StatusStr };
return(Json(new
{
param.sEcho,
iTotalRecords = countG,
iTotalDisplayRecords = countG,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(Json(new List <ImporterObject>(), JsonRequestBehavior.AllowGet));
}
}
private List <NotificationObject> getRecertificationObjects()
{
//get the id of logged in user
var userId = User.Identity.GetUserId();
var importer = new ImporterServices().GetImporterByLoggedOnUser(userId, true);
var importerId = importer.Id;
try
{
return(new NotificationServices().GetCompletedNotifications(importerId));
}
catch (Exception)
{
return(new List <NotificationObject>());
}
}
public ActionResult GetImporter(long id)
{
try
{
var importer = new ImporterServices().GetImporter(id);
if (importer == null || importer.Id < 1)
{
return(Json(new ImporterObject(), JsonRequestBehavior.AllowGet));
}
return(Json(importer, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new ImporterObject(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult SetImporterId(long id)
{
var gVal = new GenericValidator();
if (id < 1)
{
gVal.Code = -1;
gVal.Error = "Your session has timed out.";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
var importer = new ImporterServices().GetImporter(id);
if (importer == null || importer.Id < 1)
{
gVal.Code = -1;
gVal.Error = "An error was encountered.";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
Session["_importerId"] = id;
gVal.Code = 5;
gVal.Error = importer.Name;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
