public object GetPassageById(long id)
{
using (var entities = new iBlogEntities())
{
var rs = entities.passage.SqlQuery("SELECT * FROM Passage WHERE passage_id = " + id);
var isNUllCount = rs.ToList().Count;
if (isNUllCount == 0)
{
return("No Such Passage");
}
try
{
return(rs.ToArray()[0]);
}
catch (Exception e)
{
return("Input Format Error");
}
}
}
public object Register([FromBody] Register register)
{
using (var entities = new iBlogEntities())
{
SqlConnection conn = new SqlConnection("data source=47.101.173.71;initial catalog=iBlog;persist security info=True;user id=sa;password=Password123;MultipleActiveResultSets=True");
conn.Open();
SqlCommand sql = new SqlCommand("INSERT INTO [user] (user_name) VALUES('" + register.userName + "')", conn);
sql.ExecuteNonQuery();
sql = new SqlCommand("SELECT * FROM [user] where user_name = '" + register.userName + "'", conn);
SqlDataReader idReader = sql.ExecuteReader();
while (idReader.Read())
{
long id = (long)idReader["user_id"];
sql = new SqlCommand("INSERT INTO [user_login] VALUES(" + id + ", '" + register.password + "')", conn);
sql.ExecuteNonQuery();
}
conn.Close();
return("Success");
}
}
public HttpResponseMessage GetDocFile(long id)
{
var rs = new HttpResponseMessage(HttpStatusCode.OK);
using (var entities = new iBlogEntities())
{
entities.passage.SqlQuery("SELECT title FROM Passage WHERE passage_id = " + id);
string title = entities.passage.ToArray()[0].title;
string fileName = title + ".md";
var filePath = HttpContext.Current.Server.MapPath($"~/App_Data/{fileName}");
var fileBytes = File.ReadAllBytes(filePath);
var fileMemStream = new MemoryStream(fileBytes);
rs.Content = new StreamContent(fileMemStream);
var headers = rs.Content.Headers;
headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
headers.ContentDisposition.FileName = fileName;
headers.ContentLength = fileMemStream.Length;
}
return(rs);
}
