public IHttpActionResult MerrLeksion(int Id, string username)
{
string connectionstring = WebConfigurationManager.ConnectionStrings["UniversityConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(connectionstring))
{
string query_procedure = "FiltroLeksion";
SqlCommand cmd = new SqlCommand(query_procedure, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Idleksioni", SqlDbType.Int);
cmd.Parameters["@Idleksioni"].Value = Id;
cmd.Parameters.AddWithValue("@User", username);
con.Open();
try
{
SqlDataReader reader = cmd.ExecuteReader();
Leksion Leksioni = new Leksion();//Krijom nje objekt leksion te cilin do ta perdorim per ruajtur te dhenat qe do merrren nga databaza
while (reader.Read())
{
Leksioni.ID = reader["IdLeksioni"].ToString();
Leksioni.Numer_Leksioni = reader["NumerLeksioni"].ToString();
Leksioni.Titulli = reader["Titulli"].ToString();
Leksioni.Permbajtja = reader["Permbajtja"].ToString();
Leksioni.Data = reader["Data"].ToString();
Leksioni.Status = reader["Statusi"].ToString();
Leksioni.SSN_P = reader["SsnP"].ToString();
Leksioni.IdKursi = reader["IdKursi"].ToString();
// Leksioni.Link_dokumenti = reader["Link_Dokumenti"].ToString();
Leksioni.Link_dokumenti = reader[8].ToString();
Leksioni.Emer_Kursi = reader["Emer_Kursi"].ToString();
Leksioni.Emer_Pedagogu = reader["Emer_Pedagogu"].ToString();
Leksioni.Mbiemer_Pedagogu = reader["Mbiemer_Pedagogu"].ToString();
}
return(this.Ok(Leksioni));
}//end try
catch (Exception ex)
{
return(Content(HttpStatusCode.BadRequest, ex));
}
}
}
protected void Afisho_Leskion(int id)
{
HttpWebRequest requestLeksion = (HttpWebRequest)WebRequest.Create("http://localhost:23243/api/Leksione/MerrLeksion?id=" + id.ToString() + "&username="******"UserID"].ToString());//
requestLeksion.Method = "Get";
requestLeksion.KeepAlive = true;
requestLeksion.ContentType = "appication/json";
requestLeksion.ContentLength = 0;//sepse nxjerr 411 length not specified
HttpWebResponse responseLeksion = (HttpWebResponse)requestLeksion.GetResponse();
string myResponseLeksion = "";
using (System.IO.StreamReader sr = new System.IO.StreamReader(responseLeksion.GetResponseStream()))
{
myResponseLeksion = sr.ReadToEnd();
}
// Response.Write(myResponse);
JavaScriptSerializer js = new JavaScriptSerializer();
Leksion leksioni = js.Deserialize <Leksion>(myResponseLeksion);
if (Convert.ToBoolean(leksioni.Status) == true)
{
string permbajtje = "";
permbajtje = "<div class=\"row\">";
permbajtje += "<div class=\"col-md-1\"></div>";
permbajtje += "<div class=\"col-md-10\">";
permbajtje += "<div class=\"white-box\">";
permbajtje += "<div class=\"row\">";
permbajtje += "<div class=\"col-md-4\"></div>";
permbajtje += "<div class=\"col-md-4 text-center\"><i><h4>" + leksioni.Emer_Kursi + "</h4></i></div>";
permbajtje += "</div>";
permbajtje += "<div class=\"row\">";
permbajtje += "<div class=\"col-md-2\"></div>";
permbajtje += "<div class=\"col-md-8 text-center\">";
permbajtje += "<h1 class=\"display-4\">" + leksioni.Titulli + "</h2></br>";
permbajtje += "<img width=\"30 px\" height=\"auto\" src=\"../Assets/img/profil.png\" class=\"circle\" /></br>";
permbajtje += "<span>Nga :<b>" + leksioni.Emer_Pedagogu + " " + leksioni.Mbiemer_Pedagogu + "</b> <span>";
permbajtje += "</div>";
permbajtje += "</div>";
permbajtje += "<div class=\"row\">";
permbajtje += "<div class=\"col-md-1\"></div>";
DateTime dt = Convert.ToDateTime(leksioni.Data);
permbajtje += "<div class=\"col-md-2\">Data :" + dt.ToShortDateString() + "</div>";
//permbajtje+="<div class=\"col-md-2\"></div>";
permbajtje += "<div class=\"col-md-6\"></div>";
permbajtje += "<div class=\"col-md-2 text-right\">Lekioni Nr: <b>" + leksioni.Numer_Leksioni + "</b></div>";
//permbajtje+="<div class=\"col-md-1\"><b>"+leksioni.Numer_Leksioni+"</b></div>";
permbajtje += "</div></br></br>";
permbajtje += "<div class=\"row\">";
permbajtje += "<div class=\"col-md-1\"></div>";
permbajtje += "<div class=\"col-md-10\">";
permbajtje += leksioni.Permbajtja;
permbajtje += "</div>";
permbajtje += "</div>";
permbajtje += "<div class=\"row\">";
permbajtje += "<div class=\"col-md-9\"></div>";
permbajtje += "<div class=\"col-md-3\">";
if (!String.IsNullOrEmpty(leksioni.Link_dokumenti.ToString()))
{
permbajtje += "<a class=\"btn btn-info\" href=\"" + leksioni.Link_dokumenti + "\">Kliko per Dokumentin</a>";
}
permbajtje += "</div>";
permbajtje += "</div >";
permbajtje += "</div> ";
permbajtje += "</div>";
permbajtje += "</div> ";
/*
* permbajtje ="<div class=\"row\">";
* permbajtje += "<div class=\"col-md-2\"></div>";
* permbajtje += "<div class=\"col-md-8\">";
* permbajtje += "<div class=\"white-box\" >";
* permbajtje ="<div class=\"row\">";
* permbajtje += "<div class=\"col-md-1\"></div>";
* permbajtje += "<div class=\"col-md-10\" text-center\">";
* permbajtje += "<i><h4>"+leksioni.Emer_Kursi+"</h4></i>";
* permbajtje += "<h3 class=\"text-center\">";
* permbajtje += leksioni.Titulli;
* permbajtje += "<br />";
* permbajtje += "<small class=\"text-muted\">" + leksioni.Emer_Pedagogu + " " + leksioni.Mbiemer_Pedagogu + "</small>";
* permbajtje += "</h3>";
* permbajtje += "<img width=\"30 px\" height=\"auto\" src=\"../Assets/img/profil.png\" class=\"circle\" />";
* //permbajtje += "Data"+leksioni.Data.ToString();
* permbajtje += "</div><!-- row -->";
* permbajtje += "<div class=\"row\">";
* permbajtje += "<p>" + leksioni.Permbajtja + "</p>";
* permbajtje += "</div>";
* permbajtje += " </div></a>";
* permbajtje += "</div>";
* permbajtje += "</div><!--row1-->";*/
Permbajtje.InnerHtml = permbajtje;
}
responseLeksion.Close();
}
