public HttpResponseMessage getAccessibleWebsites(postmethod pm)
{
getAccessibleWebsites gaw = new getAccessibleWebsites();
List <weblist> wl = new List <weblist>();
try
{
string qry = "select * from MDM_DeviceMaster where DeviceID='" + pm.uuid + "'";
dr = databaseHelper.getDataReader(qry);
if (dr.Read())
{
string UserId = dr["UserId"].ToString().ToUpper();
if (!dr.IsClosed)
{
dr.Close();
}
string Designation = null;
qry = "select UserType from AppUsers where UserName='******'";
dr = databaseHelper.getDataReader(qry);
if (dr.Read())
{
Designation = dr["UserType"].ToString().ToUpper();
}
if (!dr.IsClosed)
{
dr.Close();
}
qry = "Select WebsiteName,UserId,UserDesignation from MDM_AccessibleWebsite";
dtable = databaseHelper.getDataTable(qry);
List <weblist> website = new List <weblist>();
foreach (DataRow drow in dtable.Rows)
{
//linfo.LogFile(enLogType.QUERY, "drow[UserId] = " + drow["UserId"] + " drow[UserDesignation] = "+drow["UserDesignation"]+" UserId = "+UserId+". UserDesignation = "+Designation+"","rizwan");
if (drow["UserId"] == DBNull.Value && drow["UserDesignation"] == DBNull.Value) // Default Application
{
website.Add(new weblist
{
WebsiteName = (drow["WebsiteName"] == DBNull.Value) ? "" : drow["WebsiteName"].ToString()
});
//linfo.LogFile(enLogType.INFO, "UserID,UserDesignation are null. WebsiteName = " + drow["WebsiteName"] + "", "rizwan");
}
else if (drow["UserId"] != DBNull.Value && drow["UserDesignation"] != DBNull.Value && drow["UserId"].ToString().Length > 0 && drow["UserDesignation"].ToString().Length > 0 && drow["UserID"].ToString().Split(',').Contains(UserId) && drow["UserDesignation"].ToString().Split(',').Contains(UserId))// Application Valid only to specific user.
{
website.Add(new weblist
{
WebsiteName = (drow["WebsiteName"] == DBNull.Value) ? "" : drow["WebsiteName"].ToString()
});
//linfo.LogFile(enLogType.INFO, "UserId and UserDesignation are not null . drow[UserId] = " + drow["UserId"] + " drow[UserDesignation] = " + drow["UserDesignation"] + " UserId = " + UserId + ". UserDesignation = " + Designation + "", "rizwan");
}
else if (drow["UserId"] != DBNull.Value && drow["UserDesignation"] == DBNull.Value && drow["UserId"].ToString().Length > 0 && drow["UserId"].ToString().Split(',').Contains(UserId)) // Accessible to specific user.
{
website.Add(new weblist
{
WebsiteName = (drow["WebsiteName"] == DBNull.Value) ? "" : drow["WebsiteName"].ToString()
});
// linfo.LogFile(enLogType.INFO, "Userid is not null. drow[UserId] = "+drow["UserId"]+" and Userid="+UserId+". drow[UserDesignation] = "+drow["UserDesignation"]+" and Designation = "+Designation+" WebsiteName = " + drow["WebsiteName"] + "", "rizwan");
}
else if (drow["UserDesignation"] != DBNull.Value && drow["UserId"] == DBNull.Value && drow["UserDesignation"].ToString().Length > 0 && drow["UserDesignation"].ToString().Contains(Designation))//accessible to user of specific designation
{
website.Add(new weblist
{
WebsiteName = (drow["WebsiteName"] == DBNull.Value) ? "" : drow["WebsiteName"].ToString()
});
//linfo.LogFile(enLogType.INFO, "UserDesignation is not null. drow[UserId] = " + drow["UserId"] + " and Userid=" + UserId + ". drow[UserDesignation] = " + drow["UserDesignation"] + " and Designation = " + Designation + " WebsiteName = " + drow["WebsiteName"] + "", "rizwan");
}
}
gaw.websiteurl = website;
gaw.response = true;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, gaw);
qry = "delete from MDM_PushNotification where DeviceID='" + pm.uuid + "' and Command='Get Accessible Website'";
rcnt = databaseHelper.ExecuteQuery(qry);
return(response);
}
else
{
ar = new WebApiResponse();
ar.errorCode = "Authentication failed";
ar.response = false;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.BadRequest, ar);
return(response);
}
}
catch (Exception ex)
{
linfo.LogFile(enLogType.EXCEPTION, "Problem in getAccessibleWebsites function." + ex.Message + "", null);
}
finally
{
if (dr != null && !dr.IsClosed)
{
dr.Close();
}
}
return(null);
}
public HttpResponseMessage getAccessibleWebsites(postmethod pm)
{
getAccessibleWebsites gaw = new getAccessibleWebsites();
List<weblist> wl = new List<weblist>();
try
{
string qry = "select * from MDM_DeviceMaster where DeviceID='" + pm.uuid + "'";
dr = databaseHelper.getDataReader(qry);
if (dr.Read())
{
string UserId = dr["UserId"].ToString().ToUpper();
if (!dr.IsClosed)
dr.Close();
string Designation = null;
qry = "select UserType from AppUsers where UserName='******'";
dr = databaseHelper.getDataReader(qry);
if (dr.Read())
{
Designation = dr["UserType"].ToString().ToUpper();
}
if (!dr.IsClosed)
dr.Close();
qry = "Select WebsiteName,UserId,UserDesignation from MDM_AccessibleWebsite";
dtable = databaseHelper.getDataTable(qry);
List<weblist> website = new List<weblist>();
foreach (DataRow drow in dtable.Rows)
{
//linfo.LogFile(enLogType.QUERY, "drow[UserId] = " + drow["UserId"] + " drow[UserDesignation] = "+drow["UserDesignation"]+" UserId = "+UserId+". UserDesignation = "+Designation+"","rizwan");
if (drow["UserId"] == DBNull.Value && drow["UserDesignation"] == DBNull.Value) // Default Application
{
website.Add(new weblist
{
WebsiteName = (drow["WebsiteName"] == DBNull.Value) ? "" : drow["WebsiteName"].ToString()
});
//linfo.LogFile(enLogType.INFO, "UserID,UserDesignation are null. WebsiteName = " + drow["WebsiteName"] + "", "rizwan");
}
else if (drow["UserId"] != DBNull.Value && drow["UserDesignation"] != DBNull.Value && drow["UserId"].ToString().Length > 0 && drow["UserDesignation"].ToString().Length > 0 && drow["UserID"].ToString().Split(',').Contains(UserId) && drow["UserDesignation"].ToString().Split(',').Contains(UserId))// Application Valid only to specific user.
{
website.Add(new weblist
{
WebsiteName = (drow["WebsiteName"] == DBNull.Value) ? "" : drow["WebsiteName"].ToString()
});
//linfo.LogFile(enLogType.INFO, "UserId and UserDesignation are not null . drow[UserId] = " + drow["UserId"] + " drow[UserDesignation] = " + drow["UserDesignation"] + " UserId = " + UserId + ". UserDesignation = " + Designation + "", "rizwan");
}
else if (drow["UserId"] != DBNull.Value && drow["UserDesignation"] == DBNull.Value && drow["UserId"].ToString().Length > 0 && drow["UserId"].ToString().Split(',').Contains(UserId)) // Accessible to specific user.
{
website.Add(new weblist
{
WebsiteName = (drow["WebsiteName"] == DBNull.Value) ? "" : drow["WebsiteName"].ToString()
});
// linfo.LogFile(enLogType.INFO, "Userid is not null. drow[UserId] = "+drow["UserId"]+" and Userid="+UserId+". drow[UserDesignation] = "+drow["UserDesignation"]+" and Designation = "+Designation+" WebsiteName = " + drow["WebsiteName"] + "", "rizwan");
}
else if (drow["UserDesignation"] != DBNull.Value && drow["UserId"] == DBNull.Value && drow["UserDesignation"].ToString().Length > 0 && drow["UserDesignation"].ToString().Contains(Designation))//accessible to user of specific designation
{
website.Add(new weblist
{
WebsiteName = (drow["WebsiteName"] == DBNull.Value) ? "" : drow["WebsiteName"].ToString()
});
//linfo.LogFile(enLogType.INFO, "UserDesignation is not null. drow[UserId] = " + drow["UserId"] + " and Userid=" + UserId + ". drow[UserDesignation] = " + drow["UserDesignation"] + " and Designation = " + Designation + " WebsiteName = " + drow["WebsiteName"] + "", "rizwan");
}
}
gaw.websiteurl = website;
gaw.response = true;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, gaw);
qry = "delete from MDM_PushNotification where DeviceID='" + pm.uuid + "' and Command='Get Accessible Website'";
rcnt = databaseHelper.ExecuteQuery(qry);
return response;
}
else
{
ar = new WebApiResponse();
ar.errorCode = "Authentication failed";
ar.response = false;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.BadRequest, ar);
return response;
}
}
catch(Exception ex)
{
linfo.LogFile(enLogType.EXCEPTION, "Problem in getAccessibleWebsites function."+ex.Message+"",null);
}
finally
{
if (dr != null && !dr.IsClosed)
dr.Close();
}
return null;
}