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