public HttpResponseMessage GetProjectLookUp(object Json)
{
try {
PM_ProjectBL pd = new PM_ProjectBL();
PM_ProjectLookup rec = new PM_ProjectLookup();
ProjectApiObject obj = JsonConvert.DeserializeObject <ProjectApiObject>(Json.ToString());
if (obj.toDate != null && obj.fromDate != null)
{
rec = pd.GetLookup("LookupByFilters", "True", obj.userId, obj.statusIds, obj.priorityIds, obj.clientIds, obj.toDate, obj.fromDate);
}
else if (obj.searchKey != null && obj.searchKey != "")
{
rec = pd.GetLookup("LookupByKey", obj.searchKey, obj.userId);
}
else
{
rec = pd.GetLookup("Lookup", "True", obj.userId);
}
if (rec != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, rec));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"No Data"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest,
ex.Message));
}
}
public PM_ProjectLookup GetLookup(string Filter, string @Value = null, Int64 _userId = 0, string StatusIds = null, string ProritysIds = null, string ClientsIds = null, DateTime?ToDate = null, DateTime?FromDate = null)
{
DataSet ds = pd.GetDataset(Filter, Value, _userId, StatusIds, ProritysIds, ClientsIds, ToDate, FromDate);
PM_ProjectLookup pl = new PM_ProjectLookup();
pl.Statuses = ds.Tables[0].ToList <AirView.DBLayer.Project.Model.Status>();
if (ds.Tables.Count > 1)
{
pl.Priorities = ds.Tables[1].ToList <Priority>();
}
if (ds.Tables.Count > 2)
{
pl.clients = ds.Tables[2].ToList <Client>();
}
return(pl);
}
