public DataTable Vehicle(vehiclemas v)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "HVInsUpdVehicle";
cmd.Connection = conn;
SqlParameter se = new SqlParameter("@flag", SqlDbType.VarChar);
se.Value = v.flag;
cmd.Parameters.Add(se);
SqlParameter s = new SqlParameter("@Id", SqlDbType.Int);
s.Value = v.Id;
cmd.Parameters.Add(s);
SqlParameter i = new SqlParameter("@VID", SqlDbType.Int);
i.Value = v.VID;
cmd.Parameters.Add(i);
SqlParameter cd = new SqlParameter("@CompanyId", SqlDbType.Int);
cd.Value = v.CompanyId;
cmd.Parameters.Add(cd);
SqlParameter n = new SqlParameter("@RegistrationNo", SqlDbType.VarChar, 50);
n.Value = v.RegistrationNo;
cmd.Parameters.Add(n);
SqlParameter cn = new SqlParameter("@ChasisNo", SqlDbType.VarChar, 50);
cn.Value = v.ChasisNo;
cmd.Parameters.Add(cn);
SqlParameter en = new SqlParameter("@Engineno", SqlDbType.VarChar, 50);
en.Value = v.Engineno;
cmd.Parameters.Add(en);
SqlParameter oid = new SqlParameter("@FleetOwnerId", SqlDbType.Int);
oid.Value = v.OwnerId;
cmd.Parameters.Add(oid);
SqlParameter vt = new SqlParameter("@VehicleTypeId", SqlDbType.Int);
vt.Value = v.VehicleTypeId;
cmd.Parameters.Add(vt);
SqlParameter vv = new SqlParameter("@VehicleModelId", SqlDbType.Int);
vv.Value = v.VehicleModelId;
cmd.Parameters.Add(vv);
SqlParameter vg = new SqlParameter("@VehicleGroupId", SqlDbType.Int);
vg.Value = v.VehicleGroupId;
cmd.Parameters.Add(vg);
SqlParameter wg = new SqlParameter("@ModelYear", SqlDbType.VarChar, 5);
wg.Value = v.ModelYear;
cmd.Parameters.Add(wg);
SqlParameter ac = new SqlParameter("@HasAC", SqlDbType.Int);
ac.Value = v.HasAC;
cmd.Parameters.Add(ac);
SqlParameter sid = new SqlParameter("@StatusId", SqlDbType.Int);
sid.Value = v.StatusId;
cmd.Parameters.Add(sid);
SqlParameter isv = new SqlParameter("@IsVerified", SqlDbType.Int);
isv.Value = v.IsVerified;
cmd.Parameters.Add(isv);
SqlParameter isDriverOwned = new SqlParameter("@isDriverOwned", SqlDbType.Int);
isDriverOwned.Value = v.isDriverOwned;
cmd.Parameters.Add(isDriverOwned);
SqlParameter vcode = new SqlParameter("@VehicleCode ", SqlDbType.VarChar, 10);
vcode.Value = v.VehicleCode;
cmd.Parameters.Add(vcode);
SqlParameter pr = new SqlParameter("@Photo", SqlDbType.VarChar);
pr.Value = v.Photo;
cmd.Parameters.Add(pr);
SqlParameter ctr = new SqlParameter("@CountryId", SqlDbType.Int);
ctr.Value = v.CountryId;
cmd.Parameters.Add(ctr);
SqlParameter fi = new SqlParameter("@FrontImage", SqlDbType.VarChar);
fi.Value = v.FrontImage;
cmd.Parameters.Add(fi);
SqlParameter bi = new SqlParameter("@BackImage", SqlDbType.VarChar);
bi.Value = v.BackImage;
cmd.Parameters.Add(bi);
SqlParameter ri = new SqlParameter("@RightImage", SqlDbType.VarChar);
ri.Value = v.RightImage;
cmd.Parameters.Add(ri);
SqlParameter li = new SqlParameter("@LeftImage", SqlDbType.VarChar);
li.Value = v.LeftImage;
cmd.Parameters.Add(li);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(dt);
}
public DataTable Vehicles(vehiclemas v)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "HVInsUpdVehicles";
cmd.Connection = conn;
SqlParameter se = new SqlParameter("@flag", SqlDbType.VarChar);
se.Value = v.flag;
cmd.Parameters.Add(se);
SqlParameter s = new SqlParameter("@Id", SqlDbType.Int);
s.Value = v.Id;
cmd.Parameters.Add(s);
SqlParameter i = new SqlParameter("@VID", SqlDbType.Int);
i.Value = v.VID;
cmd.Parameters.Add(i);
SqlParameter cd = new SqlParameter("@CompanyId", SqlDbType.Int);
cd.Value = v.CompanyId;
cmd.Parameters.Add(cd);
SqlParameter n = new SqlParameter("@RegistrationNo", SqlDbType.VarChar, 50);
n.Value = v.RegistrationNo;
cmd.Parameters.Add(n);
SqlParameter r = new SqlParameter("@Type", SqlDbType.VarChar, 50);
r.Value = v.Type;
cmd.Parameters.Add(r);
SqlParameter a = new SqlParameter("@OwnerName", SqlDbType.VarChar, 50);
a.Value = v.OwnerName;
cmd.Parameters.Add(a);
SqlParameter jw = new SqlParameter("@CompanyVechile", SqlDbType.Int);
jw.Value = v.CompanyVechile;
cmd.Parameters.Add(jw);
SqlParameter wj = new SqlParameter("@OwnerPhoneNo", SqlDbType.VarChar, 50);
wj.Value = v.OwnerPhoneNo;
cmd.Parameters.Add(wj);
SqlParameter wh = new SqlParameter("@HomeLandmark", SqlDbType.VarChar, 50);
wh.Value = v.HomeLandmark;
cmd.Parameters.Add(wh);
SqlParameter wg = new SqlParameter("@ModelYear", SqlDbType.VarChar);
wg.Value = v.ModelYear;
cmd.Parameters.Add(wg);
SqlParameter wf = new SqlParameter("@DayOnly", SqlDbType.VarChar, 50);
wf.Value = v.DayOnly;
cmd.Parameters.Add(wf);
SqlParameter ca = new SqlParameter("@VechMobileNo", SqlDbType.VarChar, 50);
ca.Value = v.VechMobileNo;
cmd.Parameters.Add(ca);
SqlParameter ws = new SqlParameter("@EntryDate", System.Data.SqlDbType.Date);
ws.Value = v.EntryDate;
cmd.Parameters.Add(ws);
SqlParameter wsd = new SqlParameter("@NewEntry", SqlDbType.VarChar, 50);
wsd.Value = v.NewEntry;
cmd.Parameters.Add(wsd);
SqlParameter vv = new SqlParameter("@VehicleModelId", SqlDbType.Int);
vv.Value = v.VehicleModelId;
cmd.Parameters.Add(vv);
SqlParameter vf = new SqlParameter("@ServiceTypeId", SqlDbType.Int);
vf.Value = v.ServiceTypeId;
cmd.Parameters.Add(vf);
SqlParameter vg = new SqlParameter("@VehicleGroupId", SqlDbType.Int);
vg.Value = v.VehicleGroupId;
cmd.Parameters.Add(vg);
SqlParameter pp = new SqlParameter("@Photo", SqlDbType.VarChar);
pp.Value = v.photo;
cmd.Parameters.Add(pp);
SqlParameter ss = new SqlParameter("@Status", SqlDbType.VarChar);
ss.Value = v.photo;
cmd.Parameters.Add(ss);
SqlParameter fl = new SqlParameter("@FleetOwnerCode", SqlDbType.VarChar);
fl.Value = v.Fleetcode;
cmd.Parameters.Add(fl);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(dt);
}
