public WorkMatter GetWorkMatterByID(string ClaimNumber)
{
string connectionString = ConfigurationManager.AppSettings["SQLConnectionString"];
string queryText = ConfigurationManager.AppSettings["BaseSelectStatement"];
queryText += " WHERE (1=1) AND (C1.ClaimNumber = '" + ClaimNumber + "')";
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryText, conn);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dt = new DataTable();
da.Fill(dt);
conn.Close();
da.Dispose();
WorkMatter matchingClaim = new WorkMatter();
if (dt.Rows.Count > 0)
{
matchingClaim.ClaimNumber = dt.Rows[0]["ClaimNumber"].ToString();
matchingClaim.trg_WorkMatterDescription = dt.Rows[0]["trg_WorkMatterDescription"].ToString();
matchingClaim.NameDenorm = dt.Rows[0]["NameDenorm"].ToString();
return(matchingClaim);
}
return(null);
}
}
public List <WorkMatter> ExecuteWorkMatterFind(string queryText)
{
string connectionString = ConfigurationManager.AppSettings["SQLConnectionString"];
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryText, conn);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dt = new DataTable();
da.Fill(dt);
conn.Close();
da.Dispose();
List <WorkMatter> workMatters = new List <WorkMatter>();
foreach (DataRow row in dt.Rows)
{
WorkMatter matter = new WorkMatter()
{
ClaimNumber = row["ClaimNumber"].ToString(),
NameDenorm = row["NameDenorm"].ToString(),
trg_WorkMatterDescription = row["trg_WorkMatterDescription"].ToString()
};
workMatters.Add(matter);
}
return(workMatters);
}
}
