public JsonResult getColumnDetails(int UserId, string SystemChapterName)
{
var result = new Teckraft.Data.ListQueryResult <UserWiseColumnName>();
var list = new List <UserWiseColumnName>();
using (Teckraft.Data.Sql.InitiativeHubFinalEntities dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities())
{
var chap = dbcontext.ChapterMasters.FirstOrDefault(it => it.ChapterNameFromSystem == SystemChapterName);
if (chap != null)
{
var lq = dbcontext.UserWiseColumnNames.FirstOrDefault(it => it.ChapterId == chap.Id && it.UserId == UserId);
if (lq != null)
{
// lq.ChapterId = chap.Id;
list.Add(mapper.Map(lq));
}
}
// var lq = dbcontext.(SystemChapterName, RoleName, Email);
//foreach (var t in lq)
//{
// list.Add(new HodNames
// {
// SAPDivisionName = t.SAPDivisionName,
// SAPDivisionCode = t.SAPDivisionCode,
// HodEmail = t.HodEmail,
// });
//}
}
result.Items = list;
// return Json(result, JsonRequestBehavior.AllowGet);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ListQueryResult <webpages_Roles> Get(string q)
{
ListQuery <webpages_Roles> query = new ListQuery <webpages_Roles>();
if (!string.IsNullOrEmpty(q))
{
JavaScriptSerializer js = new JavaScriptSerializer();
query = js.Deserialize <ListQuery <webpages_Roles> >(q);
}
var list = new List <webpages_Roles>();
using (Teckraft.Data.Sql.InitiativeHubFinalEntities dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities())
{
if (query.Parameters != null)
{
if (query.Parameters.Count > 0)
{
foreach (var item in query.Parameters)
{
if (item.Name == "ExistingRole")
{
var role = item.Value;
var dbquery = dbcontext.webpages_Roles.Where(it => it.RoleId > 0 && it.RoleName != role);
foreach (var dbitem in dbquery.ToList())
{
list.Add(mapper.Map(dbitem));
}
}
else
{
var dbquery = dbcontext.webpages_Roles.Where(it => it.RoleId > 0);
foreach (var dbitem in dbquery.ToList())
{
list.Add(mapper.Map(dbitem));
}
}
}
}
}
}
return(new ListQueryResult <webpages_Roles>()
{
Items = list
});
}
public ListQueryResult <StatusMaster> Get(string q)
{
var result = new ListQueryResult <Teckraft.Core.Domian.Settings.StatusMaster>();
using (Teckraft.Data.Sql.InitiativeHubFinalEntities dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities())
{
var dbquery = dbcontext.StatusMasters.Where(it => it.Id > 0);
foreach (var item in dbquery.OrderByDescending(it => it.StatusDesc))
{
if (result.Items == null)
{
result.Items = new List <Teckraft.Core.Domian.Settings.StatusMaster>();
}
result.Items.Add(_StatusMapper.Map(item));
}
}
return(result);
}
