public static int seyahatEkle(ESeyahat eSeyahat) { SqlCommand sqlCommand = null; int eklenen = 0; try { sqlCommand = new SqlCommand("Seyahat_Ekle", Baglan.Con); sqlCommand.CommandType = CommandType.StoredProcedure; if (sqlCommand.Connection.State != ConnectionState.Open) { sqlCommand.Connection.Open(); } sqlCommand.Parameters.AddWithValue("firmaId", eSeyahat.firmaId); sqlCommand.Parameters.AddWithValue("firmaAdi", eSeyahat.firmaAdi); sqlCommand.Parameters.AddWithValue("nereden", eSeyahat.nereden); sqlCommand.Parameters.AddWithValue("nereye", eSeyahat.nereye); sqlCommand.Parameters.AddWithValue("sure", eSeyahat.sure); sqlCommand.Parameters.AddWithValue("ucret", eSeyahat.ucret); sqlCommand.Parameters.AddWithValue("tarih", eSeyahat.tarih); sqlCommand.Parameters.AddWithValue("aktamali", eSeyahat.aktarmali); eklenen = sqlCommand.ExecuteNonQuery(); MessageBox.Show("Ekleme başarılı"); } catch (Exception e) { MessageBox.Show(e.ToString()); } finally { sqlCommand.Connection.Close(); } return(eklenen); }
public static int Insert(ESeyahat eSeyahat) { if (eSeyahat.firmaAdi != null && eSeyahat.firmaId > 0 && eSeyahat.nereden != null && eSeyahat.nereye != null && eSeyahat.sure > 0 && eSeyahat.ucret > 0 && eSeyahat.tarih != null && eSeyahat.aktarmali != null) { return(FSeyahat.seyahatEkle(eSeyahat)); } return(-1); }
public static List <ESeyahat> SeyahatNeredenNereye(string nereden, string nereye) { List <ESeyahat> seyahat = null; SqlCommand sqlCommand = null; SqlDataReader rdr = null; try { sqlCommand = new SqlCommand("Seyahat_Nereden_Nereye", Baglan.Con); sqlCommand.CommandType = CommandType.StoredProcedure; if (sqlCommand.Connection.State != ConnectionState.Open) { sqlCommand.Connection.Open(); } sqlCommand.Parameters.AddWithValue("nereden", nereden); sqlCommand.Parameters.AddWithValue("nereye", nereye); rdr = sqlCommand.ExecuteReader(); if (rdr.HasRows) { seyahat = new List <ESeyahat>(); while (rdr.Read()) { ESeyahat s = new ESeyahat(); s.sId = Convert.ToInt32(rdr["seyahatId"]); s.firmaId = Convert.ToInt32(rdr["firmaId"]); s.firmaAdi = rdr["firmaAdi"].ToString(); s.nereden = rdr["nereden"].ToString(); s.nereye = rdr["nereye"].ToString(); s.sure = Convert.ToInt32(rdr["sure"]); s.ucret = Convert.ToInt32(rdr["ucret"]); s.tarih = Convert.ToDateTime(rdr["tarih"]); s.aktarmali = Convert.ToInt32(rdr["aktamali"]); seyahat.Add(s); } } else { rdr.Close(); } } catch (Exception e) { MessageBox.Show(e.ToString()); seyahat = null; } finally { sqlCommand.Connection.Close(); rdr.Close(); } return(seyahat); }
private void onaylaButton_Click(object sender, EventArgs e) { eSeyahat = new ESeyahat(); if (checkBox1.Checked) { eSeyahat.aktarmali = 1; } else { eSeyahat.aktarmali = 0; } //eSeyahat.firmaAdi = firmaAdiText.Text; eSeyahat.firmaAdi = firmaAdi; //eSeyahat.firmaId = Convert.ToInt32(firmaIdText.Text); eSeyahat.firmaId = firmaId; eSeyahat.sure = Convert.ToInt32(sureText.Text); eSeyahat.ucret = Convert.ToInt32(ucretText.Text); eSeyahat.tarih = dateTimePicker1.Value; eSeyahat.nereden = comboNereden.GetItemText(comboNereden.SelectedItem); eSeyahat.nereye = comboNereye.GetItemText(comboNereye.SelectedItem); BSeyahat.Insert(eSeyahat); }