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