public List <C_SECTION_DETAIL> GetDataByColumn(string column, string data, OleExec DB)
{
List <C_SECTION_DETAIL> list = new List <C_SECTION_DETAIL>();
string sql = "";
if (string.IsNullOrEmpty(column))
{
sql = $@"select * from C_section where section_name =:data";
}
else
{
sql = $@"select * from C_section where {column} =:data";
}
DataSet res = DB.ExecSelect(sql, new System.Data.OleDb.OleDbParameter[1] {
new System.Data.OleDb.OleDbParameter("data", data)
});
DataTable dt = res.Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
C_SECTION_DETAIL ep = new C_SECTION_DETAIL();
ep = RowToSection(item);
list.Add(ep);
}
}
return(list);
}
public List <C_SECTION_DETAIL> GetSectionT(string sec, OleExec DB)
{
string sql;
List <C_SECTION_DETAIL> list = new List <C_SECTION_DETAIL>();
if (string.IsNullOrEmpty(sec))
{
sql = $@"select * from C_section order by id";
}
else
{
sql = $@"select * from C_section where section_name='{sec}' order by id";
}
DataTable dt = new DataTable();
dt = DB.ExecSelect(sql).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
C_SECTION_DETAIL ep = new C_SECTION_DETAIL();
ep = RowToSection(item);
list.Add(ep);
}
}
return(list);
}
private C_SECTION_DETAIL RowToSection(DataRow item)
{
C_SECTION_DETAIL ep = new C_SECTION_DETAIL();
ep.ID = item["ID"].ToString();
ep.Section_Name = item["Section_Name"].ToString();
ep.Description = item["Description"].ToString();
return(ep);
}
public List <C_SECTION_DETAIL> ShowAllData(OleExec DB)
{
List <C_SECTION_DETAIL> list = new List <C_SECTION_DETAIL>();
string sql = $@"select * from C_section";
DataTable dt = new DataTable();
dt = DB.ExecSelect(sql).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
C_SECTION_DETAIL ep = new C_SECTION_DETAIL();
ep = RowToSection(item);
list.Add(ep);
}
}
return(list);
}
public C_SECTION_DETAIL GetById(OleExec DB, string Id)
{
C_SECTION_DETAIL result = new C_SECTION_DETAIL();
string sql = $@"select * from C_section where id=:id";
DataTable dt = new DataTable();
OleDbParameter[] paramet = new OleDbParameter[] {
new OleDbParameter(":id", Id)
};
dt = DB.ExecuteDataTable(sql, CommandType.Text, paramet);
if (dt.Rows.Count > 0)
{
result = RowToSection(dt.Rows[0]);
}
else
{
result = null;
}
return(result);
}