internal ImportFileTemplates GetImportFileTemplateByTemplateId(int templateId) { ImportFileTemplates result = new ImportFileTemplates(); try { DataTable dt = new DataTable(); StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "[cfg].[GetImportFileTemplateByTemplateId]"; sproc.StoredProceduresParameter.Add(GetParam("@TemplateId", templateId.ToString(), SQLServerDatatype.IntDataType)); dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { ImportJobDataAdapter IJ = new ImportJobDataAdapter(); foreach (DataRow rw in dt.Rows) { result = IJ.AdaptTemplateItem(rw, dt); } } return(result); } catch (Exception ex) { throw ex; } }
internal List <ImportFileTemplates> GetAllImportFileTemplates() { List <ImportFileTemplates> results = new List <ImportFileTemplates>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "cfg.GetAllImportFileTemplates"; DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { results = new ImportJobDataAdapter().AdaptTemplate(dt); } } catch (Exception) { throw; } return(results); }
internal List <ImportJobDataEntity> GetNewFileImportRequestByUserID(int?UserId, string Section) { List <ImportJobDataEntity> results = new List <ImportJobDataEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "aud.GetNewFileImportRequestByUserID"; sproc.StoredProceduresParameter.Add(GetParam("@UserId", !string.IsNullOrEmpty(Convert.ToString(UserId)) ? UserId.ToString() : "0", SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@Section", Section, SQLServerDatatype.VarcharDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.ReadWrite.ToString()); if (dt != null && dt.Rows.Count > 0) { results = new ImportJobDataAdapter().Adapt(dt); } } catch (Exception) { throw; } return(results); }