public void update(Crime c)
{
SqlCommand cmd = new SqlCommand(UPDATE, DBC.getConnection());
SqlConnection con = cmd.Connection;
con.Open();
//Left side table attributes and right side class variables
cmd.Parameters.AddWithValue("@crimeID", c.crimeID);
cmd.Parameters.AddWithValue("@crimeDate", c.crimeDate);
cmd.Parameters.AddWithValue("@crimeType", c.crimeType);
cmd.Parameters.AddWithValue("@location", c.location);
cmd.Parameters.AddWithValue("@noOfPeopleArrest", c.noOfPeopleArrest);
using (con)
{
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Data updated successfully");
}
else
{
MessageBox.Show("something wrong");
}
}
}
public void update(Victim d)
{
SqlCommand cmd = new SqlCommand(UPDATE, DBC.getConnection());
SqlConnection con = cmd.Connection;
con.Open();
//Left side table attributes and right side class variables
cmd.Parameters.AddWithValue("@ID", d.ID);
cmd.Parameters.AddWithValue("@Name", d.Name);
cmd.Parameters.AddWithValue("@IDCard", d.IDCard);
cmd.Parameters.AddWithValue("@VictimAddress", d.VictimAddress);
cmd.Parameters.AddWithValue("@PhoneNumber", d.PhoneNumber);
cmd.Parameters.AddWithValue("@CaseNumber", d.CaseNumber);
using (con)
{
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Data updated successfully");
}
else
{
MessageBox.Show("something wrong");
}
}
}
public void insert(Crime c)
{
try
{
SqlCommand cmd = new SqlCommand(INSERT, DBC.getConnection());
SqlConnection con = cmd.Connection;
con.Open();
cmd.Parameters.AddWithValue("@crimeType", c.crimeType);
cmd.Parameters.AddWithValue("@crimeDate", c.crimeDate);
cmd.Parameters.AddWithValue("@location", c.location);
cmd.Parameters.AddWithValue("@noOfPeopleArrest", c.noOfPeopleArrest);
using (con)
{
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Data inserted successfully");
}
else
{
MessageBox.Show("something wrong");
}
}
}
catch (Exception e1)
{
//MessageBox.Show(e1 + "");
}
}
public void update(Officer o)
{
SqlCommand cmd = new SqlCommand(UPDATE, DBC.getConnection());
SqlConnection con = cmd.Connection;
con.Open();
//Left side table attributes and right side class variables
cmd.Parameters.AddWithValue("@officerID", o.officerID);
cmd.Parameters.AddWithValue("@officerName", o.officerName);
cmd.Parameters.AddWithValue("@officerAge", o.officerAge);
cmd.Parameters.AddWithValue("@officerSalary", o.officerSalary);
cmd.Parameters.AddWithValue("@officerRank", o.officerRank);
cmd.Parameters.AddWithValue("@officerAddress", o.officerAddress);
cmd.Parameters.AddWithValue("@officerPhoneNo", o.officerPhoneNo);
cmd.Parameters.AddWithValue("@officerJoiningDate", o.officerJoiningDate);
cmd.Parameters.AddWithValue("@officerCNIC", o.officerCNIC);
using (con)
{
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Data updated successfully");
}
else
{
MessageBox.Show("something wrong");
}
}
}
public List <Officer> Select_All()
{
SqlCommand cmd = new SqlCommand(SELECT_ALL, DBC.getConnection());
return(fetch(cmd));
}
public void insert(Victim d)
{
try
{
SqlCommand cmd = new SqlCommand(INSERT, DBC.getConnection());
SqlConnection con = cmd.Connection;
con.Open();
cmd.Parameters.AddWithValue("@Name", d.Name);
cmd.Parameters.AddWithValue("@IDCard", d.IDCard);
cmd.Parameters.AddWithValue("@VictimAddress", d.VictimAddress);
cmd.Parameters.AddWithValue("@PhoneNumber", d.PhoneNumber);
cmd.Parameters.AddWithValue("@CaseNumber", d.CaseNumber);
using (con)
{
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Data Inserted SuccesFully");
}
else
{
MessageBox.Show("Something Gone Wrong");
}
}
}
catch (Exception e1)
{
}
}
public void update(Criminals c)
{
SqlCommand cmd = new SqlCommand(UPDATE, DBC.getConnection());
SqlConnection con = cmd.Connection;
con.Open();
//Left side table attributes and right side class variables
cmd.Parameters.AddWithValue("@criminalID", c.criminalID);
cmd.Parameters.AddWithValue("@name", c.name);
cmd.Parameters.AddWithValue("@age", c.Age);
cmd.Parameters.AddWithValue("@criminalAddress", c.criminalAddress);
cmd.Parameters.AddWithValue("@dateOfArrest", c.dateOfArrest);
cmd.Parameters.AddWithValue("@batchID", c.batchID);
cmd.Parameters.AddWithValue("@crimeID", c.crimeID);
cmd.Parameters.AddWithValue("@caseNo", c.caseNo);
using (con)
{
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Data updated successfully");
}
else
{
MessageBox.Show("something wrong");
}
}
}
public void insert(Criminals c)
{
try
{
SqlCommand cmd = new SqlCommand(INSERT, DBC.getConnection());
SqlConnection con = cmd.Connection;
con.Open();
cmd.Parameters.AddWithValue("@name", c.name);
cmd.Parameters.AddWithValue("@age", c.Age);
cmd.Parameters.AddWithValue("@criminalAddress", c.criminalAddress);
cmd.Parameters.AddWithValue("@dateOfArrest", c.dateOfArrest);
cmd.Parameters.AddWithValue("@batchID", c.batchID);
cmd.Parameters.AddWithValue("@crimeID", c.crimeID);
cmd.Parameters.AddWithValue("@caseNo", c.caseNo);
using (con)
{
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Data inserted successfully");
}
else
{
MessageBox.Show("something wrong");
}
}
}
catch (Exception e1)
{
//MessageBox.Show(e1 + "");
}
}
public void update(Case c)
{
SqlCommand cmd = new SqlCommand(UPDATE, DBC.getConnection());
SqlConnection con = cmd.Connection;
con.Open();
//Left side table attributes and right side class variables
cmd.Parameters.AddWithValue("@caseID", c.caseID);
cmd.Parameters.AddWithValue("@caseType", c.caseType);
cmd.Parameters.AddWithValue("@startingDate", c.startingDate);
cmd.Parameters.AddWithValue("@endingDate", c.endingDate);
cmd.Parameters.AddWithValue("@crimeID", c.crimeID);
cmd.Parameters.AddWithValue("@officerBatchID", c.officerBatchID);
cmd.Parameters.AddWithValue("@solved", c.solved);
cmd.Parameters.AddWithValue("@victimID", c.victimID);
using (con)
{
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Data updated successfully");
}
else
{
MessageBox.Show("something wrong");
}
}
}
public void insert(Case c)
{
try
{
SqlCommand cmd = new SqlCommand(INSERT, DBC.getConnection());
SqlConnection con = cmd.Connection;
con.Open();
cmd.Parameters.AddWithValue("@caseType", c.caseType);
cmd.Parameters.AddWithValue("@startingDate", c.startingDate);
cmd.Parameters.AddWithValue("@endingDate", c.endingDate);
cmd.Parameters.AddWithValue("@crimeID", c.crimeID);
cmd.Parameters.AddWithValue("@officerBatchID", c.officerBatchID);
cmd.Parameters.AddWithValue("@solved", c.solved);
cmd.Parameters.AddWithValue("@victimID", c.victimID);
using (con)
{
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Data inserted successfully");
}
else
{
MessageBox.Show("something wrong");
}
}
}
catch (Exception e1)
{
//MessageBox.Show(e1 + "");
}
}
public void delete(Crime c)
{
SqlCommand cmd = new SqlCommand(DELETE, DBC.getConnection());
SqlConnection con = cmd.Connection;
con.Open();
//Left side table attribute and right side class variabled
cmd.Parameters.AddWithValue("@crimeID", c.crimeID);
using (con)
{
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("Data deleted successfully");
}
else
{
MessageBox.Show("something wrong");
}
}
}
public void insert(Officer o)
{
try
{
//MessageBox.Show("Hello");
SqlCommand cmd = new SqlCommand(INSERT, DBC.getConnection());
SqlConnection con = cmd.Connection;
con.Open();
cmd.Parameters.AddWithValue("@officerName", o.officerName);
cmd.Parameters.AddWithValue("@officerAge", o.officerAge);
cmd.Parameters.AddWithValue("@officerSalary", o.officerSalary);
cmd.Parameters.AddWithValue("@officerRank", o.officerRank);
cmd.Parameters.AddWithValue("@officerAddress", o.officerAddress);
cmd.Parameters.AddWithValue("@officerPhoneNo", o.officerPhoneNo);
cmd.Parameters.AddWithValue("@officerJoiningDate", o.officerJoiningDate);
cmd.Parameters.AddWithValue("@officerCNIC", o.officerCNIC);
using (con)
{
// MessageBox.Show("He33llo");
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
// MessageBox.Show("Hel222lo");
MessageBox.Show("Data inserted successfully");
}
else
{
MessageBox.Show("something wrong");
}
}
}
catch (Exception e1)
{
//MessageBox.Show(e1 + "");
}
}
