public bool AddNew(APIRuleApplicationSummary _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_APIRuleApplicationSummary_AddNew", CommandType.StoredProcedure, parameters));
}
public APIRuleApplicationSummary GetRunID()
{
APIRuleApplicationSummary _ruleSummary = null;
using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_APIRuleApplicationSummary_GetRunID", CommandType.StoredProcedure))
{
//check if any record exist or not
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
_ruleSummary = new APIRuleApplicationSummary();
_ruleSummary.RunID = Convert.ToInt32(row["RunID"]);
}
}
return(_ruleSummary);
}
