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));
}
