public ActionResult Create(ClassModel iList)
{
if (ModelState.IsValid)
{
ClassHandler IHandler = new ClassHandler();
if (IHandler.InsertClass(iList))
{
ViewBag.AlertMsg = "Item Added successfully";
ModelState.Clear();
}
else
{
ViewBag.AlertMsg = "Item Add Failed";
ModelState.Clear();
}
}
GradeHandler gHandler = new GradeHandler();
List <GradeModel> gradelist = new List <GradeModel>();
gradelist = gHandler.GetGradeList().ToList();
gradelist.Insert(0, new GradeModel()
{
GradeID = 0, GradeName = "Select"
});
ViewBag.ListOfGrades = gradelist;
return(View());
}
public IActionResult Index()
{
ViewBag.ItemList = "Grade List Page";
GradeHandler iHandler = new GradeHandler();
ModelState.Clear();
return(View(iHandler.GetGradeList()));
}
public ActionResult Create()
{
GradeHandler gHandler = new GradeHandler();
List <GradeModel> gradelist = new List <GradeModel>();
gradelist = gHandler.GetGradeList().ToList();
gradelist.Insert(0, new GradeModel()
{
GradeID = 0, GradeName = "Select"
});
ViewBag.ListOfGrades = gradelist;
return(View());
}
public ActionResult Edit(int id)
{
ClassHandler iHandler = new ClassHandler();
ClassModel classItem = iHandler.GetClassList().Find(itemmmodel => itemmmodel.ClassID == id);
GradeHandler gHandler = new GradeHandler();
List <GradeModel> gradelist = new List <GradeModel>();
gradelist = gHandler.GetGradeList().ToList();
gradelist.Insert(classItem.Grade.GradeID, new GradeModel()
{
GradeID = 0, GradeName = "Select"
});
ViewBag.ListOfGrades = gradelist;
return(View(classItem));
}
public GradeWindow()
{
InitializeComponent();
String filePath = System.Environment.CurrentDirectory + "/webwxgetmsgimg.png";
GradeHandler.LoadDataFromExcel();
BinaryReader binReader = new BinaryReader(File.Open(filePath, FileMode.Open));
FileInfo fileInfo = new FileInfo(filePath);
byte[] bytes = binReader.ReadBytes((int)fileInfo.Length);
binReader.Close();
// Init bitmap
BitmapImage bitmap = new BitmapImage();
bitmap.BeginInit();
bitmap.StreamSource = new MemoryStream(bytes);
bitmap.EndInit();
title.Source = bitmap;
chatRoom = new List <string>();
courseList.ItemsSource = chatRoom;
// get IP address
IPAddress address = IPAddress.Parse(ipAddr);
// create the endpoint
IPEndPoint endpoint = new IPEndPoint(address, port);
// create the socket, use IPv4, stream connection and TCP protocol
socketClient = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
try
{
// Connect to the Server
socketClient.Connect(endpoint);
threadClient = new Thread(ReceiveMsg);
threadClient.IsBackground = true;
threadClient.Start();
DataTable dataTable;
while (!GradeHandler.GetCourseIdAndName(out dataTable))
{
;
}
foreach (DataRow dr in dataTable.Rows)
{
string courseName = Convert.ToString(dr["课程名称"]);
string courseId = Convert.ToString(dr["课程代码"]);
courseName = courseName.Replace('/', '_');
courseName = courseName.Replace('\\', '_');
courseName = courseName.Replace(':', '_');
courseName = courseName.Replace('*', '_');
courseName = courseName.Replace('?', '_');
courseName = courseName.Replace('\"', '_');
courseName = courseName.Replace('>', '_');
courseName = courseName.Replace('<', '_');
courseName = courseName.Replace('|', '_');
courseId = courseId.Replace('/', '_');
courseId = courseId.Replace('\\', '_');
courseId = courseId.Replace(':', '_');
courseId = courseId.Replace('*', '_');
courseId = courseId.Replace('?', '_');
courseId = courseId.Replace('\"', '_');
courseId = courseId.Replace('>', '_');
courseId = courseId.Replace('<', '_');
courseId = courseId.Replace('|', '_');
chatRoom.Add(courseName + "(" + courseId + ")");
}
CheckRoomList(chatRoom);
}
catch (SocketException se)
{
MessageBox.Show("[SocketError]Connection failed: " + se.Message);
}
catch (Exception ex)
{
MessageBox.Show("[Error]Connection failed: " + ex.Message);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
string queryString = "";
string course_Name = courseName.Text;
string school_Year = schoolYear.Text;
string _Semester = semester.Text;
string course_Type = courseType.Text;
string _Credit = credit.Text;
DataTable dt = new DataTable();
bool flag = false;
if (!school_Year.Equals(""))
{
queryString += "学年='" + school_Year + "'";
flag = true;
}
if (!course_Name.Equals(""))
{
if (flag)
{
queryString += " and 课程名称 like '%" + course_Name + "%'";
}
else
{
queryString += "课程名称 like '%" + course_Name + "%'";
flag = true;
}
}
if (!_Semester.Equals(""))
{
if (flag)
{
queryString += " and 学期='" + _Semester + "'";
}
else
{
queryString += "学期='" + _Semester + "'";
flag = true;
}
}
if (!course_Type.Equals(""))
{
if (flag)
{
queryString += " and 课程性质='" + course_Type + "'";
}
else
{
queryString += "课程性质='" + course_Type + "'";
flag = true;
}
}
if (!_Credit.Equals(""))
{
if (flag)
{
queryString += " and 学分='" + _Credit + "'";
}
else
{
queryString += "学分='" + _Credit + "'";
flag = true;
}
}
if (!flag)
{
queryString = "*";
}
flag = false;
if (GradeHandler.QueryData(queryString, out dt))
{
dataGrid1.ItemsSource = dt.DefaultView;
}
double _weight;
if (GradeHandler.CalculateWeightedMean(dt, out _weight))
{
weighting.Text = Convert.ToString(Math.Round(_weight, 2));
}
else
{
weighting.Text = "";
}
}
