public string insertVdetails(BOLvehicle vehicleBO, string sql)
{
using (con = DBaccess.GetConnection())
{
int result = 0;
string message = string.Empty;
SqlCommand cmd = new SqlCommand();
SqlParameter cmpcode, plantcode, vehicleno, truckid, truckname, phoneno, bankid, ltrcost, pmess, press, ifsc, accountnum, paymentmode;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmpcode = cmd.Parameters.Add("@Company_Code", SqlDbType.Int);
plantcode = cmd.Parameters.Add("@Plant_Code", SqlDbType.Int);
vehicleno = cmd.Parameters.Add("@Vehicle_No", SqlDbType.NVarChar, 50);
truckid = cmd.Parameters.Add("@Truck_Id", SqlDbType.Int);
truckname = cmd.Parameters.Add("@Truck_Name", SqlDbType.NVarChar, 50);
phoneno = cmd.Parameters.Add("@Phone_No", SqlDbType.NVarChar, 50);
bankid = cmd.Parameters.Add("@Bank_Id", SqlDbType.Int);
ifsc = cmd.Parameters.Add("@ifsc_code", SqlDbType.NVarChar, 50);
accountnum = cmd.Parameters.Add("@AccountNo", SqlDbType.NVarChar, 50);
ltrcost = cmd.Parameters.Add("@Ltr_Cost", SqlDbType.Money);
paymentmode = cmd.Parameters.Add("@paymentmode", SqlDbType.Int);
pmess = cmd.Parameters.Add("@mess", SqlDbType.Char, 500);
cmd.Parameters["@mess"].Direction = ParameterDirection.Output;
press = cmd.Parameters.Add("@ress", SqlDbType.Int);
cmd.Parameters["@ress"].Direction = ParameterDirection.Output;
cmpcode.Value = vehicleBO.Companycode;
plantcode.Value = vehicleBO.Plantcode;
vehicleno.Value = vehicleBO.Vehicleno;
truckid.Value = vehicleBO.Truckid;
truckname.Value = vehicleBO.Truckname;
phoneno.Value = vehicleBO.Phoneno;
bankid.Value = vehicleBO.Bankid;
ifsc.Value = vehicleBO.IFSC;
accountnum.Value = vehicleBO.ACCOUNTNUM;
ltrcost.Value = vehicleBO.Ltrcost;
paymentmode.Value = vehicleBO.Paymentmode;
cmd.ExecuteNonQuery();
message = (string)cmd.Parameters["@mess"].Value;
result = (int)cmd.Parameters["@ress"].Value;
if (result == 1)
{
//WebMsgBox.Show(message);
return(message);
}
else
{
//WebMsgBox.Show(message);
return(message);
}
}
}
public string insertTroutedistance(BOLvehicle vehicleBO)
{
string mes = string.Empty;
string sql = "Insert_TruckRouteDistance";
mes = trouteDA.insertRroutedistance(vehicleBO, sql);
return(mes);
}
public string UpdateDistanceTruckPresent(BOLvehicle vehicleBO)
{
string mes = string.Empty;
string sql = "Upadte_UpdateDistanceTruckPresen";
mes = vdetailDA.UpdateDistanceTruckPresentDAL(vehicleBO, sql);
return(mes);
}
public string insertvdetails(BOLvehicle vehicleBO)
{
string mes = string.Empty;
string sql = "Insert_VehicleDetails";
mes = vdetailDA.insertVdetails(vehicleBO, sql);
return(mes);
}
public string UpdateDistanceTruckPresentDAL(BOLvehicle vehicleBO, string sql)
{
using (con = DBaccess.GetConnection())
{
int result = 0;
string message = string.Empty;
SqlCommand cmd = new SqlCommand();
SqlParameter cmpcode, plantcode, truckid, pdate, Distance, vtsdistanve, admindistance, pmess, press;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmpcode = cmd.Parameters.Add("@Company_Code", SqlDbType.Int);
plantcode = cmd.Parameters.Add("@Plant_Code", SqlDbType.Int);
truckid = cmd.Parameters.Add("@Truck_Id", SqlDbType.Int);
pdate = cmd.Parameters.Add("@pdate", SqlDbType.Date);
Distance = cmd.Parameters.Add("@modifyDistance", SqlDbType.Float);
vtsdistanve = cmd.Parameters.Add("@vtsdistanve", SqlDbType.Float);
admindistance = cmd.Parameters.Add("@admindistance", SqlDbType.Float);
pmess = cmd.Parameters.Add("@mess", SqlDbType.Char, 500);
cmd.Parameters["@mess"].Direction = ParameterDirection.Output;
press = cmd.Parameters.Add("@ress", SqlDbType.Int);
cmd.Parameters["@ress"].Direction = ParameterDirection.Output;
cmpcode.Value = vehicleBO.Companycode;
plantcode.Value = vehicleBO.Plantcode;
truckid.Value = vehicleBO.Truckid;
pdate.Value = vehicleBO.Pdate;
Distance.Value = vehicleBO.Distance;
vtsdistanve.Value = vehicleBO.Vtsdistance;
admindistance.Value = vehicleBO.Admindistance;
cmd.ExecuteNonQuery();
message = (string)cmd.Parameters["@mess"].Value;
result = (int)cmd.Parameters["@ress"].Value;
if (result == 1)
{
//WebMsgBox.Show(message);
return(message);
}
else
{
//WebMsgBox.Show(message);
return(message);
}
}
}
public string insertRroutedistance(BOLvehicle vehicleBO, string sql)
{
using (con = DBaccess.GetConnection())
{
string message = String.Empty;
int result = 0;
SqlCommand cmd = new SqlCommand();
SqlParameter cmpcode, plantcode, truckid, proutedistance, mess, ress;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmpcode = cmd.Parameters.Add("@Company_Code", SqlDbType.Int);
plantcode = cmd.Parameters.Add("@Plant_Code", SqlDbType.Int);
truckid = cmd.Parameters.Add("@Truck_Id", SqlDbType.Int);
proutedistance = cmd.Parameters.Add("@Route_TotDistance", SqlDbType.Float);
mess = cmd.Parameters.Add("@mes", SqlDbType.Char, 500);
cmd.Parameters["@mes"].Direction = ParameterDirection.Output;
ress = cmd.Parameters.Add("@res", SqlDbType.Int);
cmd.Parameters["@res"].Direction = ParameterDirection.Output;
cmpcode.Value = vehicleBO.Companycode;
plantcode.Value = vehicleBO.Plantcode;
truckid.Value = vehicleBO.Truckid;
proutedistance.Value = vehicleBO.Distance;
cmd.ExecuteNonQuery();
message = (string)cmd.Parameters["@mes"].Value;
result = (int)cmd.Parameters["@res"].Value;
if (result == 1)
{
//WebMsgBox.Show(message);
return(message);
}
if (result == 2)
{
//WebMsgBox.Show(message);
return(message);
}
return(message);
}
}
public void insertTroute(BOLvehicle vehicleBO, string sql)
{
using (con = DBaccess.GetConnection())
{
SqlCommand cmd = new SqlCommand();
SqlParameter cmpcode, plantcode, truckid, routeid;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmpcode = cmd.Parameters.Add("@Company_Code", SqlDbType.Int);
plantcode = cmd.Parameters.Add("@Plant_Code", SqlDbType.Int);
truckid = cmd.Parameters.Add("@Truck_Id", SqlDbType.Int);
routeid = cmd.Parameters.Add("@Route_Id", SqlDbType.Int);
cmpcode.Value = vehicleBO.Companycode;
plantcode.Value = vehicleBO.Plantcode;
truckid.Value = vehicleBO.Truckid;
routeid.Value = vehicleBO.Routeid;
cmd.ExecuteNonQuery();
}
}
public void inserttroute(BOLvehicle vehicleBO)
{
string sql = "Insert_TruckRouteAllotment";
trouteDA.insertTroute(vehicleBO, sql);
}
public void InsertRouteSupervisorAllotment(BOLvehicle vehicleBO)
{
string sql = "Insert_RouteSupervisorAllotment";
trouteDA.insertRouteSupervisorAllotment(vehicleBO, sql);
}
