public SYS_tblImportFileConfigDTO CheckValidImportTemplate(string username, string language_id, string store_procedure, string file_name, string module_id, string function_id) { SYS_tblImportFileConfigDTO result = new SYS_tblImportFileConfigDTO(); try { DataRow dr = db.GetDataRow("SYS_spfrmImportFileConfig", new string[] { "Activity", "Username", "LanguageID", "ExcelFile", "FunctionID", "ModuleID" }, new object[] { "CheckValidTemplate", username, language_id, file_name, function_id, module_id }); if (dr != null) { result = new SYS_tblImportFileConfigDTO { ImportFileConfigID = Convert.ToInt32(dr["ImportFileConfigID"]), ModuleID = dr["ModuleID"] + "", ExcelFile = dr["ExcelFile"] + "", FunctionID = Convert.ToInt32(dr["FunctionID"]) }; return result; } } catch (Exception ex) { 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; }