public SYS_tblImportFileConfigDRO ImportDataRow(string Username, string InputData, string StoreProcedure) { SYS_tblImportFileConfigDRO result = new SYS_tblImportFileConfigDRO(); try { using (var scope = Container.BeginLifetimeScope()) { string temp = ""; var db = scope.Resolve<ISYS_tblImportFileConfigDAO>(); Dictionary<string, string> input = JsonConvert.DeserializeObject<Dictionary<string, string>>(InputData); temp = db.ImportDataRow(input, StoreProcedure); result.ResponseItem = new DCO.ResponseItem { Result = string.IsNullOrEmpty(temp) ? true : false, Status = string.IsNullOrEmpty(temp) ? DCO.ResponseStatus.Success : DCO.ResponseStatus.Failure, Message = string.IsNullOrEmpty(temp) ? string.Empty : temp, RequestUser = Username, TotalItemCount = string.IsNullOrEmpty(temp) ? 1 : 0 }; } } catch (Exception ex) { result.ResponseItem = new DCO.ResponseItem { Result = false, Status = DCO.ResponseStatus.Exception, Message = "Import data failed because: " + ex.Message, RequestUser = Username, TotalItemCount = 0 }; logger.Error(ex); } return result; }
public SYS_tblImportFileConfigDRO CheckValidImportTemplate(string Username, string LanguageID, string StoreProcedure, string FileName, string ModuleID, string FunctionID) { SYS_tblImportFileConfigDRO result = new SYS_tblImportFileConfigDRO(); try { using (var scope = Container.BeginLifetimeScope()) { SYS_tblImportFileConfigDTO temp = new SYS_tblImportFileConfigDTO(); var db = scope.Resolve<ISYS_tblImportFileConfigDAO>(); temp = db.CheckValidImportTemplate(Username, LanguageID, StoreProcedure, FileName, ModuleID, FunctionID); if (temp != null) { result.ImportFileConfigItem = Mapper.Map<SYS_tblImportFileConfigDCO>(temp); result.ResponseItem = new DCO.ResponseItem { Result = true, Status = DCO.ResponseStatus.Success, Message = "", RequestUser = Username, TotalItemCount = 1 }; } } } catch (Exception ex) { result.ImportFileConfigItem = Mapper.Map<SYS_tblImportFileConfigDCO>(new SYS_tblImportFileConfigDTO()); result.ResponseItem = new DCO.ResponseItem { Result = false, Status = DCO.ResponseStatus.Exception, Message = "Get data failed: " + ex.Message, RequestUser = Username, TotalItemCount = 0 }; logger.Error(ex); } return result; }