public bool AddNew(RuleApplicationSummary _ruleSummary)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@RunID", _ruleSummary.RunID),
new SqlParameter("@FileName", _ruleSummary.FileName),
new SqlParameter("@RuleDescID", _ruleSummary.RuleDescID),
new SqlParameter("@FieldValue", _ruleSummary.FieldValue),
new SqlParameter("@EntryDate", _ruleSummary.EntryDate),
new SqlParameter("@IsSuccess", _ruleSummary.IsSuccess),
};
return(SqlDBHelper.ExecuteNonQuery("proc_RuleApplicationSummary_AddNew", CommandType.StoredProcedure, parameters));
}
public RuleApplicationSummary GetRunID()
{
RuleApplicationSummary _ruleSummary = null;
using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_RuleApplicationSummary_GetRunID", CommandType.StoredProcedure))
{
//check if any record exist or not
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
_ruleSummary = new RuleApplicationSummary();
_ruleSummary.RunID = Convert.ToInt32(row["RunID"]);
}
}
return(_ruleSummary);
}
public List <RuleApplicationSummary> RuleApplicationSummary_LoadByRunID(long RunID)
{
List <RuleApplicationSummary> list = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@RunID", RunID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("proc_RuleApplicationSummary_LoadByRunID", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
list = new List <RuleApplicationSummary>();
foreach (DataRow row in table.Rows)
{
RuleApplicationSummary _rule = new RuleApplicationSummary();
_rule.RunID = Convert.ToInt32(row["RunID"]);
_rule.FileName = Convert.ToString(row["FileName"]);
_rule.FieldValue = Convert.ToString(row["FieldValue"]);
_rule.EntryDate = Convert.ToDateTime(row["EntryDate"]);
_rule.IsSuccess = Convert.ToBoolean(row["IsSuccess"]);
list.Add(_rule);
}
}
}
return(list);
}