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