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