Reference checkbox within db using asp.net mvc

HI Team

I need some help, i created a checkbox and countrylist, they both dont reference as data types objects on my table defition. When a person select e.g Countrylist(Ghana), checkbox(Halaal, Vegetarian). Who can show me how to achieve this? meaning when i select them from the form they dont get saved from the db. Both become NULL only instead of that value.

// Controller
private List LoadData()
{
List lst = new List();
try
{
string line = string.Empty;
string srcFilePath = "Content/files/country_list.txt";
var rootPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
var fullPath = Path.Combine(rootPath, srcFilePath);
string filePath = new Uri(fullPath).LocalPath;
StreamReader src = new StreamReader(new FileStream(filePath, FileMode.Open, FileAccess.Read));
// while to read the file
while ((line = src.ReadLine()) != null)
{
RegistrationTrainingForm infoLst = new RegistrationTrainingForm();
string[] info = line.Split(',');
//Setting
infoLst.Country_Id = Convert.ToInt32(info[0].ToString());
infoLst.Country_Name = info[1].ToString();
lst.Add(infoLst);
}
src.Dispose();
src.Close();
}
catch (Exception ex)
{
Console.Write(ex);
}
return lst;
}
// List for countries.
private IEnumerable GetCountryList()
{
SelectList listcn = null;
try
{
var list = this.LoadData().Select(p => new SelectListItem
{
Value = p.Country_Id.ToString(),
Text = p.Country_Name
});
listcn = new SelectList(list, "Value", "Text");
}
catch (Exception ex)
{
throw ex;
}
return listcn;
}

// Model
public class DropDownViewModel
{
public string Title { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Position { get; set; }
public string Company { get; set; }
public string StreetAddress { get; set; }
public string StreetAddressLine { get; set; }
public string City { get; set; }
public string State { get; set; }
public string Country { get; set; }
public int ZipCode { get; set; }
public string Email { get; set; }
public int CellNumber { get; set; }
public string DietaryRequirements { get; set; }
public int Country_Id { get; set; }
public string Country_Name { get; set; }
}
public class DietViewModel
{
[Display(Name = "None")]
[Range(typeof(bool), "true", "true")]
public bool None { get; set; }
[Display(Name = "Vegetarian")]
[Range(typeof(bool), "true", "true")]
public bool Vegetarian { get; set; }
[Display(Name = "Vegan")]
[Range(typeof(bool), "true", "true")]
public bool Vegan { get; set; }
[Display(Name = "Halaal")]
[Range(typeof(bool), "true", "true")]
public bool Halaal { get; set; }
[Display(Name = "Other")]
[Range(typeof(bool), "true", "true")]
public bool Other { get; set; }
}

// View
class="form-group row">
class="col-sm-2 col-form-label">Dietary requirements:
class="col-sm-3">
class="form-check">
@Html.CheckBoxFor(m => m.DietMain.None, new { @class = "form-check-input" })
class="form-check-label" for="@Html.IdFor(m => m.DietMain.None)">None

class="form-check">

@Html.CheckBoxFor(m => m.DietMain.Vegetarian, new { @class = "form-check-input" })

class="form-check-label" for="@Html.IdFor(m => m.DietMain.Vegetarian)">Vegetarian

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User6y ago
Hi Ronika

The issue my values are stored as null from the table in the database. what am i missing, i want to store them as raw data according form selection.
Ronika Jency6y ago
Hi,

I didn't get your question properly.

m.DietMain.Vegetarian - this value should be null is it?