public IHttpActionResult GetUserPermission([FromBody] GetPermission user)
{
try
{
var response = checkRequst();
if (response.result)
{
SqlConnection con = new SqlConnection(helper.Strcon);
con.Open();
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand("sp_GetUserPermission", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Username", user.Username);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
#region
var Status = dt;
#endregion
return(Json <DataTable>(Status));
}
else if (response.res == "400")
{
return(Json <string>(Convert.ToString(Request.CreateResponse(HttpStatusCode.BadRequest))));
}
else //401
{
return(Json <string>(Convert.ToString(Request.CreateResponse(HttpStatusCode.Unauthorized))));
}
}
catch (Exception ex)
{
DataTable dtNew = new DataTable();
dtNew.Columns.Add("Result", typeof(string));
dtNew.Rows.Add("Error : " + ex.ToString());
return(Json <DataTable>(dtNew));
}
}
private void Awake()
{
getPermission = GetComponent <GetPermission>();
}
