public int PostDeletePatrolCar([FromBody] patrolcarcls frm) { int ret = 0; NpgsqlConnection cont = new NpgsqlConnection(); cont.ConnectionString = constr; cont.Open(); NpgsqlCommand cmd = new NpgsqlCommand(); cmd.Connection = cont; cmd.CommandText = "delete from patrolcars where patrolid=" + frm.patrolid; ret = cmd.ExecuteNonQuery(); cont.Close(); cont.Dispose(); return(ret); }
public int PostUpdatePatrolCar([FromBody] patrolcarcls frm) { int ret = 0; NpgsqlConnection cont = new NpgsqlConnection(); cont.ConnectionString = constr; cont.Open(); NpgsqlCommand cmd = new NpgsqlCommand(); cmd.Connection = cont; cmd.CommandText = "update patrolcars set AhwalID = " + frm.ahwalid + ",platenumber = '" + frm.platenumber + "',model = '" + frm.model + "',typecode='" + frm.typecode + "',defective = " + frm.defective + ",rental = " + frm.rental + ",barcode = '" + frm.barcode + "' where patrolid=" + frm.patrolid; ret = cmd.ExecuteNonQuery(); cont.Close(); cont.Dispose(); return(ret); }
public int PostAddPatrolCar([FromBody] patrolcarcls frm) { int ret = 0; NpgsqlConnection cont = new NpgsqlConnection(); cont.ConnectionString = constr; cont.Open(); NpgsqlCommand cmd = new NpgsqlCommand(); cmd.Connection = cont; cmd.CommandText = "insert into patrolcars(AhwalID,platenumber,model,typecode,defective,rental,barcode,vinnumber) values (" + frm.ahwalid + ",'" + frm.platenumber + "'," + frm.model + ",'1'," + frm.defective + "," + frm.rental + ",'" + frm.barcode + "','" + frm.barcode + "')"; ret = cmd.ExecuteNonQuery(); cont.Close(); cont.Dispose(); return(ret); }