//-------------------------CRUD------------------------------
//Add new CodeLanguage
public static void AddNewCodeLanguage(CodeLanguageInfo Languageinfo)
{
//Create Connection
using (MySqlConnection connection = DbInfo.Connection())
{
//Create cmd
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = connection;
cmd.CommandType = CommandType.Text;
//Create CommandText
cmd.CommandText = "INSERT INTO `proglanguage`(`ID`, `Name`) VALUES (@ID, @Name)";
//Set Parameters
cmd.Parameters.AddWithValue("@ID", "");
cmd.Parameters.AddWithValue("@Name", Languageinfo.Name);
try
{
int recordsAffected = cmd.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
}
}
//Submit-Button-Click Handler
private void Submit_btn_Click(object sender, RoutedEventArgs e)
{
switch (Functionalitie)
{
case CRUDFunctionalitie.Add:
Info = new CodeLanguageInfo(0, Language_txt.Text);
DbCodeLanguage.AddNewCodeLanguage(Info);
this.Close();
break;
case CRUDFunctionalitie.Update:
if (Info != null)
{
Info = new CodeLanguageInfo(0, Language_txt.Text);
DbCodeLanguage.UpdateCodeLanguage(Info);
this.Close();
}
break;
case CRUDFunctionalitie.Delete:
if (Info != null)
{
DbCodeLanguage.DeleteCodeLanguage(Info.ID);
this.Close();
}
break;
}
}
//Update new CodeLanguage
public static void UpdateCodeLanguage(CodeLanguageInfo Languageinfo)
{
//Create Connection
using (MySqlConnection connection = DbInfo.Connection())
{
//Create Cmd
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = connection;
cmd.CommandType = CommandType.Text;
//Create CommandText
cmd.CommandText = "UPDATE `proglanguage` SET `Name`=@Name WHERE `ID`=@ID,";
//Set Parameters
cmd.Parameters.AddWithValue("@ID", Languageinfo.ID);
cmd.Parameters.AddWithValue("@Name", Languageinfo.Name);
try
{
int recordsAffected = cmd.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
}
}
//-------------------------Functions------------------------------
//Main Functon to Setup the UI
public CodeLanguage(CRUDFunctionalitie functionalitie, CodeLanguageInfo info)
{
InitializeComponent();
this.WindowStartupLocation = WindowStartupLocation.CenterScreen;
Info = info;
Functionalitie = functionalitie;
this.Show();
switch (functionalitie)
{
case CRUDFunctionalitie.Add:
Submit_btn.Content = "Add";
break;
case CRUDFunctionalitie.Update:
Submit_btn.Content = "Update";
if (Info != null)
{
Language_txt.Text = Info.Name;
}
else
{
this.Close();
}
break;
case CRUDFunctionalitie.Delete:
Submit_btn.Content = "Delete";
if (Info != null)
{
Language_txt.Text = Info.Name;
}
else
{
this.Close();
}
break;
}
}
