public ActionResult Create([Bind(Include = "PersonId,FirstName,LastName,Sex,Year,EditDate,EditedBy,Profile")] Person person)
{
if (ModelState.IsValid)
{
db.People.Add(person);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EditedBy = new SelectList(db.Users, "UserId", "Login", person.EditedBy);
return(View(person));
}
public ActionResult Create([Bind(Include = "PlayId,Title,Author,FestivalId,Day,Order,PlayedBy,Motto")] PlayDataDTO updateData)
{
if (ModelState.IsValid)
{
var updateDataFull = new Play()
{
//PlayId = updateData.PlayId,
Title = updateData.Title,
Author = updateData.Author,
FestivalId = updateData.FestivalId,
Day = updateData.Day,
Order = updateData.Order,
PlayedBy = updateData.PlayedBy,
Motto = updateData.Motto,
EditedBy = 1,
//EditedBy = GetUserId(), //???????
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
context.Plays.Add(updateDataFull);
string return_s = "Details/" + updateDataFull.FestivalId;
context.SaveChanges();
return(RedirectToAction(return_s, "Festival")); //TODO: Correct for many and for old id
}
}
//ViewBag.EditedBy = new SelectList(db.Users, "UserId", "Login", updateData.EditedBy);
return(View(updateData));
}
public SingleItemResponse <AwardDataDTO> UpdateAward(AwardDataDTO updateData)
{
var updateDataFull = new Award()
{
AwardId = updateData.AwardId,
CategoryId = updateData.CategoryId,
PlayId = updateData.PlayId,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
Award awa = context.Awards.First(a => a.AwardId == updateData.AwardId);
context.Entry(awa).CurrentValues.SetValues(updateDataFull);
context.SaveChanges();
int id = updateData.AwardId;
return(GetAward(id));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse <PositionDTO> UpdatePosition(PositionDTO updateData)
{
var updateDataFull = new Position()
{
PositionId = updateData.PositionId,
PositionTitle = updateData.PositionTitle,
Section = updateData.Section,
Order = updateData.Order,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
Position pos = context.Positions.First(p => p.PositionId == updateData.PositionId);
context.Entry(pos).CurrentValues.SetValues(updateDataFull);
context.SaveChanges();
int id = updateData.PositionId;
return(GetPosition(id));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse <PositionDTO> AddPosition(PositionDTO newPosition)
{
var newPositionFull = new Position()
{
PositionTitle = newPosition.PositionTitle,
Section = newPosition.Section,
Order = newPosition.Order,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
context.Positions.Add(newPositionFull);
context.SaveChanges();
int id = newPositionFull.PositionId;
return(GetPosition(id));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse <CategoryDTO> UpdateCategory(CategoryDTO updateData)
{
var updateDataFull = new Category
{
CategoryId = updateData.CategoryId,
Title = updateData.Title,
EditDate = DateTime.Now,
EditedBy = GetUserId(),
Group = updateData.Group,
Order = updateData.Order
};
using (var context = new AF_Context())
{
try
{
Category cat = context.Categories.First(c => c.CategoryId == updateData.CategoryId);
context.Entry(cat).CurrentValues.SetValues(updateDataFull);
context.SaveChanges();
int id = updateData.CategoryId;
return(GetCategory(id));
}
catch (Exception ex)
{
throw;
}
}
}
/* Award AddAward(int playId, int festivalId, int categoryId, int userId);
*
* List<AwardMixedDTO> SearchAwards(AwardsSearchingCriteria criteria, int pageNr, int pageAmount)
*
* public ListResponse<ModuleDto> GetModules(SingleRequest request)
* {
* //Warning: unbound list read from db, do not do this at home!
* return ListResponse.Create(request,
* InTransaction(tc => tc.Entities.ModuleInstances.Include(mi => mi.ModuleDef).ToList()
* .Select(_moduleAssembler.ToSimpleDto).ToList()));
* }
*/
//public string GetData(int value)
//{
// return string.Format("You entered: {0}", value);
//}
//public CompositeType GetDataUsingDataContract(CompositeType composite)
//{
// if (composite == null)
// {
// throw new ArgumentNullException("composite");
// }
// if (composite.BoolValue)
// {
// composite.StringValue += "Suffix";
// }
// return composite;
//}
#region Awards
public SingleItemResponse <AwardDataDTO> AddAward(AwardDataDTO newAward)
{
var newAwardFull = new Award()
{
CategoryId = newAward.CategoryId,
PlayId = newAward.PlayId,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
context.Awards.Add(newAwardFull);
context.SaveChanges();
int id = newAwardFull.AwardId;
return(GetAward(id));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse <PlayDataDTO> AddPlay(PlayDataDTO newPlay)
{
var newPlayFull = new Play()
{
Title = newPlay.Title,
Author = newPlay.Author,
FestivalId = newPlay.FestivalId,
Day = newPlay.Day,
Order = newPlay.Order,
PlayedBy = newPlay.PlayedBy,
Motto = newPlay.Motto,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
context.Plays.Add(newPlayFull);
context.SaveChanges();
int id = newPlayFull.PlayId;
return(GetPlay(id));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse <JobDTO> UpdateJob(JobDTO updateData)
{
var updateDataFull = new Job()
{
JobId = updateData.JobId,
JobTitle = updateData.JobTitle,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
Job jo = context.Jobs.First(j => j.JobId == updateData.JobId);
context.Entry(jo).CurrentValues.SetValues(updateDataFull);
context.SaveChanges();
int id = updateData.JobId;
return(GetJob(id));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse <FestivalDTO> UpdateFestival(FestivalDTO updateData)
{
var updateDataFull = new Festival()
{
FestivalId = updateData.FestivalId,
Year = updateData.Year,
BeginningDate = updateData.BeginningDate,
EndDate = updateData.EndDate,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
Festival fes = context.Festivals.First(f => f.FestivalId == updateData.FestivalId);
context.Entry(fes).CurrentValues.SetValues(updateDataFull);
context.SaveChanges();
int id = updateData.FestivalId;
return(GetFestival(id));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse <FestivalDTO> AddFestival(FestivalDTO newFestival)
{
var newFestivalFull = new Festival()
{
Year = newFestival.Year,
BeginningDate = newFestival.BeginningDate,
EndDate = newFestival.EndDate,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
context.Festivals.Add(newFestivalFull);
context.SaveChanges();
int id = newFestivalFull.FestivalId;
return(GetFestival(id));
}
catch (Exception ex)
{
throw;
}
}
}
public ActionResult Edit([Bind(Include = "PlayId,Title,Author,FestivalId,Day,Order,PlayedBy,Motto")] PlayDataDTO updateData)
{
if (ModelState.IsValid)
{
var updateDataFull = new Play()
{
PlayId = updateData.PlayId,
Title = updateData.Title,
Author = updateData.Author,
FestivalId = updateData.FestivalId,
Day = updateData.Day,
Order = updateData.Order,
PlayedBy = updateData.PlayedBy,
Motto = updateData.Motto,
EditedBy = 1,
//EditedBy = GetUserId(), //???????
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
Play pla = context.Plays.Find(updateData.PlayId); // First(p => p.PlayId == updateData.PlayId);
string return_s = "Details/" + pla.FestivalId;
context.Entry(pla).CurrentValues.SetValues(updateDataFull); //check for substituding only edited
//context.Entry(updateDataFull).State = EntityState.Modified;
context.SaveChanges();
//int id = updateData.PlayId;
//return Redirect(Request.UrlReferrer.ToString()); //RedirectToAction("Index")
//return RedirectToAction(return_s);
return(RedirectToAction(return_s, "Festival"));
}
}
//ViewBag.EditedBy = new SelectList(db.Users, "UserId", "Login", festival.EditedBy);
return(View(updateData));
}
public SingleItemResponse <PlayDataDTO> UpdatePlay(PlayDataDTO updateData)
{
var updateDataFull = new Play()
{
PlayId = updateData.PlayId,
Title = updateData.Title,
Author = updateData.Author,
FestivalId = updateData.FestivalId,
Day = updateData.Day,
Order = updateData.Order,
PlayedBy = updateData.PlayedBy,
Motto = updateData.Motto,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
Play pla = context.Plays.First(p => p.PlayId == updateData.PlayId);
context.Entry(pla).CurrentValues.SetValues(updateDataFull);
context.SaveChanges();
int id = updateData.PlayId;
return(GetPlay(id));
}
catch (Exception ex)
{
throw;
}
}
}
public ActionResult Edit([Bind(Include = "FestivalId,Year,BeginningDate,EndDate")] FestivalDTO updateData)
{
if (ModelState.IsValid)
{
var updateDataFull = new Festival()
{
FestivalId = updateData.FestivalId,
Year = updateData.Year,
BeginningDate = updateData.BeginningDate,
EndDate = updateData.EndDate,
EditedBy = 1,//GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
Festival fes = context.Festivals.Find(updateData.FestivalId);
context.Entry(fes).CurrentValues.SetValues(updateDataFull);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
//ViewBag.EditedBy = new SelectList(db.Users, "UserId", "Login", play.EditedBy);
//ViewBag.FestivalId = new SelectList(db.Festivals, "FestivalId", "FestivalId", play.FestivalId);
return(View(updateData));
}
static void Main(string[] args)
{
string pass = "";
int id = 0;
ICryptoService cryptoService = new PBKDF2();
const string pepper = "50.L1`(f761OJdG6fc835M(5(+Ju2!P6,4330_N*/%xz<j7(N15KC'8l997'0c0CEg";
Console.WriteLine("Select user by id:");
if (int.TryParse(Console.ReadLine(), out id))
{
using (var context = new AF_Context())
{
try
{
User user = context.Users.First(u => u.UserId == id);
if (user != null)
{
while (string.IsNullOrEmpty(pass))
{
Console.WriteLine("Input Password:");
pass = Console.ReadLine();
}
user.Salt = cryptoService.GenerateSalt();
user.Password = cryptoService.Compute(cryptoService.Compute(pass, user.Salt), pepper);
}
context.SaveChanges();
}
catch (Exception e)
{
throw;
}
}
}
}
public SingleItemResponse <CategoryDTO> AddCategory(CategoryDTO newCategory)
{
var newCategoryFull = new Category
{
Title = newCategory.Title,
EditDate = DateTime.Now,
EditedBy = GetUserId(),
Group = newCategory.Group,
Order = newCategory.Order
};
using (var context = new AF_Context())
{
try
{
context.Categories.Add(newCategoryFull);
context.SaveChanges();
int id = newCategoryFull.CategoryId;
return(GetCategory(id));
}
catch (Exception ex)
{
throw;
}
}
}
public SingleItemResponse <JobDTO> AddJob(JobDTO newJob)
{
var newJobFull = new Job()
{
JobTitle = newJob.JobTitle,
EditedBy = GetUserId(),
EditDate = DateTime.Now
};
using (var context = new AF_Context())
{
try
{
context.Jobs.Add(newJobFull);
context.SaveChanges();
int id = newJobFull.JobId;
return(GetJob(id));
}
catch (Exception ex)
{
throw;
}
}
}
