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