Service CRM Program with DevExpress (Windows Deskop Application)
Those who want to improve themselves on Windows desktop application by using C # technology can benefit.
- SQL Server database is used.
- DevExpress Tools are used.
- You will learn OOP structure and classic .Net structure.
- C# Windows Application
- DevExpress Tools
- .Net 4.5 Clasic
- Object Orient Programing
- SQL Server Database
Show examples of usage:
DialogResult dlg = MessageBox.Show("İş Emri Sisteme Kaydedilsin mi?", "Kaydetme Onay", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dlg == DialogResult.Yes)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
try
{
OleDbCommand com = new OleDbCommand("Insert Into IsEmri(MusteriID,YapilanIsID,Kontrol,PersonelID,MatbaaID,Baslangic) values(@M,@Y,@K,@P,@MID,@B)", con);
com.Parameters.AddWithValue("@M", Convert.ToInt32(mustericombo.SelectedValue));
com.Parameters.AddWithValue("@Y", Convert.ToInt32(Yapilancombo.SelectedValue));
com.Parameters.AddWithValue("@K", durumcombo.Text.ToString());
com.Parameters.AddWithValue("@P", Convert.ToInt32(personelcombo.SelectedValue));
com.Parameters.AddWithValue("@MID", Convert.ToInt32(Matbaacombo.SelectedValue));
com.Parameters.AddWithValue("@B", dateTimePicker1.Value.ToLongDateString());
if (com.ExecuteNonQuery() > 0)
{
MessageBox.Show("Kayıt Yapıldı.");
}
}
catch (Exception Ex)
{
MessageBox.Show(Ex.ToString());
}
finally { con.Close(); }
}