public int InsertIssueRegistration(IssueRegistrationModel issueRegistrationModel) { int result = 0; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@IssueID", issueRegistrationModel._IssueID)); paramCollection.Add(new DBParameter("@IssueDateTime", issueRegistrationModel._IssueDateTime)); paramCollection.Add(new DBParameter("@IssueArisedBy", issueRegistrationModel._IssueArisedBy)); // paramCollection.Add(new DBParameter("@Address", issueRegistrationModel._IssueAddress)); paramCollection.Add(new DBParameter("@ContactNo", issueRegistrationModel._IssueContactNo)); paramCollection.Add(new DBParameter("@IssueCode", issueRegistrationModel._Issue)); paramCollection.Add(new DBParameter("@IssueType", issueRegistrationModel._IssueType)); paramCollection.Add(new DBParameter("@IssueOnBrand", issueRegistrationModel._IssueOnBrand)); paramCollection.Add(new DBParameter("@IssueCommodity", issueRegistrationModel._IssueCommodity)); paramCollection.Add(new DBParameter("@DeviatedQty", issueRegistrationModel._DeviatedQty)); paramCollection.Add(new DBParameter("@IssueVerifiedBy", issueRegistrationModel._IssueVerifiedBy)); paramCollection.Add(new DBParameter("@IssueForwardTo", issueRegistrationModel._IssueForwardTo)); paramCollection.Add(new DBParameter("@IssueEnteredBy", issueRegistrationModel._IssueEnteredBy)); paramCollection.Add(new DBParameter("@IssueOnProductType", issueRegistrationModel._IssueOnProductType)); paramCollection.Add(new DBParameter("@Issues", issueRegistrationModel._IssueCode)); paramCollection.Add(new DBParameter("@code", issueRegistrationModel._code)); paramCollection.Add(new DBParameter("@flag", issueRegistrationModel.flag)); result = _DBHelper.ExecuteNonQuery("Sp_InsertIssuesRegistration", paramCollection, CommandType.StoredProcedure); } catch (Exception ee) { } return(result); }
public int DeleteIssue(IssueRegistrationModel issueModel) { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@IssueID ", issueModel._IssueCode)); return(_DBHelper.ExecuteNonQuery("sp_DeleteIssue", paramCollection, CommandType.StoredProcedure)); }
public int DeleteIssue(IssueRegistrationModel issueModel) { //dbproduct = new DBProduct(); return(DBIssue.DeleteIssue(issueModel)); }
public bool UpdateIssues(IssueRegistrationModel issueModel) { return(DBIssue.UpdateIssues(issueModel)); }
public int InsertIssue(IssueRegistrationModel issueModel) { // dbproduct = new DBProduct(); return(DBIssue.InsertIssueRegistration(issueModel)); }