public ActionResult CreateNewLogbook(int?id)
{
if (ViewBag.Role != "Student")
{
return(RedirectToAction("LogbookSvView"));
}
if (id == null)
{
return(View());
}
Models.LogbookModel model = new Models.LogbookModel();
using (SqlConnection cn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SELECT * FROM [dbo].[Logbook_Table] " +
"WHERE Id = " + id, cn);
cn.Open();
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
model.Id = Int32.Parse(Convert.ToString(rd.GetSqlValue(0)));
model.AuthorUsername = Convert.ToString(rd.GetSqlValue(1));
model.Datetime = Convert.ToDateTime(Convert.ToString(rd.GetSqlValue(2)));
model.Title = Convert.ToString(rd.GetSqlValue(3));
model.Description = Convert.ToString(rd.GetSqlValue(4));
model.Week = Convert.ToInt32(Convert.ToString(rd.GetSqlValue(5)));
}
}
return(View(model));
}
public bool SaveLogbook(Models.LogbookModel model)
{
String _sql = "";
using (SqlConnection cn = new SqlConnection(connectionString))
{
model.AuthorUsername = ViewBag.Username;
int?id = model.Id;
if (id == 0)
{
_sql = "INSERT INTO [dbo].[Logbook_Table] VALUES ('"
+ model.AuthorUsername + "', '" + model.Datetime + "', '"
+ model.Title + "', '" + model.Description + "', " + model.Week
+ ")";
}
else
{
_sql = "UPDATE [dbo].[Logbook_Table] "
+ "SET Datetime = '" + model.Datetime
+ "', Title = '" + model.Title + "', Description = '"
+ model.Description + "', Week = " + model.Week + " WHERE Id = "
+ Convert.ToString(model.Id);
}
SqlCommand cmd = new SqlCommand(_sql, cn);
cn.Open();
cmd.ExecuteNonQuery();
}
return(true);
}
public ActionResult CreateNewLogbook(Models.LogbookModel model)
{
if (SaveLogbook(model))
{
return(RedirectToAction("LogbookStd"));
}
return(View(model));
}
public ActionResult ViewLogbookStd(int id)
{
Models.LogbookModel model = new Models.LogbookModel();
using (SqlConnection cn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SELECT * FROM [dbo].[Logbook_Table] " +
"WHERE Id = " + id, cn);
cn.Open();
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
model.Id = Int32.Parse(Convert.ToString(rd.GetSqlValue(0)));
model.AuthorUsername = Convert.ToString(rd.GetSqlValue(1));
model.Datetime = Convert.ToDateTime(Convert.ToString(rd.GetSqlValue(2)));
model.Title = Convert.ToString(rd.GetSqlValue(3));
model.Description = Convert.ToString(rd.GetSqlValue(4));
model.Week = Convert.ToInt32(Convert.ToString(rd.GetSqlValue(5)));
}
}
return(View(model));
}
