public async Task <IActionResult> Edit(int id, [Bind("ID,BusinessName,CompanyTypeName,PermitNumber,HasVegeterianFood,HasVigenFood,HasCatering,HealthCode,Description,AreaOfOperationString,AdditionalInfoString")] FoodTruckCompany foodTruckCompany)
{
if (id != foodTruckCompany.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(foodTruckCompany);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FoodTruckCompanyExists(foodTruckCompany.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(foodTruckCompany));
}
public void UpdateFoodTruckCompany(FoodTruckCompany foodTruckCompany)
{
if (_authenticatedUser.Role != UserRoleEnum.Admin)
{
throw new AuthenticationException("Invalid Role");
}
_foodTruckCompanySqlAccess.UpdateFoodTruckCompany(foodTruckCompany, _authenticatedUser.UserId);
}
public int CreateFoodTruckCompany(FoodTruckCompany foodTruckCompany)
{
if (_authenticatedUser.Role != UserRoleEnum.Admin)
{
throw new AuthenticationException("Invalid Role");
}
return(_foodTruckCompanySqlAccess.CreateFoodTruckCompany(foodTruckCompany, _authenticatedUser.UserId));
}
public async Task <IActionResult> Create([
Bind("ID,BusinessName,CompanyTypeName,PermitNumber,HasVegeterianFood,HasVigenFood,HasCatering,HealthCode,Description,AreaOfOperationString,AdditionalInfoString,MealTypeNames,CuisineCategoyNames")] FoodTruckCompany foodTruckCompany)
{
if (ModelState.IsValid)
{
_context.Add(foodTruckCompany);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(foodTruckCompany));
}
public void UpdateFoodTruckCompany(FoodTruckCompany foodTruckCompany, int userId)
{
var result = new List <FoodTruckCompany>();
using (var sqlConn = new SqlConnection(Utilities.GetDefaultConnectionString()))
{
var spName = "UpdateFoodTruckCompany";
using (var cmd = new SqlCommand(spName, sqlConn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FoodTruckCompanyID", foodTruckCompany.FoodTruckCompanyId);
cmd.Parameters.AddWithValue("@BusinessName", foodTruckCompany.BusinessName);
cmd.Parameters.AddWithValue("@Description", foodTruckCompany.Description);
cmd.Parameters.AddWithValue("@CompanyTypeID", (int)foodTruckCompany.CompanyType);
cmd.Parameters.AddWithValue("@PermitNumber", foodTruckCompany.PermitNumber);
cmd.Parameters.AddWithValue("@HealthCode", foodTruckCompany.HealthCode);
cmd.Parameters.AddWithValue("@HasCatering", foodTruckCompany.HasCatering);
cmd.Parameters.AddWithValue("@HasVegeterianFood", foodTruckCompany.HasVegeterianFood);
cmd.Parameters.AddWithValue("@HasVigenFood", foodTruckCompany.HasVigenFood);
if (foodTruckCompany.AdditionalInfo != null && foodTruckCompany.AdditionalInfo.Count > 0)
{
cmd.Parameters.AddWithValue("@AdditionalInfo", Utilities.SerializeObjectToJson(foodTruckCompany.AdditionalInfo));
}
if (foodTruckCompany.AreaOfOperation != null && foodTruckCompany.AreaOfOperation.Count > 0)
{
cmd.Parameters.AddWithValue("@AreaOfOperation", foodTruckCompany.AreaOfOperation);
}
if (foodTruckCompany.MealTypes != null && foodTruckCompany.MealTypes.Count > 0)
{
cmd.Parameters.AddWithValue("@MealTypeIDs", string.Join(",", foodTruckCompany.MealTypes.Select(x => (int)x).ToList()));
}
if (foodTruckCompany.CuisineCategories != null && foodTruckCompany.CuisineCategories.Count > 0)
{
cmd.Parameters.AddWithValue("@CuisineCategoryIDs", string.Join(",", foodTruckCompany.CuisineCategories.Select(x => (int)x).ToList()));
}
cmd.Parameters.AddWithValue("@UserId", userId);
sqlConn.Open();
cmd.ExecuteNonQuery();
}
}
}
public FoodTruckCompany GetFoodTruckCompanyById(int foodTruckCompanyId)
{
var result = new FoodTruckCompany();
using (var sqlConn = new SqlConnection(Utilities.GetDefaultConnectionString()))
{
var spName = "GetFoodTruckCompanyById";
using (var cmd = new SqlCommand(spName, sqlConn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FoodTruckCompanyID", foodTruckCompanyId);
sqlConn.Open();
var reader = cmd.ExecuteReader();
ReadFoodTrackCompanyInfoFromReader(result, reader);
}
}
return(result);
}
public List <FoodTruckCompany> SearchFoodTruckCompany(FoodTruckCompanySearchCriteria criteria)
{
var result = new List <FoodTruckCompany>();
using (var sqlConn = new SqlConnection(Utilities.GetDefaultConnectionString()))
{
var spName = "SearchFoodTruckCompanies";
using (var cmd = new SqlCommand(spName, sqlConn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BusinessName", criteria.BusinessName);
cmd.Parameters.AddWithValue("@Zipcode", criteria.Zipcode);
cmd.Parameters.AddWithValue("@City", criteria.City);
if (criteria.Latitude != 0)
{
cmd.Parameters.AddWithValue("@Latitude", criteria.Latitude);
}
if (criteria.Longitude != 0)
{
cmd.Parameters.AddWithValue("@Longiture", criteria.Longitude);
}
if (criteria.Radius != 0)
{
cmd.Parameters.AddWithValue("@Radius", criteria.Radius);
}
sqlConn.Open();
var reader = cmd.ExecuteReader();
while (reader.HasRows)
{
var ftcItem = new FoodTruckCompany();
ReadFoodTrackCompanyInfoFromReader(ftcItem, reader);
result.Add(ftcItem);
}
}
}
return(result);
}
public IActionResult Put(int id, [FromBody] FoodTruckCompany foodTruckCompany)
{
foodTruckCompany.FoodTruckCompanyId = id;
_businessLayer.UpdateFoodTruckCompany(foodTruckCompany);
return(Ok());
}
public IActionResult Post([FromBody] FoodTruckCompany foodTruckCompany)
{
var foodTruckCompanyId = _businessLayer.CreateFoodTruckCompany(foodTruckCompany);
return(Created($"{_resourceUrl}{foodTruckCompanyId}", foodTruckCompanyId));
}
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();
}
public int CreateFoodTruckCompany(FoodTruckCompany foodTruckCompany, int userId)
{
var result = 0;
using (var sqlConn = new SqlConnection(Utilities.GetDefaultConnectionString()))
{
var spName = "InsertFoodTruckCompany";
using (var cmd = new SqlCommand(spName, sqlConn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BusinessName", foodTruckCompany.BusinessName);
cmd.Parameters.AddWithValue("@Description", foodTruckCompany.Description);
cmd.Parameters.AddWithValue("@CompanyTypeID", (int)foodTruckCompany.CompanyType);
cmd.Parameters.AddWithValue("@PermitNumber", foodTruckCompany.PermitNumber);
cmd.Parameters.AddWithValue("@HealthCode", foodTruckCompany.HealthCode);
cmd.Parameters.AddWithValue("@HasCatering", foodTruckCompany.HasCatering);
cmd.Parameters.AddWithValue("@HasVegeterianFood", foodTruckCompany.HasVegeterianFood);
cmd.Parameters.AddWithValue("@HasVigenFood", foodTruckCompany.HasVigenFood);
if (foodTruckCompany.AdditionalInfo != null && foodTruckCompany.AdditionalInfo.Count > 0)
{
cmd.Parameters.AddWithValue("@AdditionalInfo", Utilities.SerializeObjectToJson(foodTruckCompany.AdditionalInfo));
}
if (foodTruckCompany.AreaOfOperation != null && foodTruckCompany.AreaOfOperation.Count > 0)
{
cmd.Parameters.AddWithValue("@AreaOfOperation", foodTruckCompany.AreaOfOperation);
}
if (foodTruckCompany.OfficeLocations != null && foodTruckCompany.OfficeLocations.Count > 0)
{
cmd.Parameters.AddWithValue("@LocationIDs", string.Join(",", foodTruckCompany.OfficeLocations.Select(x => x.LocationID).ToList()));
}
if (foodTruckCompany.Contacts != null && foodTruckCompany.Contacts.Count > 0)
{
cmd.Parameters.AddWithValue("@ContactInfoXmlString", Utilities.SerializeObjectToXml(foodTruckCompany.Contacts));
}
if (foodTruckCompany.OwnerInfo != null)
{
cmd.Parameters.AddWithValue("@OwnerID", foodTruckCompany.OwnerInfo.PersonalInfoID);
}
if (foodTruckCompany.FoodTrucks != null && foodTruckCompany.FoodTrucks.Count > 0)
{
cmd.Parameters.AddWithValue("@FoodTruckIDs", string.Join(",", foodTruckCompany.FoodTrucks.Select(x => x.FoodTruckID).ToList()));
}
if (foodTruckCompany.MealTypes != null && foodTruckCompany.MealTypes.Count > 0)
{
cmd.Parameters.AddWithValue("@MealTypeIDs", string.Join(",", foodTruckCompany.MealTypes.Select(x => (int)x).ToList()));
}
if (foodTruckCompany.CuisineCategories != null && foodTruckCompany.CuisineCategories.Count > 0)
{
cmd.Parameters.AddWithValue("@CuisineCategoryIDs", string.Join(",", foodTruckCompany.CuisineCategories.Select(x => (int)x).ToList()));
}
cmd.Parameters.AddWithValue("@UserId", userId);
var returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int);
returnValue.Direction = ParameterDirection.Output;
cmd.Parameters.Add(returnValue);
//var a = "";
//for (int i = 0; i < cmd.Parameters.Count; i++)
//{
// if(cmd.Parameters[i].ParameterName != "@ReturnValue")
// a += cmd.Parameters[i].ParameterName + " = '" + cmd.Parameters[i].Value.ToString() + "'," + Environment.NewLine;
//}
sqlConn.Open();
var reader = cmd.ExecuteReader();
result = int.Parse(returnValue.Value.ToString());
}
}
return(result);
}
