public void InsertWorkDayHour(WorkingDayHour workingDayHour)
{
if (_authenticatedUser.Role != UserRoleEnum.Admin)
{
throw new AuthenticationException("Invalid Role");
}
_foodTruckCompanySqlAccess.InsertWorkDayHour(workingDayHour, _authenticatedUser.UserId);
}
public void InsertWorkDayHour(WorkingDayHour workingDayHour, int userId)
{
using (var sqlConn = new SqlConnection(Utilities.GetDefaultConnectionString()))
{
var spName = "InsertWorkingDayHour";
using (var cmd = new SqlCommand(spName, sqlConn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DayOfWeek", workingDayHour.DayOfWeek.ToString());
cmd.Parameters.AddWithValue("@OpenTimeHours", workingDayHour.OpenTime.Hours);
cmd.Parameters.AddWithValue("@OpenTimeMinutes", workingDayHour.OpenTime.Minutes);
cmd.Parameters.AddWithValue("@CloseTimeHours", workingDayHour.CloseTime.Hours);
cmd.Parameters.AddWithValue("@CloseTimeMinutes", workingDayHour.CloseTime.Minutes);
cmd.Parameters.AddWithValue("@UserId", userId);
sqlConn.Open();
cmd.ExecuteNonQuery();
}
}
}
private static void ReadFoodTrackCompanyInfoFromReader(FoodTruckCompany result, SqlDataReader reader)
{
while (reader.Read())
{
result.FoodTruckCompanyId = int.Parse(reader["FoodTruckCompanyId"].ToString());
result.BusinessName = reader["BusinessName"].ToString();
result.PermitNumber = reader["FoodTruckCompanyPermitNumber"].ToString();
result.HealthCode = reader["FoodTruckCompanyHealthCode"].ToString();
result.HasCatering = bool.Parse(reader["HasCatering"].ToString());
result.HasVegeterianFood = bool.Parse(reader["HasVegeterianFood"].ToString());
result.HasVigenFood = bool.Parse(reader["HasVigenFood"].ToString());
result.Description = reader["FoodTruckCompanyDescription"].ToString();
//result.AdditionalInfo= reader["FoodTruckCompanyAdditionalInfoString"].ToString();
//result.AreaOfOperation= reader["FoodTruckCompanyAreaOfOperationString"].ToString();
result.CompanyType = (CompanyTypeEnum)int.Parse(reader["CompanyTypeID"].ToString());
var ownerInfo = new PersonalInfo()
{
PersonalInfoID = int.Parse(reader["OwnerId"].ToString()),
FirstName = reader["OwnerFirstName"].ToString(),
MiddleName = reader["OwnerMiddleName"].ToString(),
LastName = reader["OwnerLastName"].ToString(),
SSN = reader["OwnerSSN"].ToString(),
//DateOfBirth = string.IsNullOrEmpty(reader["OwnerDateOfBirth"].ToString()) ?
// DateTime.Parse(reader["OwnerDateOfBirth"].ToString()) : null,
Role = (PersonRoleEnum)(int.Parse(reader["OwnerRoleID"].ToString()))
};
result.OwnerInfo = ownerInfo;
}
reader.NextResult();
result.OfficeLocations = new List <Location>();
while (reader.Read())
{
var location = new Location();
location.LocationID = int.Parse(reader["LocationId"].ToString());
var address = new Address();
address.AddressID = int.Parse(reader["AddressId"].ToString());
address.Address1 = reader["Address1"].ToString();
address.Address2 = reader["Address2"].ToString();
address.AddressType = (AddressTypeEnum)int.Parse(reader["AddressTypeId"].ToString());
address.City = reader["City"].ToString();
address.Coordination = new Coordination();
var latitude = reader["Latitude"].ToString();
address.Coordination.Latitude = (!string.IsNullOrEmpty(latitude)) ? decimal.Parse(latitude) : 0;
var longitude = reader["Longitude"].ToString();
address.Coordination.Longitude = (!string.IsNullOrEmpty(longitude)) ? decimal.Parse(longitude) : 0;
address.State = reader["State"].ToString();
address.Zipcode = reader["Zipcode"].ToString();
var phoneNumbersXml = reader["PhoneNumbers"].ToString();
location.PhoneNumbers = new List <Phone>();
if (!string.IsNullOrEmpty(phoneNumbersXml))
{
location.PhoneNumbers = Utilities.DeserializeXmlToObject <List <Phone> >(phoneNumbersXml);
}
var workingDayHoursXml = reader["WorkingDayHours"].ToString();
location.WorkingDayHours = new List <WorkingDayHour>();
if (!string.IsNullOrEmpty(workingDayHoursXml))
{
var workingDayHoursString = Utilities.DeserializeXmlToObject <List <WorkingDayHourString> >(workingDayHoursXml);
foreach (var item in workingDayHoursString)
{
var workingDayHour = new WorkingDayHour();
workingDayHour.WorkingDayHourID = item.WorkingDayHourID;
workingDayHour.DayOfWeek = item.DayOfWeek;
workingDayHour.OpenTime = TimeSpan.Parse($"{item.OpenTimeHours}:{item.OpenTimeMinutes}");
workingDayHour.CloseTime = TimeSpan.Parse($"{item.CloseTimeHours}:{item.CloseTimeMinutes}");
location.WorkingDayHours.Add(workingDayHour);
}
}
result.OfficeLocations.Add(location);
}
reader.NextResult();
result.Contacts = new List <ContactInfo>();
while (reader.Read())
{
var contactInfo = new ContactInfo()
{
Contact = reader["Contact"].ToString(),
ContactInfoID = int.Parse(reader["ContactInfoId"].ToString()),
ContactType = (ContactTypeEnum)int.Parse(reader["ContactTypeId"].ToString()),
DisplayOrder = int.Parse(reader["DisplayOrder"].ToString())
};
result.Contacts.Add(contactInfo);
}
reader.NextResult();
result.CuisineCategories = new List <CuisineCategoryEnum>();
while (reader.Read())
{
result.CuisineCategories.Add((CuisineCategoryEnum)int.Parse(reader["CuisineCategoryID"].ToString()));
}
reader.NextResult();
result.MealTypes = new List <MealTypeEnum>();
while (reader.Read())
{
result.MealTypes.Add((MealTypeEnum)int.Parse(reader["MealTypeID"].ToString()));
}
reader.NextResult();
result.FoodTrucks = new List <FoodTruck>();
while (reader.Read())
{
var foodTruck = new FoodTruck();
foodTruck.FoodTruckID = int.Parse(reader["FoodTruckId"].ToString());
foodTruck.Name = reader["FoodTruckName"].ToString();
foodTruck.StartDate = DateTime.Parse(reader["FoodTruckStartDate"].ToString());
foodTruck.TruckMake = reader["FoodTruckTruckMake"].ToString();
foodTruck.TruckModel = reader["FoodTruckTruckModel"].ToString();
foodTruck.Year = int.Parse(reader["FoodTruckYear"].ToString());
foodTruck.Color = reader["FoodTruckColor"].ToString();
foodTruck.CookInfo = new PersonalInfo();
if (reader["FoodTruckCookID"] != null && !string.IsNullOrEmpty(reader["FoodTruckCookID"].ToString()))
{
foodTruck.CookInfo.PersonalInfoID = int.Parse(reader["FoodTruckCookID"].ToString());
}
if (reader["FoodTruckCookFirstName"] != null && !string.IsNullOrEmpty(reader["FoodTruckCookFirstName"].ToString()))
{
foodTruck.CookInfo.FirstName = reader["FoodTruckCookFirstName"].ToString();
}
if (reader["FoodTruckCookMiddleName"] != null && !string.IsNullOrEmpty(reader["FoodTruckCookMiddleName"].ToString()))
{
foodTruck.CookInfo.MiddleName = reader["FoodTruckCookMiddleName"].ToString();
}
if (reader["FoodTruckCookLastName"] != null && !string.IsNullOrEmpty(reader["FoodTruckCookLastName"].ToString()))
{
foodTruck.CookInfo.LastName = reader["FoodTruckCookLastName"].ToString();
}
if (reader["FoodTruckCookPersonalInfoID"] != null && !string.IsNullOrEmpty(reader["FoodTruckCookPersonalInfoID"].ToString()))
{
foodTruck.CookInfo.PersonalInfoID = int.Parse(reader["FoodTruckCookPersonalInfoID"].ToString());
}
if (reader["FoodTruckCookRoleId"] != null && !string.IsNullOrEmpty(reader["FoodTruckCookRoleId"].ToString()))
{
foodTruck.CookInfo.Role = (PersonRoleEnum)int.Parse(reader["FoodTruckCookRoleId"].ToString());
}
if (reader["FoodTruckCookSSN"] != null && !string.IsNullOrEmpty(reader["FoodTruckCookSSN"].ToString()))
{
foodTruck.CookInfo.SSN = reader["FoodTruckCookSSN"].ToString();
}
if (reader["FoodTruckCookDateOfBirth"] != null && !string.IsNullOrEmpty(reader["FoodTruckCookDateOfBirth"].ToString()))
{
foodTruck.CookInfo.DateOfBirth = DateTime.Parse(reader["FoodTruckCookDateOfBirth"].ToString());
}
foodTruck.CuisineCategory = (CuisineCategoryEnum)int.Parse(reader["FoodTruckCuisineCategoryId"].ToString());
foodTruck.Description = reader["FoodTruckDescription"].ToString();
foodTruck.Driver = new PersonalInfo();
if (reader["FoodTruckDriverID"] != null && !string.IsNullOrEmpty(reader["FoodTruckDriverID"].ToString()))
{
foodTruck.Driver.PersonalInfoID = int.Parse(reader["FoodTruckDriverID"].ToString());
}
if (reader["FoodTruckDriverFirstName"] != null && !string.IsNullOrEmpty(reader["FoodTruckDriverFirstName"].ToString()))
{
foodTruck.Driver.FirstName = reader["FoodTruckDriverFirstName"].ToString();
}
if (reader["FoodTruckDriverMiddleName"] != null && !string.IsNullOrEmpty(reader["FoodTruckDriverMiddleName"].ToString()))
{
foodTruck.Driver.MiddleName = reader["FoodTruckDriverMiddleName"].ToString();
}
if (reader["FoodTruckDriverLastName"] != null && !string.IsNullOrEmpty(reader["FoodTruckDriverLastName"].ToString()))
{
foodTruck.Driver.LastName = reader["FoodTruckDriverLastName"].ToString();
}
if (reader["FoodTruckDriverPersonalInfoID"] != null && !string.IsNullOrEmpty(reader["FoodTruckDriverPersonalInfoID"].ToString()))
{
foodTruck.Driver.PersonalInfoID = int.Parse(reader["FoodTruckDriverPersonalInfoID"].ToString());
}
if (reader["FoodTruckDriverRoleId"] != null && !string.IsNullOrEmpty(reader["FoodTruckDriverRoleId"].ToString()))
{
foodTruck.Driver.Role = (PersonRoleEnum)int.Parse(reader["FoodTruckDriverRoleId"].ToString());
}
if (reader["FoodTruckDriverSSN"] != null && !string.IsNullOrEmpty(reader["FoodTruckDriverSSN"].ToString()))
{
foodTruck.Driver.SSN = reader["FoodTruckDriverSSN"].ToString();
}
if (reader["FoodTruckDriverDateOfBirth"] != null && !string.IsNullOrEmpty(reader["FoodTruckDriverDateOfBirth"].ToString()))
{
foodTruck.Driver.DateOfBirth = DateTime.Parse(reader["FoodTruckDriverDateOfBirth"].ToString());
}
foodTruck.HealthCode = reader["FoodTruckHealthCode"].ToString();
foodTruck.LicensePlate = reader["FoodTruckLicensePlate"].ToString();
foodTruck.MaxCapacityPerMeal = int.Parse(reader["FoodTruckMaxCapacityPerMeal"].ToString());
foodTruck.MealType = (MealTypeEnum)int.Parse(reader["FoodTruckMealTypeId"].ToString());
result.FoodTrucks.Add(foodTruck);
}
reader.NextResult();
}
