public DataTable PostVehicleDriverQuery([FromBody] vehicledrivercls dcls)
{
string w_clause = "";
if (dcls.drivername != "" && dcls.drivername != "undefined" && dcls.drivername != null)
{
w_clause = w_clause + " and DriverId in (select id from driverinfo where name like '%" + dcls.drivername + "%')";
}
if (dcls.devicemodel != "" && dcls.devicemodel != "undefined" && dcls.devicemodel != null)
{
w_clause = w_clause + " and DeviceModel like '%" + dcls.devicemodel + "%'";
}
if (dcls.deviceno != "" && dcls.deviceno != "undefined" && dcls.deviceno != null)
{
w_clause = w_clause + " and DeviceNo like '%" + dcls.deviceno + "%'";
}
if (dcls.IMSI != "" && dcls.IMSI != "undefined" && dcls.IMSI != null)
{
w_clause = w_clause + " and IMSI like '%" + dcls.IMSI + "%'";
}
if (dcls.IMEI != "" && dcls.IMEI != "undefined" && dcls.IMEI != null)
{
w_clause = w_clause + " and IMEI like '%" + dcls.IMEI + "%'";
}
if (dcls.vehicleplateno != "" && dcls.vehicleplateno != "undefined" && dcls.vehicleplateno != null)
{
w_clause = w_clause + " and vehicleplateno like '%" + dcls.vehicleplateno + "%'";
}
if (w_clause != "")
{
w_clause = " where " + w_clause.Substring(4);
}
SqlConnection cont = new SqlConnection();
cont.ConnectionString = constr2;
cont.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select * from VehicleDriver " + w_clause, cont);
da.Fill(dt);
cont.Close();
cont.Dispose();
// List <DriverInfo> = new List<DriverInfo>;
return(dt);
}
public string PostDelVehicleDriver([FromBody] vehicledrivercls dcls)
{
SqlConnection cont = new SqlConnection();
cont.ConnectionString = constr2;
cont.Open();
DataTable dt = new DataTable();
//SqlDataAdapter da = new SqlDataAdapter("select * from driverinfo " + HttpUtility.HtmlDecode(w_clause), cont);
SqlCommand cmd = new SqlCommand();
cmd.Connection = cont;
cmd.CommandText = " delete vehicledriver where deviceno='" + dcls.deviceno + "' and vehicleplateno='" + dcls.vehicleplateno + "'";
cmd.ExecuteNonQuery();
//da.Fill(dt);
cont.Close();
cont.Dispose();
return("Deleted Successfully");
}
public string PostInsVehicleDriver([FromBody] vehicledrivercls dcls)
{
try
{
SqlConnection cont = new SqlConnection();
cont.ConnectionString = constr2;
cont.Open();
// DataTable dt = new DataTable();
//SqlDataAdapter da = new SqlDataAdapter("select * from driverinfo " + HttpUtility.HtmlDecode(w_clause), cont);
SqlCommand cmd = new SqlCommand();
cmd.Connection = cont;
cmd.CommandText = " insert into vehicledriver(deviceno,vehicleplateno,driverid,devicemodel,imsi,imei,userid) values('" + dcls.deviceno + "','" + dcls.vehicleplateno + "','" + dcls.driverId + "','" + dcls.devicemodel + "','" + dcls.IMSI + "','" + dcls.IMEI + "','" + dcls.userid + "')";
int Records = cmd.ExecuteNonQuery();
//da.Fill(dt);
cont.Close();
cont.Dispose();
return(Records + " Saved Successfully");
}
catch (Exception e)
{
return("error" + e.Message);
}
}