public int InsertUpdateRouteDetails(RouteDetails model)
{
int result = 0;
try
{
cmd = new SqlCommand("USP_Route");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SchoolID", model.SchoolID);
cmd.Parameters.AddWithValue("@FinancialYearID", model.FinancialYearID);
cmd.Parameters.AddWithValue("@RouteID", model.RouteID);
cmd.Parameters.AddWithValue("@RouteName", model.RouteName);
cmd.Parameters.AddWithValue("@VehicleID", model.VehicleID);
cmd.Parameters.AddWithValue("@IsActive", model.IsActive);
cmd.Parameters.AddWithValue("@Action", model.Action);
cmd.Parameters.AddWithValue("@CreatedBy", model.CreatedBy);
result = Convert.ToInt32(DBHelper.ExecuteScalar(cmd));
}
catch (Exception ex)
{
ExecptionLogger.FileHandling("DALTransport(InsertUpdateDriverDetails)", "Error_014", ex, "DALTransport");
}
finally
{
cmd.Dispose();
}
return(result);
}
public void CopyTo(RouteDetails obj)
{
obj.ID = this.ID;
obj.RouteId = this.RouteId;
obj.RouteName = this.RouteName;
obj.StationName = this.StationName;
obj.MachineType = this.MachineType;
obj.MactypeCode = this.MactypeCode;
obj.NextStation = this.NextStation;
obj.FailNextStation = this.FailNextStation;
obj.FLAG = this.FLAG;
obj.OrderId = this.OrderId;
obj.MEMO = this.MEMO;
obj.CreatedDate = this.CreatedDate;
obj.UpdatedDate = this.UpdatedDate;
obj.UpdatedBy = this.UpdatedBy;
obj.StationId = this.StationId;
}
public List <PickDropPoint> GetPickDropPointList(RouteDetails model)
{
List <PickDropPoint> obj = new List <PickDropPoint>();
try
{
cmd = new SqlCommand("USP_PickDropPoint");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SchoolID", model.SchoolID);
cmd.Parameters.AddWithValue("@FinancialYearID", model.FinancialYearID);
cmd.Parameters.AddWithValue("@RouteID", model.RouteID);
cmd.Parameters.AddWithValue("@Action", "GET");
var dr = DBHelper.ExecuteReader(cmd);
while (dr.Read())
{
obj.Add(new PickDropPoint
{
RouteID = Convert.ToInt32(dr["RouteID"]),
PickDropID = Convert.ToInt32(dr["PickDropID"]),
PickDropPointName = Convert.ToString(dr["PickDropPointName"]),
PickupTime = Convert.ToString(dr["PickupTime"]),
DropTime = Convert.ToString(dr["DropTime"]),
Fee = Convert.ToDouble(dr["Fee"]),
SchoolID = Convert.ToInt32(dr["SchoolID"]),
FinancialYearID = Convert.ToInt32(dr["FinancialYearID"]),
CreatedBy = Convert.ToString(dr["CreatedBy"]),
});
}
}
catch (Exception ex)
{
ExecptionLogger.FileHandling("DALTransport(GetVehicleList)", "Error_014", ex, "DALTransport");
}
finally
{
cmd.Dispose();
}
return(obj);
}
public Object Clone()
{
RouteDetails obj = new RouteDetails();
obj.ID = this.ID;
obj.RouteId = this.RouteId;
obj.RouteName = this.RouteName;
obj.StationName = this.StationName;
obj.MachineType = this.MachineType;
obj.MactypeCode = this.MactypeCode;
obj.NextStation = this.NextStation;
obj.FailNextStation = this.FailNextStation;
obj.FLAG = this.FLAG;
obj.OrderId = this.OrderId;
obj.MEMO = this.MEMO;
obj.CreatedDate = this.CreatedDate;
obj.UpdatedDate = this.UpdatedDate;
obj.UpdatedBy = this.UpdatedBy;
obj.StationId = this.StationId;
return(obj);
}
