Ejemplo n.º 1
0
        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();
        }
Ejemplo n.º 2
0
        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();
        }
Ejemplo n.º 3
0
        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();
        }
Ejemplo n.º 6
0
        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);
        }
Ejemplo n.º 7
0
        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);
        }