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;
        }
Example #2
0
        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;
        }