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);
}
