public static void Channel_Update(Channel input) { SqlConnection connection = new SqlConnection(_ConnectionString); SqlCommand command = new SqlCommand("Channel_Update", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@ChannelId", input.ChannelId); command.Parameters.AddWithValue("@ChannelName", input.ChannelName); SqlUtility.ExecuteNonQuery(command); }
public ViewResult Edit(Channel channel) { if (ModelState.IsValid) { Provider.UpdateChannel(channel); return View("Index", Provider.GetChannels()); } else { return View(channel); } }
public ViewResult Create(Channel channel) { if (ModelState.IsValid) { Provider.CreateChannel(channel.ChannelName); return View("Index", Provider.GetChannels()); } else { return View(channel); } }
public void Channel_Tests() { Channel channel1 = new Channel(); channel1.ChannelName = "Channel 3"; Provider.CreateChannel(channel1.ChannelName); Channel channel2 = new Channel(); channel2.ChannelName = "Channel C"; Provider.CreateChannel(channel2.ChannelName); List<Channel> channels = Provider.GetChannels(); channel1 = GetChannel(channel1.ChannelName, channels); Assert.IsTrue(channels.Contains(channel1)); channel2 = GetChannel(channel2.ChannelName, channels); Assert.IsTrue(channels.Contains(channel2)); }
public static void UpdateChannel(Channel channel) { if (channel == null) { throw new Exception(string.Format(_InvalidMessage, "Channel")); } Data.Provider.Channel_Update(channel); }
public static List<Channel> GetChannels() { List<Channel> returnValue = new List<Channel>(); DataSet channelDataSet = Data.Provider.Channel_SelectAll(); foreach (DataRow row in channelDataSet.Tables[0].Rows) { Channel channel = new Channel(); channel.ChannelId = int.Parse(row["ChannelId"].ToString()); channel.ChannelName = row["ChannelName"].ToString(); returnValue.Add(channel); } return returnValue; }
public static Channel GetChannel(int channelId) { Channel returnValue = new Channel(); DataSet channelDataSet = Data.Provider.Channel_SelectById(channelId); returnValue.ChannelId = int.Parse(channelDataSet.Tables[0].Rows[0]["ChannelId"].ToString()); returnValue.ChannelName = channelDataSet.Tables[0].Rows[0]["ChannelName"].ToString(); return returnValue; }