public ActionResult Edit(int id, Man_Reward mr)
{
if (id == mr.Id)
{
db.Entry(mr).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index", new { id = mr.ManId }));
}
public ActionResult Edit(int id)
{
IEnumerable <Reward> rewards = db.Rewards;
ViewBag.Rewards = rewards;
Man_Reward EditMr = db.Man_Rewards.Find(id);
ViewBag.EditMr = EditMr;
return(View());
}
public ActionResult Delete(int id)
{
Man_Reward mr = db.Man_Rewards.Find(id);
if (mr != null)
{
db.Man_Rewards.Remove(mr);
db.SaveChanges();
}
return(RedirectToAction("Index", new { id = mr.ManId }));
}
public ActionResult SyncCSV()
{
List <Man_Reward> MRsDisplayStart = new List <Man_Reward>();
List <Man_Reward> MRsDisplayEnd = new List <Man_Reward>();
using (var streamReader = new StreamReader(@"D:\Projects\InteractiveSystem\interactiveSystem\Content\ManReward.csv"))
using (var reader = new CsvReader(streamReader))
{
reader.ReadHeaderRecord();
while (reader.HasMoreRecords)
{
var dataRecord = reader.ReadDataRecord();
string row = dataRecord.ToString();
string[] rows = row.Split(new char[] { ';' });
if ((rows[0] != "") && (rows[2] != ""))
{
Man_Reward MRDisplayStart = new Man_Reward();
MRDisplayStart.ManId = int.Parse(rows[0]);
MRDisplayStart.RewardId = int.Parse(rows[2]);
MRDisplayStart.Description = rows[8];
if (rows[5] != "")
{
MRDisplayStart.Date = Convert.ToDateTime(rows[5]);
}
MRsDisplayStart.Add(MRDisplayStart);
}
}
}
foreach (var e in MRsDisplayStart)
{
IEnumerable <Man> MenDisplayEnd = db.Men.Where(st => st.IdPersonal == e.ManId);
IEnumerable <Reward> RewardsDisplayEnd = db.Rewards.Where(st => st.IdRew == e.RewardId);
if ((MenDisplayEnd.Count() != 0) && (RewardsDisplayEnd.Count() != 0))
{
Man_Reward MRDisplayEnd = new Man_Reward();
MRDisplayEnd.ManId = MenDisplayEnd.First().Id;
MRDisplayEnd.RewardId = RewardsDisplayEnd.First().Id;
MRDisplayEnd.Description = e.Description;
MRDisplayEnd.Date = e.Date;
MRsDisplayEnd.Add(MRDisplayEnd);
db.Man_Rewards.Add(MRDisplayEnd);
db.SaveChanges();
}
}
ViewBag.List = MRsDisplayEnd;
return(View());
}
public ActionResult Add(Man_Reward mr)
{
db.Man_Rewards.Add(mr);
db.SaveChanges();
return(RedirectToAction("Index", new { id = mr.ManId }));
}