public int AddVehicle(Vehicle obj)
{
DBParams[] dbParams = new DBParams[8];
dbParams[0] = new DBParams("@cunt_id", obj.cunt_id, ParamType.Int, ParamDirection.Input);
dbParams[1] = new DBParams("@vehi_state", obj.vehi_state, ParamType.String, ParamDirection.Input);
dbParams[2] = new DBParams("@vehi_number", obj.vehi_number, ParamType.String, ParamDirection.Input);
dbParams[3] = new DBParams("@own_name", obj.own_name, ParamType.String, ParamDirection.Input);
dbParams[4] = new DBParams("@own_address", obj.own_address, ParamType.String, ParamDirection.Input);
dbParams[5] = new DBParams("@own_phone", obj.own_phone, ParamType.String, ParamDirection.Input);
dbParams[6] = new DBParams("@vehi_type", obj.vehi_type, ParamType.String, ParamDirection.Input);
dbParams[7] = new DBParams("@vehi_layout", obj.vehi_layout, ParamType.String, ParamDirection.Input);
DALHandler.ExecuteStatement(Constants.AddVehicle, dbParams);
return(1);
}
public int CreateSchedule(Scheduling obj)
{
DBParams[] dbParams = new DBParams[10];
dbParams[0] = new DBParams("@cunt_id", obj.cunt_id, ParamType.Int, ParamDirection.Input);
dbParams[1] = new DBParams("@vehi_number", obj.vehi_number, ParamType.String, ParamDirection.Input);
dbParams[2] = new DBParams("@frm_city", obj.frm_city, ParamType.String, ParamDirection.Input);
dbParams[3] = new DBParams("@to_city", obj.to_city, ParamType.String, ParamDirection.Input);
dbParams[4] = new DBParams("@mode", obj.mode, ParamType.String, ParamDirection.Input);
dbParams[5] = new DBParams("@dtm_date", obj.dtm_date, ParamType.DateTime, ParamDirection.Input);
dbParams[6] = new DBParams("@schd_time", obj.schd_time, ParamType.String, ParamDirection.Input);
dbParams[7] = new DBParams("@tran_value", obj.tran_value, ParamType.Int, ParamDirection.Input);
dbParams[8] = new DBParams("@custdis", obj.cust_dis, ParamType.Int, ParamDirection.Input);
dbParams[9] = new DBParams("@frandis", obj.fran_dis, ParamType.Int, ParamDirection.Input);
DALHandler.ExecuteStatement(Constants.CreateSchedule, dbParams);
return(1);
}
