public bool Delete(StatusRequest item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("StatusRequests_DeleteItem"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}
public StatusRequest GetByID(int id)
{
StatusRequest item = null;
using (StoredProcedure sp = new StoredProcedure("StatusRequests_GetByID"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = id;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new StatusRequest(r);
}
}
}
return item;
}
public List<StatusRequest> GetAll()
{
List<StatusRequest> all = new List<StatusRequest>();
using (StoredProcedure sp = new StoredProcedure("StatusRequests_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
StatusRequest item = new StatusRequest(r);
all.Add(item);
}
}
}
}
return all;
}
public int Add(StatusRequest item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("StatusRequests_AddItem"))
{
sp.Params.Add("@Status", System.Data.SqlDbType.NVarChar, 5).Value = item.Status;
sp.Params.Add("@CompanyName", System.Data.SqlDbType.NVarChar, 255).Value = item.CompanyName;
sp.Params.Add("@ContactName", System.Data.SqlDbType.NVarChar, 255).Value = item.ContactName;
sp.Params.Add("@Address", System.Data.SqlDbType.NVarChar, 255).Value = item.Address;
sp.Params.Add("@Phone", System.Data.SqlDbType.VarChar, 20).Value = item.Phone;
sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar, 255).Value = item.Email;
sp.Params.Add("@IsPartner", System.Data.SqlDbType.Bit).Value = item.IsPartner;
sp.Params.Add("@IsServicePartner", System.Data.SqlDbType.Bit).Value = item.IsServicePartner;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
private void SaveRequest()
{
string company = txtCompanyName.Text;
string contact = txtContactName.Text;
string address = txtAddress.Text;
string phone = txtPhone.Text;
string email = txtEmail.Text;
bool isPartner = rbIsPartner.Checked;
bool isServicePartner = rbIsServicePartner.Checked;
string status = this.Status.ToString();
StatusRequest r = new StatusRequest();
r.Status = status;
r.CompanyName = company;
r.ContactName = contact;
r.Address = address;
r.Phone = phone;
r.Email = email;
r.IsPartner = isPartner;
r.IsServicePartner = isServicePartner;
Requests.Add(r);
}
public List<StatusRequest> GetByStatus(string status)
{
List<StatusRequest> all = new List<StatusRequest>();
using (StoredProcedure sp = new StoredProcedure("StatusRequests_GetByStatus"))
{
sp.Params.Add("@Status", System.Data.SqlDbType.NVarChar, 5).Value = status;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
StatusRequest item = new StatusRequest(r);
all.Add(item);
}
}
}
}
return all;
}
public bool Update(StatusRequest item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("StatusRequests_UpdateItem"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID;
sp.Params.Add("@Status", System.Data.SqlDbType.NVarChar, 5).Value = item.Status;
sp.Params.Add("@CompanyName", System.Data.SqlDbType.NVarChar, 255).Value = item.CompanyName;
sp.Params.Add("@ContactName", System.Data.SqlDbType.NVarChar, 255).Value = item.ContactName;
sp.Params.Add("@Address", System.Data.SqlDbType.NVarChar, 255).Value = item.Address;
sp.Params.Add("@Phone", System.Data.SqlDbType.VarChar, 20).Value = item.Phone;
sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar, 255).Value = item.Email;
sp.Params.Add("@IsPartner", System.Data.SqlDbType.Bit).Value = item.IsPartner;
sp.Params.Add("@IsServicePartner", System.Data.SqlDbType.Bit).Value = item.IsServicePartner;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}