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(); } }