public string Create(Event objEvent, string token) { try { if (ModelState.IsValid) { objEvent.InsertedBy = _userStatistics.UserId; objEvent.InsertedOn = DateTime.Now; if (this.repository.CreateEvent(objEvent)) { List <ELetter> objEletterList = this.repository.GetUsersForEvent(objEvent.EventId); ELetter objEletter = null; foreach (var eLetter in objEletterList) { objEletter = new ELetter(); objEletter.UserId = eLetter.UserId; objEletter.EventId = eLetter.EventId; objEletter.TemplateId = eLetter.TemplateId; objEletter.OrganizationId = eLetter.OrganizationId; objEletter.InsertedBy = _userStatistics.UserId; this.repository.CreateEletter(objEletter); } SaveFiles(token, this.GetType().Name, objEvent.EventId); return(Convert.ToString(true)); } return(Convert.ToString(false)); } return(Convert.ToString(false)); } catch (Exception ex) { return(ex.Message.ToString()); } }
public bool CreateEletter(ELetter objEletter) { var parameters = new { UserId = objEletter.UserId, EventId = objEletter.EventId, TemplateId = objEletter.TemplateId, OrganizationId = objEletter.OrganizationId, IsRead = false, InsertedOn = DateTime.Now, InsertedBy = objEletter.InsertedBy }; using (IDbConnection connection = OpenConnection()) { const string storedProcedure = "usp_AddEletters"; int rowsAffected = connection.Execute(storedProcedure, parameters, commandType: CommandType.StoredProcedure); SetIdentity <int>(connection, id => objEletter.EletterId = id); if (rowsAffected > 0) { return(true); } return(false); } }
public ActionResult UserEletter(long eLetterId) { ELetter objEletter = repository.GetEletters(_userStatistics.UserId, eLetterId); string input = objEletter.TemplateText; var regex = new Regex("{.*?}"); var matches = regex.Matches(input); //your matches: name, [email protected] //List<FormattingField> formattingFieldList = repository.FormattingFields(objEletter.TemplateId); foreach (var match in matches) // e.g. you can loop through your matches like this { //yourmatch objEletter.TemplateText = objEletter.TemplateText.Replace(match.ToString(), User.Identity.Name); } return(View(objEletter)); }