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); }