private BusinessManagementModel BusinessModelHelper()
{
BusinessManagementModel model = new BusinessManagementModel();
model.NewBusiness = new BusinessModel();
model.Businesses = new List <BusinessModel>();
if (TempData["UserId"] != null)
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("spGetBusinessesByUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", TempData["UserId"].ToString());
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
BusinessModel business = new BusinessModel();
business.CompanyName = sdr["CompanyName"].ToString();
business.RegistrationNumber = sdr["RegistrationNumber"].ToString();
business.Category = sdr["Category"].ToString();
business.NumEmployees = (int)sdr["NumEmployees"];
business.Address = sdr["Address"].ToString();
business.RequestStatus = sdr["RequestStatus"].ToString();
business.UserId = sdr["UserId"].ToString();
model.Businesses.Add(business);
}
}
}
return(model);
}
public IActionResult RegisterBusiness(BusinessManagementModel businessManagementModel)
{
if (ModelState.IsValid)
{
try{
BusinessModel business = new BusinessModel(businessManagementModel.NewBusiness);
business.RequestStatus = "Pending";
business.UserId = TempData["UserId"].ToString();
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("spAddNewBusiness", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.Parameters.AddWithValue("@CompanyName", business.CompanyName);
cmd.Parameters.AddWithValue("@RegistrationNumber", business.RegistrationNumber);
cmd.Parameters.AddWithValue("@Category", business.Category);
cmd.Parameters.AddWithValue("@NumEmployees", business.NumEmployees);
cmd.Parameters.AddWithValue("@Address", business.Address);
cmd.Parameters.AddWithValue("@AddressTown", business.AddressTown);
cmd.Parameters.AddWithValue("@AddressLongitude", business.AddressLongitude);
cmd.Parameters.AddWithValue("@AddressLatitude", business.AddressLatitude);
cmd.Parameters.AddWithValue("@RequestStatus", business.RequestStatus);
cmd.Parameters.AddWithValue("@UserId", business.UserId);
cmd.ExecuteNonQuery();
}
TempData["SuccessMessage"] = "Successfully sent business registration request";
}
catch (Exception) {
TempData["ErrorMessage"] = "Something went wrong. Please try again later.";
}
return(RedirectToAction("Index"));
}
BusinessManagementModel model = BusinessModelHelper();
model.NewBusiness = businessManagementModel.NewBusiness;
return(View(model));
}
