public ActionResult Index(CreatePromotionViewModel model)
{
foreach (var user in model.Users.Split(';'))
{
foreach (var project in model.Projects.Split(';'))
{
var promotion = new CreatePromotionModel
{
Type = 1,
User = user,
Project = Convert.ToInt32(project),
Top = model.Top,
Premium = model.Premium,
StartDate = model.StartDate,
EndDate = model.EndDate,
Note = model.Note,
UserCreated = model.LastUserUpdated,
LastUserUpdated = model.LastUserUpdated
};
_promotionService.InsertPromotion(promotion);
}
}
return !ModelState.IsValid ? Json(-100) : Json(1);
}
public int InsertPromotion(CreatePromotionModel model)
{
using (var sql = GetSqlConnection())
{
var data = sql.Query<int>("InsertPromotion", model, commandType: CommandType.StoredProcedure);
sql.Close();
return data.FirstOrDefault();
}
}
