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)); }