public int PostUpdatePatrolCar([FromBody] PatrolCars frm)
{
int ret = 0;
string Qry = "update patrolcars set AhwalID = " + frm.ahwalid + ",platenumber = '" + frm.platenumber + "',model = '" + frm.model + "',typecode='" + frm.typecode + "',defective = " + frm.defective + ",rental = " + frm.rental + ",barcode = '" + frm.barcode + "',vinnumber='" + frm.vinnumber + "' where patrolid=" + frm.patrolid;
ret = DAL.PostGre_ExNonQry(Qry);
return(ret);
}
public int PostDeletePatrolCar([FromBody] PatrolCars frm)
{
int ret = 0;
string Qry = "update patrolcars set delflag='1' where patrolid=" + frm.patrolid;
ret = DAL.PostGre_ExNonQry(Qry);
return(ret);
}
public int PostAddPatrolCar([FromBody] PatrolCars frm)
{
int ret = 0;
string Qry = "insert into patrolcars(AhwalID,platenumber,model,typecode,defective,rental,barcode,vinnumber) values (" + frm.ahwalid + ",'" + frm.platenumber + "','" + frm.model + "','" + frm.typecode + "'," + frm.defective + "," + frm.rental + ",'" + frm.barcode + "','" + frm.vinnumber + "')";
ret = DAL.PostGre_ExNonQry(Qry);
return(ret);
}
