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)); }