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);
}
