public List <Treater> GetList()
{
List <Treater> lit = new List <Treater>();
//lit = Cand_GetList;
using (SqlConnection connection = new SqlConnection("Server=(localdb)\\MSSQLLocalDB;Database=master;"))
{
using (SqlCommand command = new SqlCommand("Treaters_GetList", connection))
{
command.CommandType = CommandType.StoredProcedure;
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Treater trea = new Treater();
trea.Name = reader["Name"].ToString();
trea.FavCand = (int)reader["FavoriteCandyID"];
trea.Cost = (int)reader["CostumeID"];
trea.ID = (int)reader["ID"];
lit.Add(trea);
}
}
}
}
return(lit);
}
public List <Treater> GetList()
{
List <Treater> treaterList = new List <Treater>();
using (SqlConnection connection = new SqlConnection(GetConnectionString()))
{
using (SqlCommand command = new SqlCommand("Treaters_GetList", connection))
{
command.CommandType = CommandType.StoredProcedure;
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Candy candy = new Candy();
candy.id = (int)reader["CandyID"];
candy.productName = reader["CandyName"].ToString();
Costume costume = new Costume();
costume.id = (int)reader["CostumeID"];
costume.costume = reader["CostumeName"].ToString();
Treater treater = new Treater();
treater.id = (int)reader["TreaterID"];
treater.name = reader["TreaterName"].ToString();
treater.favoriteCandy = candy;
treater.costume = costume;
treaterList.Add(treater);
}
}
}
}
return(treaterList);
}
public List <Treater> GetList()
{
List <Treater> treaterList = new List <Treater>();
using (SqlConnection connection = new SqlConnection(GetConnectionString()))
{
using (SqlCommand command = new SqlCommand("Treaters_GetList", connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Treater treater = new Treater
{
Id = (int)reader["Id"],
Name = reader["Name"].ToString(),
FavoriteCandyID = (int)reader["FavoriteCandyID"],
CostumeID = (int)reader["CostumeID"]
};
treaterList.Add(treater);
}
}
}
}
return(treaterList);
}
public void Insert(Treater treater)
{
List <Treater> treaterList = GetList();
treater.id = (treaterList.Count <= 0) ? 0 : treaterList.Select(m => m.id).Max() + 1;
treaterList.Add(treater);
WriteList(treaterList);
}
public void Insert(Treater treater)
{
_treaterList.Add(treater);
using (StreamWriter sw = new StreamWriter(_treaterDir))
{
sw.Write(JsonConvert.SerializeObject(_treaterList));
}
}
public static TreaterModel GetTreaterModel(this Treater treater)
{
TreaterModel model = new TreaterModel();
model.TreaterID = treater.id;
model.TreaterName = treater.name;
model.CandyID = treater.favoriteCandy.id;
model.CandyName = treater.favoriteCandy.productName;
model.CostumeID = treater.costume.id;
model.CostumeName = treater.costume.costume;
return(model);
}
public void Insert(Treater treater)
{
using (SqlConnection connection = new SqlConnection(GetConnectionString()))
{
using (SqlCommand command = new SqlCommand("Treaters_Insert", connection))
{
command.CommandType = CommandType.StoredProcedure;
connection.Open();
command.Parameters.AddWithValue("@Name", treater.Name);
command.Parameters.AddWithValue("@FavoriteCandyID", treater.FavoriteCandyID);
command.Parameters.AddWithValue("@CostumeID", treater.CostumeID);
command.ExecuteNonQuery();
}
}
}
public void Insert(Treater treat)
{
using (SqlConnection connection = new SqlConnection("Server=(localdb)\\MSSQLLocalDB;Database=master;"))
{
using (SqlCommand command = new SqlCommand("Treaters_Insert", connection))
{
command.CommandType = CommandType.StoredProcedure;
connection.Open();
command.Parameters.AddWithValue("@Name", treat.Name);
command.Parameters.AddWithValue("@Candy", treat.FavCand);
command.Parameters.AddWithValue("@Costume", treat.Cost);
command.ExecuteNonQuery();
}
}
}
public static Treater GetTreaterObject(this TreaterModel model)
{
Treater treater = new Treater();
treater.id = model.TreaterID;
treater.name = model.TreaterName;
treater.favoriteCandy = new Candy();
treater.favoriteCandy.id = model.CandyID;
treater.favoriteCandy.productName = model.CandyName;
treater.costume = new Costume();
treater.costume.id = model.CostumeID;
treater.costume.costume = model.CostumeName;
return(treater);
}
public IActionResult Index(TreaterM model)
{
if (!ModelState.IsValid)
{
model.CandyList = _CandyRepo.GetList();
model.CostumeList = _CostRepo.GetList();
model.TreaterList = _TreatRepo.GetList();
return(View(model));
}
Treater tre = new Treater();
tre.Name = model.Name;
tre.Cost = model.CostumeID;
tre.FavCand = model.CandyID;
_TreatRepo.Insert(tre);
return(RedirectToAction("Index"));
}
public IActionResult Index(TreaterModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
Treater treater = new Treater
{
Name = model.Name,
FavoriteCandyID = model.FavoriteCandyID,
CostumeID = model.CostumeID
};
_treaterRepo.Insert(treater);
return(RedirectToAction("Index"));
}
public void Insert(Treater treater)
{
List <Treater> list = GetList();
if (list.Count() != 0)
{
treater.ID = list.Max(C => C.ID) + 1;
}
else
{
treater.ID = 1;
}
list.Add(treater);
using (StreamWriter sw = new StreamWriter(System.IO.Path.Combine(AppDomain.CurrentDomain.GetData("DataDirectory").ToString(), "Treaters.json")))
{
string filedata = JsonConvert.SerializeObject(list);
sw.Write(filedata);
}
}
