public static void AddCodeChannel(ActivityChannels c) { using (WeChatDbContext entity = new WeChatDbContext()) { var channel = (from item in entity.ActivityChannels where (item.ChannelName == c.ChannelName) && (item.ChannelUrl == c.ChannelUrl) select item).SingleOrDefault(); if (channel == null) { entity.ActivityChannels.Add(c); entity.SaveChanges(); } } }
public static void EditCodeChannel(ActivityChannels c) { using (WeChatDbContext entity = new WeChatDbContext()) { var channel = (from item in entity.ActivityChannels where item.ActivityChannelsId == c.ActivityChannelsId select item).SingleOrDefault(); if (channel != null) { entity.Entry(channel).State = System.Data.Entity.EntityState.Modified; channel.ChannelName = c.ChannelName; channel.ChannelUrl = c.ChannelUrl; channel.KeyWords = c.KeyWords; entity.SaveChanges(); } } }
public static string OperateCodeChannel(JObject channel) { try { if (channel != null) { ActivityChannels m = new ActivityChannels(); m.ChannelName = channel.SelectToken("channelname").ToString(); m.ChannelUrl = channel.SelectToken("channelurl").ToString(); m.KeyWords = channel.SelectToken("keywords").ToString(); if (Int32.Parse(channel.SelectToken("channelid").ToString()) == 0) { AddCodeChannel(m); } else { m.ActivityChannelsId = Int32.Parse(channel.SelectToken("channelid").ToString()); EditCodeChannel(m); } string returnresult = "success!"; return returnresult; } } catch { return "error"; } return "error"; }