public MessagingModel GetData() { DataParam[] dataParams = { }; DataHelperReturn dataHelper = _DbHelper.GetDataSet("GetData", dataParams); MessagingModel model = new MessagingModel(); foreach (DataRow row in dataHelper.ReturnDataSet.Tables[0].Rows) { //model.Id = Convert.ToInt32(row["Id"]); model.Name = row["Name"].ToString(); model.Message = row["Message"].ToString(); //model.Type = row["Type"].ToString(); //model.ReplyOptions = row["ReplyOptions"].ToString(); //model.ReplyEndpoint = row["ReplyEndpoint"].ToString(); } return(model); }
internal void SaveData(string value) { Dictionary <string, string> values = JsonConvert.DeserializeObject <Dictionary <string, string> >(value); MessagingModel message = new MessagingModel { Name = values["Name"].ToString(), Message = values["Message"].ToString() //Type = values["Type"].ToString(), //ReplyOptions = values["ReplyOptions"].ToString(), //ReplyEndpoint = values["ReplyEndpoint"].ToString() }; DataParam[] dataParams = { new DataParam("@Name", message.Name), new DataParam("@Message", message.Message) //, //new DataParam("@Type", message.Message), //new DataParam("@ReplyOptions", message.Message), //new DataParam("@ReplyEndpoint", message.Message) }; _DbHelper.ExecuteNonQuery("SaveData", dataParams); }