public string PostDriverDetails(DriverDetails dtls)
{
try
{
if (!cabODbContext.Driver.Any(r => r.PhoneNo == dtls.PhoneNo && r.IsDeleted == false))
{
var user = new Driver
{
Name = dtls.Name,
PhoneNo = dtls.PhoneNo,
UserName = dtls.UserName,
Password = dtls.Password,
IsDeleted = dtls.IsDeleted
};
cabODbContext.Driver.Add(user);
cabODbContext.SaveChanges();
return("Posted");
}
else
{
throw new Exception();
}
}
catch (Exception ex)
{
throw ex;
}
}
public int AddOfficeCommutation(OfficeCommutationDto officeDto)
{
try
{
int insertedId = 0;
if (!cabODbContext.OfficeCommutation.Any(x => x.Location1 == Int32.Parse(officeDto.Location1) && x.Location2 == Int32.Parse(officeDto.Location2) && x.IsDeleted == false))
{
var commutation = new OfficeCommutation
{
Location1 = Int32.Parse(officeDto.Location1),
Location2 = Int32.Parse(officeDto.Location2),
CabId = Int32.Parse(officeDto.CabId),
IsDeleted = false
};
cabODbContext.OfficeCommutation.Add(commutation);
cabODbContext.SaveChanges();
insertedId = commutation.Id;
}
return(insertedId);
}
catch (Exception ex)
{
throw ex;
}
}
public int AddCab(cabdto cabdetails)
{
try
{
if (!_context.Cab.Any(r => r.VehicleNo == cabdetails.VehicleNo && r.IsDeleted == false))
{
var CabDetail = new Cab
{
Capacity = Int32.Parse(cabdetails.Capacity),
Model = cabdetails.Model,
VehicleNo = cabdetails.VehicleNo
};
_context.Cab.Add(CabDetail);
_context.SaveChanges();
}
else
{
throw new Exception();
}
return(1);
}
catch (Exception e)
{
throw e;
}
}
public int AddRide(RideAssignmentDto rideDto)
{
try
{
int value = 0;
var days = rideDto.Days;
int i = 0;
var rideList = cabODbContext.RideAssignment;
List <RideAssignment> store = new List <RideAssignment>();
while (i < days)
{
var ddate = rideDto.DailyDate.AddDays(i);
if ((!cabODbContext.RideAssignment.Any(x => x.ShiftId == Convert.ToInt32(rideDto.ShiftId) &&
x.DailyDate.Date == ddate.Date &&
x.IsDeleted == false && (x.DriverId == Convert.ToInt32(rideDto.DriverId) || x.CabId == Convert.ToInt32(rideDto.CabId)))))
{
var rides = new RideAssignment
{
DailyDate = rideDto.DailyDate.AddDays(i),
DriverId = Int32.Parse(rideDto.DriverId),
CabId = Int32.Parse(rideDto.CabId),
ShiftId = Int32.Parse(rideDto.ShiftId),
IsDeleted = false
};
store.Add(rides);
value = 1;
}
else
{
value = 0;
}
i++;
}
cabODbContext.RideAssignment.AddRange(store);
cabODbContext.SaveChanges();
return(value);
}
catch (Exception ex)
{
throw ex;
}
}
public int AddLocation(OfficeLocationDto location)
{
try
{
int insertedId = 0;
if (!_context.OfficeLocation.Any(r => r.Address == location.Address && r.IsDeleted == false))
{
var office_location = new OfficeLocation
{
Address = location.Address
};
_context.OfficeLocation.Add(office_location);
_context.SaveChanges();
insertedId = office_location.Id;
}
return(insertedId);
}
catch
{
return(0);
}
}
public bool addRating(RatingInfo rating)
{
try
{
var rideId = cabODbContext.Ride.FirstOrDefault(r => r.Guid == rating.rideId).Id;
Rating ratingData = new Rating {
RideId = rideId,
Timing = rating.timing,
Behaviour = rating.behaviour,
Overall = rating.overall,
Comments = rating.comments
};
cabODbContext.Rating.Add(ratingData);
cabODbContext.SaveChanges();
return(true);
}
catch (Exception e)
{
throw e;
}
}
