private void btnHitungAritmetika_Click(object sender, RoutedEventArgs e)
{
double a, b, n, Un, Sn;
a = double.Parse(txtBoxAritmetikaA.Text);
b = double.Parse(txtBoxAritmetikaB.Text);
n = double.Parse(txtBoxAritmetikaN.Text);
Un = Fungsi.deretAritmetikaUn(a, b, n);
Sn = Fungsi.deretAritmetikaSn(a, n, Un);
lblHasilUnAritmetika.Content = Un.ToString();
lblHasilSnAritmetika.Content = Sn.ToString();
}
public void Insert()
{
string query = "INSERT INTO student_info (SN, Password, EntryDate, Level, Status,"
+ " CourseCode, Major, LastName, FirstName, MiddleName,"
+ " Address, Sex, BirthDate, BirthPlace, Citizenship, Religion, ContactNo)"
+ " VALUES"
+ " (@SN, @Password, @EntryDate, @Level, @Status, @CourseCode, @Major, @LastName, @FirstName, @MiddleName, @Address, @Sex, @BirthDate, @BirthPlace, @Citizenship, @Religion, @ContactNo);";
try
{
using (MySqlConnection myConn = new MySqlConnection(connection))
using (MySqlCommand myCommand = new MySqlCommand(query, myConn))
{
myCommand.Parameters.AddWithValue("@SN", this.Sn.ToString());
myCommand.Parameters.AddWithValue("@Password", this.Password.ToString());
myCommand.Parameters.AddWithValue("@EntryDate", this.EntryDate.ToString());
myCommand.Parameters.AddWithValue("@Level", this.Level.ToString());
myCommand.Parameters.AddWithValue("@Status", this.Status.ToString());
myCommand.Parameters.AddWithValue("@CourseCode", this.Course.ToString());
myCommand.Parameters.AddWithValue("@Major", this.Major.ToString());
myCommand.Parameters.AddWithValue("@LastName", this.LastName.ToString());
myCommand.Parameters.AddWithValue("@FirstName", this.FirstName.ToString());
myCommand.Parameters.AddWithValue("@MiddleName", this.MiddleName.ToString());
myCommand.Parameters.AddWithValue("@Address", this.Address.ToString());
myCommand.Parameters.AddWithValue("@Sex", this.Sex.ToString());
myCommand.Parameters.AddWithValue("@BirthDate", this.Bday.ToString());
myCommand.Parameters.AddWithValue("@BirthPlace", this.Bplace.ToString());
myCommand.Parameters.AddWithValue("@Citizenship", this.Citizenship.ToString());
myCommand.Parameters.AddWithValue("@Religion", this.Religion.ToString());
myCommand.Parameters.AddWithValue("@ContactNo", this.Contact.ToString());
myCommand.CommandTimeout = 60;
myConn.Open();
int affectedRows = myCommand.ExecuteNonQuery();
MessageBox.Show("Student account registered\nSN: " + Sn.ToString(), "Successful");
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
public void Update()
{
string query = "UPDATE `student_info` SET `Password` = @Password, `EntryDate` = @EntryDate, `Level` = @Level,"
+ "`Status` = @Status, `CourseCode` = @CourseCode, `Major` = @Major, `LastName` = @LastName, "
+ "`FirstName` = @FirstName, `MiddleName` = @MiddleName, `Address` = Address, `Sex` = @Sex, "
+ "`BirthDate` = @BirthDate, `BirthPlace` = @BirthPlace, `Citizenship` = @Citizenship, "
+ "`Religion` = @Religion, `ContactNo` = @ContactNo WHERE `student_info`.`SN` = @SN;";
try
{
using (MySqlConnection myConn = new MySqlConnection(connection))
using (MySqlCommand myCommand = new MySqlCommand(query, myConn))
{
myCommand.Parameters.AddWithValue("@SN", this.Sn.ToString());
myCommand.Parameters.AddWithValue("@Password", this.Password.ToString());
myCommand.Parameters.AddWithValue("@EntryDate", this.EntryDate.ToString());
myCommand.Parameters.AddWithValue("@Level", this.Level.ToString());
myCommand.Parameters.AddWithValue("@Status", this.Status.ToString());
myCommand.Parameters.AddWithValue("@CourseCode", this.Course.ToString());
myCommand.Parameters.AddWithValue("@Major", this.Major.ToString());
myCommand.Parameters.AddWithValue("@LastName", this.LastName.ToString());
myCommand.Parameters.AddWithValue("@FirstName", this.FirstName.ToString());
myCommand.Parameters.AddWithValue("@MiddleName", this.MiddleName.ToString());
myCommand.Parameters.AddWithValue("@Address", this.Address.ToString());
myCommand.Parameters.AddWithValue("@Sex", this.Sex.ToString());
myCommand.Parameters.AddWithValue("@BirthDate", this.Bday.ToString());
myCommand.Parameters.AddWithValue("@BirthPlace", this.Bplace.ToString());
myCommand.Parameters.AddWithValue("@Citizenship", this.Citizenship.ToString());
myCommand.Parameters.AddWithValue("@Religion", this.Religion.ToString());
myCommand.Parameters.AddWithValue("@ContactNo", this.Contact.ToString());
myCommand.CommandTimeout = 60;
myConn.Open();
int affectedRows = myCommand.ExecuteNonQuery();
MessageBox.Show("Student Information Updated\nSN:" + Sn.ToString(), "Successful");
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
public void Delete()
{
string query = "DELETE FROM `student_info` WHERE `student_info`.`SN` = @SN";
try
{
using (MySqlConnection myConn = new MySqlConnection(connection))
using (MySqlCommand myCommand = new MySqlCommand(query, myConn))
{
myCommand.Parameters.AddWithValue("@SN", this.Sn.ToString());
myCommand.CommandTimeout = 60;
myConn.Open();
int affectedRows = myCommand.ExecuteNonQuery();
MessageBox.Show("Student Info Deleted\nSN:" + Sn.ToString(), "Successful");
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
private void TB_搜尋_TextChanged(object sender, TextChangedEventArgs e)
{
if (TB_搜尋.Text.Length == 5 || TB_搜尋.Text.Length > 40)
{
int Sn;
if (!int.TryParse(TB_搜尋.Text, out Sn))
{
if (TB_搜尋.Text.Contains("sn="))
{
var s = TB_搜尋.Text.Substring(TB_搜尋.Text.IndexOf("sn=") + 3);
if (!int.TryParse(s, out Sn))
{
WPFMessageBox.Show("不是正確的連結格式。");
return;
}
}
else
{
WPFMessageBox.Show("不是正確的連結格式。");
return;
}
}
Model.BahaModel Baha = new Model.BahaModel();
if (Local.ProxyIP != "" && Local.ProxyPort != 0) //如果有設定Proxy
{
WebRequest.Proxy = new System.Net.WebProxy(Local.ProxyIP, Local.ProxyPort);
if (Local.ProxyUser != "")
{
System.Net.ServicePointManager.Expect100Continue = false;
WebRequest.Proxy.UseDefaultCredentials = true;
WebRequest.Proxy.Credentials = new System.Net.NetworkCredential(Local.ProxyUser, Local.ProxyPass);
}
}
Baha.SN = Sn.ToString();
Baha.Name = WebRequest.GetTitle(Baha.SN).Split('-')[0];
if (Baha.Name == "")
{
return;
}
if (Baha.Name == "巴哈姆特電玩資訊站")
{
WPFMessageBox.Show("找不到SN為" + Baha.SN + "的影片資料。");
return;
}
if (VideoList.Where(I => I.SN == Baha.SN).Count() > 0)
{
WPFMessageBox.Show("此影片 " + Baha.Name + " 己經在清單中...");
return;
}
if (File.Exists(Local.AniDir + "\\" + Baha.Name + ".mp4"))
{
if (WPFMessageBox.Show("在下載資料夾裡己經有同樣名稱為 " + Baha.Name + " 的影片，是否要重新下載?" , WPFMessageBoxButton.YesNo) == WPFMessageBoxResult.No)
{
return;
}
}
Baha.Status = "排隊中...";
if (VideoList.Count > 0)
{
Baha.No = VideoList.Max(I => I.No) + 1;
}
else
{
Baha.No = 1;
}
Baha.Quality = Local.Quality;
VideoList.Add(Baha);
DataGrid_清單.ItemsSource = null;
DataGrid_清單.ItemsSource = VideoList;
處理下載();
TB_搜尋.Text = "";
}
}