private void GetData() { using (new WaitCursor()) { ClearRecord(); studentclass clsstudentclass = new studentclass(); clsstudentclass.ClassId = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text); clsstudentclass = studentclassData.Select_Record(clsstudentclass); if ((clsstudentclass != null)) { try { nudClassId.Text = System.Convert.ToInt32(clsstudentclass.ClassId).ToString(); if (clsstudentclass.ClassName is null) { tbClassName.Text = default(string); } else { tbClassName.Text = Convert.ToString(clsstudentclass.ClassName); } } catch { } } } }
private void UpdateRecord() { using (new WaitCursor()) { studentclass oclsstudentclass = new studentclass(); studentclass clsstudentclass = new studentclass(); oclsstudentclass.ClassId = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text); oclsstudentclass = studentclassData.Select_Record(oclsstudentclass); if (VerifyData() == true) { SetData(clsstudentclass); Boolean bSucess = new Boolean(); bSucess = studentclassData.Update(oclsstudentclass, clsstudentclass); if (bSucess == true) { GoBack_To_Grid(); } else { MessageBox.Show("Update failed.", "Error"); } } } }
public List <string> Get(int id, string userid) { // return new string[] { "value1", DateTime.Now.ToString() }; try { var found = (from stdcls in db.studentclasses where stdcls.classid == id && stdcls.studentid == userid select stdcls).ToList(); if (found.Count == 0) { studentclass sl = new studentclass(); sl.classid = id; sl.studentid = userid; sl.scandate = DateTime.Now; db.studentclasses.Add(sl); db.SaveChanges(); } } catch (Exception ex) { string message = ex.Message; } var result = (from cls in db.lectures join stdcls in db.studentclasses on cls.id equals stdcls.classid where stdcls.studentid == userid select cls.description).ToList(); return(result.ToList()); }
public ActionResult DeleteConfirmed(string id) { studentclass studentclass = db.studentclasses.Find(id); db.studentclasses.Remove(studentclass); db.SaveChanges(); return(RedirectToAction("Index")); }
public static bool Update(studentclass oldstudentclass, studentclass newstudentclass) { SqlConnection connection = SchoolData.GetConnection(); string updateStatement = "UPDATE " + " [studentclass] " + "SET " + " [ClassName] = @NewClassName " + "WHERE " + " [ClassId] = @OldClassId " + " AND ((@OldClassName IS NULL AND [ClassName] IS NULL) OR [ClassName] = @OldClassName) " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; if (newstudentclass.ClassName != null) { updateCommand.Parameters.AddWithValue("@NewClassName", newstudentclass.ClassName); } else { updateCommand.Parameters.AddWithValue("@NewClassName", DBNull.Value); } updateCommand.Parameters.AddWithValue("@OldClassId", oldstudentclass.ClassId); if (oldstudentclass.ClassName != null) { updateCommand.Parameters.AddWithValue("@OldClassName", oldstudentclass.ClassName); } else { updateCommand.Parameters.AddWithValue("@OldClassName", DBNull.Value); } try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public ActionResult Edit([Bind(Include = "stdclassID,studentID,classID,attendeddate")] studentclass studentclass) { if (ModelState.IsValid) { db.Entry(studentclass).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.classID = new SelectList(db.classschedules, "classID", "classlevel", studentclass.classID); ViewBag.studentID = new SelectList(db.students, "studentID", "studentID", studentclass.studentID); return(View(studentclass)); }
private void SetData(studentclass clsstudentclass) { using (new WaitCursor()) { if (string.IsNullOrEmpty(tbClassName.Text)) { clsstudentclass.ClassName = null; } else { clsstudentclass.ClassName = tbClassName.Text; } } }
// GET: studentclasses/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } studentclass studentclass = db.studentclasses.Find(id); if (studentclass == null) { return(HttpNotFound()); } return(View(studentclass)); }
// GET: studentclasses/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } studentclass studentclass = db.studentclasses.Find(id); if (studentclass == null) { return(HttpNotFound()); } ViewBag.classID = new SelectList(db.classschedules, "classID", "classlevel", studentclass.classID); ViewBag.studentID = new SelectList(db.students, "studentID", "studentID", studentclass.studentID); return(View(studentclass)); }
public static bool Add(studentclass clsstudentclass) { SqlConnection connection = SchoolData.GetConnection(); string insertStatement = "INSERT " + " [studentclass] " + " ( " + " [ClassName] " + " ) " + "VALUES " + " ( " + " @ClassName " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; if (clsstudentclass.ClassName != null) { insertCommand.Parameters.AddWithValue("@ClassName", clsstudentclass.ClassName); } else { insertCommand.Parameters.AddWithValue("@ClassName", DBNull.Value); } try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static bool Delete(studentclass clsstudentclass) { SqlConnection connection = SchoolData.GetConnection(); string deleteStatement = "DELETE FROM " + " [studentclass] " + "WHERE " + " [ClassId] = @OldClassId " + " AND ((@OldClassName IS NULL AND [ClassName] IS NULL) OR [ClassName] = @OldClassName) " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldClassId", clsstudentclass.ClassId); if (clsstudentclass.ClassName != null) { deleteCommand.Parameters.AddWithValue("@OldClassName", clsstudentclass.ClassName); } else { deleteCommand.Parameters.AddWithValue("@OldClassName", DBNull.Value); } try { connection.Open(); int count = deleteCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static studentclass Select_Record(studentclass clsstudentclassPara) { studentclass clsstudentclass = new studentclass(); SqlConnection connection = SchoolData.GetConnection(); string selectStatement = "SELECT " + " [ClassId] " + " ,[ClassName] " + "FROM " + " [studentclass] " + "WHERE " + " [ClassId] = @ClassId " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@ClassId", clsstudentclassPara.ClassId); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsstudentclass.ClassId = System.Convert.ToInt32(reader["ClassId"]); clsstudentclass.ClassName = reader["ClassName"] is DBNull ? null : reader["ClassName"].ToString(); } else { clsstudentclass = null; } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(clsstudentclass); }
private void InsertRecord() { using (new WaitCursor()) { studentclass clsstudentclass = new studentclass(); if (VerifyData() == true) { SetData(clsstudentclass); Boolean bSucess = new Boolean(); bSucess = studentclassData.Add(clsstudentclass); if (bSucess == true) { GoBack_To_Grid(); } else { MessageBox.Show("Insert failed.", "Error"); } } } }
private void DeleteRecord() { using (new WaitCursor()) { studentclass clsstudentclass = new studentclass(); clsstudentclass.ClassId = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text); if (MessageBox.Show("Are you sure? Delete this record?", "Delete", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { SetData(clsstudentclass); Boolean bSucess = new Boolean(); bSucess = studentclassData.Delete(clsstudentclass); if (bSucess == true) { GoBack_To_Grid(); } else { MessageBox.Show("Delete failed.", "Error"); } } } }