public void Save(Sequence sequence) { int retVal; DataCommandService dataCommandDB = DataCommandService.GetInstance(); List <ScreenDataCommandParameter> parameters = new List <ScreenDataCommandParameter>(); ScreenDataCommandParameter p = null; p = new ScreenDataCommandParameter(); p.Name = "@SequenceName"; p.Value = sequence.Name; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@SequencePrefix"; p.Value = sequence.Prefix; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@SeedValue"; p.Value = sequence.SeedValue; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@Increment"; p.Value = sequence.Increment; parameters.Add(p); dataCommandDB.ExecuteDataCommand(Configuration.GetInstance().App.SaveSequenceDataCommand, parameters); }
public string InsertMessage( DateMode DateMode, string PhoneNo, string MessageText, string Template, string EntityType, string EntityID, string UserName, string Password, string ChannelID, string CreatedBy) { string MessageID = Guid.NewGuid().ToString(); DataCommandService dataCommandDB = DataCommandService.GetInstance();; List <ScreenDataCommandParameter> parameters = new List <ScreenDataCommandParameter>(); ScreenDataCommandParameter p = null; p = new ScreenDataCommandParameter(); p.Name = "@MessageID"; p.Value = MessageID; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@PhoneNo"; p.Value = PhoneNo; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@MessageText"; p.Value = MessageText; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@Template"; p.Value = Template; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@EntityType"; p.Value = EntityType; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@EntityID"; p.Value = EntityID; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@UserName"; p.Value = UserName; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@Password"; p.Value = Password; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@ChannelID"; p.Value = ChannelID; parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@CreatedOn"; switch (DateMode) { case DateMode.LocalDate: p.Value = DateTime.Now; break; case DateMode.UniversalDate: p.Value = DateTime.UtcNow; break; } parameters.Add(p); p = new ScreenDataCommandParameter(); p.Name = "@CreatedBy"; p.Value = CreatedBy; parameters.Add(p); dataCommandDB.ExecuteDataCommand(Configuration.GetInstance().App.SaveSequenceDataCommand, parameters); return(MessageID); }