private void button4_Click(object sender, EventArgs e)
{
DBContext myDb = new DBContext();
myDb.categories.Where(o => o.Name == "دسته1").Load();
var cats = myDb.categories.ToList();
StoreModels.Category c;
if (cats.Count == 0)
{
c = new StoreModels.Category()
{
Name = "دسته جدید"
};
}
else
{
c = cats[0];
}
StoreModels.Product p = new StoreModels.Product()
{
Availability = 10,
BuyPrice = 1000,
SellPrice = 1500,
Category = c,
Name = "محصول1",
};
myDb.save(p);
}
private void button19_Click(object sender, EventArgs e)
{
DBContext myDb = null;
try
{
myDb = new DBContext();
StoreModels.Product p = myDb.products.Where(i => i.Code == 5).FirstOrDefault();
myDb.products.Attach(p);
myDb.delete(p);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void dataGridViewX1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DataGridViewButtonXCell cell = dataGridViewX1.CurrentCell as DataGridViewButtonXCell;
if (cell != null)
{
DataGridViewButtonXColumn bc = dataGridViewX1.Columns[e.ColumnIndex] as DataGridViewButtonXColumn;
if (bc != null)
{
switch (bc.Name)
{
case "Delete":
DialogResult dr = MessageBox.Show("آیا از حذف محصول \"" + dataGridViewX1.Rows[e.RowIndex].Cells["Name"].Value + "\" اطمینان دارید؟", "تایید حذف", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == System.Windows.Forms.DialogResult.Yes)
{
int m = (int)dataGridViewX1.Rows[e.RowIndex].Cells["code"].Value;
DBContext myDb2 = new DBContext();
StoreModels.Product p = myDb2.products.Where(i => i.Code == m).First();
try
{
myDb2.delete(p);
refresh();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
String s = "خطا در ذخیره اطلاعات در پایگاه داده\nمشخصات فنی:\n";
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Diagnostics.Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
s = s + "\nProperty: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage;
}
}
MessageBox.Show(s);
}
catch (Exception ex)
{
MessageBox.Show("خطایی رخ داد\n" + ex.Message);
}
}
break;
}
}
} //if cell ! null
} //void dataGridViewX1_CellContentClick
private void buttonX2_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox3.Text == "" || textBox4.Text == "")
{
MessageBox.Show("لطفا تمام اطلاعات را تکمیل کنید", "خطا");
return;
}
try
{
long buyPrice = long.Parse(textBox3.Text);
long sellPrice = long.Parse(textBox4.Text);
int avail = (int)numericUpDown1.Value;
StoreModels.Product p = new StoreModels.Product()
{
Name = textBox1.Text,
BarCode = textBox2.Text,
BuyPrice = buyPrice,
SellPrice = sellPrice,
Availability = avail,
Category = null
};
DBContext myDb = new DBContext();
myDb.save(p);
this.Close();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
String s = "خطا در ذخیره اطلاعات در پایگاه داده\nمشخصات فنی:\n";
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Diagnostics.Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
s = s + "\nProperty: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage;
}
}
MessageBox.Show(s);
}
catch (Exception ex)
{
MessageBox.Show("خطایی رخ داد\n" + ex.Message);
}
}
