Example #1
0
        public async static Task <SYS_tblImportFileConfigDRO> ImportDataRow(string username, string language_id, string store_procedure, System.Data.DataRow dr, string column_array)
        {
            SYS_tblImportFileConfigDRO result = new SYS_tblImportFileConfigDRO();

            try
            {
                Dictionary <string, string> dictionary = new Dictionary <string, string>();
                string[] arrColumn = { };
                arrColumn = column_array.Trim().Split('|');
                if (dr != null && arrColumn.Length > 0)
                {
                    dictionary.Add("Username", username);
                    dictionary.Add("LanguageID", language_id);
                    for (int i = 0; i < arrColumn.Length; i++)
                    {
                        dictionary.Add(arrColumn[i], dr[i] + "");
                    }
                }

                var    json = JsonConvert.SerializeObject(dictionary);
                string url  = string.Format(@"{0}/ImportDataRow?Username={1}&InputData={2}&StoreProcedure={3}", GetBaseUrl(), username, json + "", store_procedure);

                result = await SYS_tblImportFileConfigDAO.ImportDataRow(url);
            }
            catch (Exception ex)
            {
                logger.Error(ex);
                result.ResponseItem.Message = ex.Message;
            }

            return(result);
        }
Example #2
0
        public async static Task <SYS_tblImportFileConfigDRO> CheckValidImportTemplate(string username, string language_id, string store_procedure, string file_name, string module_id, string function_id)
        {
            SYS_tblImportFileConfigDRO result = new SYS_tblImportFileConfigDRO();

            try
            {
                string url = string.Format(@"{0}/CheckValidImportTemplate?Username={1}&LanguageID={2}&StoreProcedure={3}&FileName={4}&ModuleID={5}&FunctionID={6}", GetBaseUrl(), username, language_id, store_procedure, file_name, module_id, function_id);

                result = await SYS_tblImportFileConfigDAO.CheckValidImportTemplate(url);
            }
            catch (Exception ex)
            {
                logger.Error(ex);
                result.ResponseItem.Message = ex.Message;
            }

            return(result);
        }
 public SYS_tblImportFileConfigBUS()
 {
     daoImport = new SYS_tblImportFileConfigDAO();
 }