public bool UpdateCorrectiveAction(CorrectiveActionOnIssuesModel correctiveActionOnIssuesModel)
{
int result = 0;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ID", correctiveActionOnIssuesModel.id));
paramCollection.Add(new DBParameter("@TodayDate", correctiveActionOnIssuesModel._dateToday));
paramCollection.Add(new DBParameter("@Issue", correctiveActionOnIssuesModel._issue));
paramCollection.Add(new DBParameter("@Action", correctiveActionOnIssuesModel._Action));
paramCollection.Add(new DBParameter("@ActionToBeTakenDate", correctiveActionOnIssuesModel._ActionToBeTakenDate));
paramCollection.Add(new DBParameter("@ActionAdvisedBy", correctiveActionOnIssuesModel._ActionAdvisedBy));
paramCollection.Add(new DBParameter("@ActionTakenBy", correctiveActionOnIssuesModel._ActionTakenBy));
paramCollection.Add(new DBParameter("@FeedBackAfterTakenAction", correctiveActionOnIssuesModel._FeedBackAfterAction));
paramCollection.Add(new DBParameter("@issueRegistedDate", correctiveActionOnIssuesModel._issueRegisteredDate));
paramCollection.Add(new DBParameter("@IssueCode", correctiveActionOnIssuesModel._issueCode));
paramCollection.Add(new DBParameter("@IssueP_ID", correctiveActionOnIssuesModel._issuePID));
paramCollection.Add(new DBParameter("@flag", correctiveActionOnIssuesModel.flag));
result = _DBHelper.ExecuteNonQuery("Sp_InsertCorrectiveAction", paramCollection, CommandType.StoredProcedure);
}
catch (Exception ee)
{
throw ee;
}
if (result > 0)
{
return(true);
}
return(false);
}
public bool UpdateCorrectiveAction(CorrectiveActionOnIssuesModel correctiveActionModel)
{
return(dbCorrectiveActionOnIssue.UpdateCorrectiveAction(correctiveActionModel));
}
public int InsertCorrectiveActionOnIssues(CorrectiveActionOnIssuesModel correctiveActionModel)
{
// dbproduct = new DBProduct();
return(dbCorrectiveActionOnIssue.InsertCorrectiveActionOnIssues(correctiveActionModel));
}
