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