public JsonResult CopySlateData(string fromId, string toId, string Chname) { //var data = "select [Country_Code],[Country_Name] FROM [SlateMaster].[dbo].[Country] where Country_Name like ' % " + name + " % '"; var data = (from c in db.SlateDetailsTables where c.SlateID == fromId && c.ChannelName == Chname orderby c.Id descending select new { State = c.State, ClientID = c.ClientID }).ToList(); if (data.Count > 0) { foreach (var item in data) { SlateDetailsTable slatedetials = new SlateDetailsTable(); slatedetials.ClientID = item.ClientID; slatedetials.ChannelName = Chname; slatedetials.State = item.State; slatedetials.SlateID = toId; db.SlateDetailsTables.Add(slatedetials); db.SaveChanges(); } return(Json(data, JsonRequestBehavior.AllowGet)); } else { return(Json("NoData", JsonRequestBehavior.AllowGet)); } }
public JsonResult saveSlate(SlateDetailsTable slatedetials) { db.SlateDetailsTables.Add(slatedetials); db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); }