private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { //çift tıklanan satırı al var cells = dataGridViewSale.SelectedRows[0].Cells; //satırdaki ürünün cinsini bul Product p; if (cells["IMEI1"].Value == "") { p = new PhoneCase(); } else { p = new Phone(); } //ürünün isim, fiyat, ID bilgilerini tut p.ID = (int)cells["ID"].Value; p.Price = (decimal)cells["Price"].Value; p.ProductName = cells["ProductName"].Value.ToString(); //tutulan bilgileri listboxa aktar listBoxSale.Items.Add(p); CalculateTotal(); }
private void btnInsert_Click(object sender, EventArgs e) { PhoneCase p = new PhoneCase(); p.ProductName = txtName.Text; p.CaseColor = (CaseColor)cmBoxColor.SelectedIndex; p.Price = NumUpDwnPrice.Value; p.StockCount = (int)numericUpDownQuantity.Value; _uw.PhoneCaseRepo.InsertPhoneCase(p); RefreshMainGrid(); }
public void InsertPhoneCase(PhoneCase newPhoneCase) { #region AlanIsmi //bu alan kodları bölmeye yarıyo gizlemeye yaryo #endregion SqlParameter p1 = new SqlParameter("ProductName", newPhoneCase.ProductName); SqlParameter p2 = new SqlParameter("Price", newPhoneCase.Price); SqlParameter p3 = new SqlParameter("Color", newPhoneCase.CaseColor); SqlParameter p4 = new SqlParameter("StkCount", newPhoneCase.StockCount); Program.SqlHelper.ExecuteProc("InsertPhoneCase", p1, p2, p3, p4); }
private void btnSave_Click(object sender, EventArgs e) { PhoneCase pc = new PhoneCase(); pc.ProductName = txtProductName.Text; pc.CaseColor = (CaseColor)cboxColor.SelectedIndex; pc.Price = (int)numericPrice.Value; pc.Quantity = (int)numericQty.Value; _uw.PhoneCases.InsertPhoneCase(pc); RefreshMainGrid(); FillPhoneCasesCombo(); }
private void btn_save_Click(object sender, EventArgs e) { PhoneCase p = new PhoneCase(); p.ProductName = tb_name.Text; p.CaseColor = (CaseColor)cb_color.SelectedIndex; p.Price = nm_price.Value; p.StockQTY = (int)nm_qty.Value; _uw.PhoneCases.InsertPhoneCase(p); RefreshMainGrid(); FillPhoneCasesCombo(); }
public List <PhoneCase> GetPhoneCases() { List <PhoneCase> PhoneCases = new List <PhoneCase>(); DataTable dt = Program.SqlHelper.GetTable("Select * from PhoneCases"); foreach (DataRow item in dt.Rows) { PhoneCase Pc = new PhoneCase(); Pc.ID = (int)item["ID"]; Pc.Price = (decimal)item["Price"]; Pc.ProductName = item["ProductName"].ToString(); Pc.CaseColor = (CaseColor)item["Color"]; Pc.StockCount = (int)item["StockCount"]; PhoneCases.Add(Pc); } return(PhoneCases); }