public void Update(string name, int id)
{
var command = _dbPhoneTypeCommandProvider.GetUpdateDbCommand(name, id);
command.Connection = _dbConnHolder.Connection;
_dbConnHolder.Open();
command.ExecuteNonQuery();
_dbConnHolder.Close();
}
public int GetRowCount()
{
var command = _dbComplaintDetailCommandProvider.GetGetRowCountDbCommand();
command.Connection = _dbConnHolder.Connection;
_dbConnHolder.Open();
var returnValue = Convert.ToInt32(command.ExecuteScalar());
_dbConnHolder.Close();
return(returnValue);
}
public void Update(int complaintTypeId, string description, string locationDetails, int reportingPartyId, int id)
{
var command = _dbComplaintCommandProvider.GetUpdateDbCommand(complaintTypeId, description, locationDetails,
reportingPartyId, id);
command.Connection = _dbConnHolder.Connection;
_dbConnHolder.Open();
command.ExecuteNonQuery();
_dbConnHolder.Close();
}
public void Update(string name, string email, string phone, int?phoneTypeId, int id)
{
var command = _dbReportingPartyCommandProvider.GetUpdateDbCommand(name, email, phone, phoneTypeId, id);
command.Connection = _dbConnHolder.Connection;
_dbConnHolder.Open();
command.ExecuteNonQuery();
_dbConnHolder.Close();
}