private void lviSiparisler_MouseDoubleClick(object sender, MouseEventArgs e)
{
sID = Convert.ToInt32(lviSiparisler.SelectedItems[0].SubItems[0].Text);
ESiparis s = BLLSiparis.SiparisBul(sID);
lblSiparisID.Text = s.ID.ToString();
}
private void lviSiparisler_MouseDoubleClick(object sender, MouseEventArgs e)
{
sID = Convert.ToInt32(lviSiparisler.SelectedItems[0].SubItems[0].Text);
ESiparis s = BLLSiparis.SiparisBul(sID);
frmSiparisIncele frm = new frmSiparisIncele();
frm.Show();
}
public static void KargoKoduDuzenle(ESiparis s)
{
SqlCommand cmd = new SqlCommand("sp_KargoKoduDuzenle", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", s.ID);
cmd.Parameters.AddWithValue("@kargoKodu", s.ShippingCode);
baglanti.conn.Open();
cmd.ExecuteNonQuery();
baglanti.conn.Close();
}
public static string KargoKoduDuzenle(ESiparis s)
{
if (s.ShippingCode != "")
{
DALSiparis.KargoKoduDuzenle(s);
return("Kargo kodu girildi...");
}
else
{
return("Hatalı işlem...");
}
}
private void btnKaydet_Click(object sender, EventArgs e)
{
ESiparis s = BLLSiparis.SiparisBul(frmSiparisler.sID);
s.ShippingCode = txtKargoKodu.Text;
string cevap = BLLSiparis.KargoKoduDuzenle(s);
MessageBox.Show(cevap);
Form1 f = Application.OpenForms["Form1"] as Form1;
f.Doldur();
}
public static ESiparis SiparisBul(int sID)
{
SqlCommand cmd = new SqlCommand("sp_SiparisBul", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@sID", sID);
baglanti.conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
ESiparis s = new ESiparis();
while (dr.Read())
{
s.ID = Convert.ToInt32(dr["ID"].ToString());
s.CustomerID = Convert.ToInt32(dr["CustomerID"].ToString());
s.AddressID = Convert.ToInt32(dr["AddressID"].ToString());
s.Status = Convert.ToBoolean(dr["Status"].ToString());
s.OrderDate = Convert.ToDateTime(dr["OrderDate"].ToString());
s.ShippingCode = dr["ShippingCode"].ToString();
}
dr.Close();
baglanti.conn.Close();
return(s);
}
public static List <ESiparis> Listele()
{
SqlCommand cmd = new SqlCommand("sp_SiparisListele", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
baglanti.conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
List <ESiparis> sListe = new List <ESiparis>();
while (dr.Read())
{
ESiparis s = new ESiparis();
s.ID = Convert.ToInt32(dr["ID"].ToString());
s.CustomerID = Convert.ToInt32(dr["CustomerID"].ToString());
s.AddressID = Convert.ToInt32(dr["AddressID"].ToString());
s.Status = Convert.ToBoolean(dr["Status"].ToString());
s.OrderDate = Convert.ToDateTime(dr["OrderDate"].ToString());
s.ShippingCode = dr["ShippingCode"].ToString();
sListe.Add(s);
}
dr.Close();
baglanti.conn.Close();
return(sListe);
}
