public PlumResult DeleteFoodMAterial(Data.FoodMaterial foodMaterial)
{
var result = new PlumResult();
try
{
_db.Entry(foodMaterial).State = EntityState.Deleted;
if (_db.SaveChanges() > 0)
{
result.IsChange = true;
result.Message = "کالا با موفقیت حذف شد";
return(result);
}
}
catch (Exception e)
{
result.IsChange = false;
result.Message = e.Message;
return(result);
}
result.IsChange = false;
result.Message = "خطایی رخ داده است";
return(result);
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.CurrentRow != null)
{
int id = int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString());
using (UnitOfWork db = new UnitOfWork())
{
Data.FoodMaterial model = db.FoodMaterialService.GetOne(id);
EditMaterialFood formEdit = new EditMaterialFood();
formEdit._foodMaterilId = id;
formEdit._foodIds = model.FoodId;
formEdit.Quantity.Text = model.Quantity.ToString();
formEdit._materialId = model.MaterialPrice.Id;
formEdit._companyId = companyId;
formEdit.UnitPrice.Text = model.MaterialPrice.UnitPrice.ToString();
if (formEdit.ShowDialog() == DialogResult.OK)
{
ShowMaterialFoodGrid(_foodIds);
}
}
}
else
{
RtlMessageBox.Show("آیتمی انتخاب نشده است");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dataGridView1.RowCount > 0)
{
using (UnitOfWork db = new UnitOfWork())
{
int id = int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString());
string name = dataGridView1.CurrentRow.Cells[1].Value.ToString();
if (RtlMessageBox.Show($"ایا از حذف {name} مطمئن هستید", "توجه", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == DialogResult.Yes)
{
Data.FoodMaterial model = db.FoodMaterialService.GetOne(id);
var result = db.FoodMaterialService.DeleteFood(id);
if (result.IsChange)
{
db.Save();
RtlMessageBox.Show(result.Message);
}
else
{
RtlMessageBox.Show(result.Message);
}
}
}
ShowMaterialFoodGrid(_foodIds);
}
}
public bool AddFoodMaterial(Data.FoodMaterial foodMaterial)
{
try
{
if (IsAnyMaterial(foodMaterial.FoodId, foodMaterial.MaterialPriceId) == true)
{
return(false);
}
_db.FoodMaterials.Add(foodMaterial);
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool UpdateFoodMaterial(Data.FoodMaterial foodMaterial)
{
try
{
if (IsAnyMaterial(foodMaterial.Id, foodMaterial.FoodId, foodMaterial.MaterialPriceId) == true)
{
return(false);
}
_db.Entry(foodMaterial).State = EntityState.Modified;
return(true);
}
catch (Exception)
{
return(false);
}
}
private void button1_Click(object sender, EventArgs e)
{
using (var db = new UnitOfWork())
{
if (string.IsNullOrWhiteSpace(Quantity.Value) && Quantity.Text == "0")
{
errorProvider1.RightToLeft = true;
errorProvider1.SetError(Quantity, "لطفا مقدار لازم را وارد را وارد نمایید");
}
var material = (MaterialPriceModel)comboBox1.SelectedItem;
//مبلغ هرکیلو تقسیم بر 1000=مبلغ هر گرم
var unitPrice = material.UnitPrice / 1000;
var quantity = double.Parse(Quantity.Value);
var totalPrice = unitPrice * quantity;
var foodMaterial = new Data.FoodMaterial()
{
Id = _foodMaterilId,
MaterialPriceId = material.MateriaPriceId,
UnitPrice = material.UnitPrice,
Quantity = double.Parse(Quantity.Value),
FoodId = _foodIds,
MaterialTotalPrice = totalPrice,
Active = true
};
if (db.FoodMaterialService.UpdateFoodMaterial(foodMaterial))
{
db.Save();
RtlMessageBox.Show("عملیات با موفقیت انجام شد");
DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("کالا ثبت نگردید");
}
}
}
/// <summary>
/// گرفتن یک مواد لازم بر اساس مشخصه مواد لازم
/// </summary>
/// <param name="foodId"></param>
/// <param name="materialId"></param>
/// <returns></returns>
public Data.FoodMaterial GetOneByMaterialId(int foodId, int materialId)
{
Data.FoodMaterial result = _db.FoodMaterials.AsNoTracking().Include(a => a.MaterialPrice).Include(a => a.Food).FirstOrDefault(a => a.FoodId == foodId && a.MaterialPrice.Id == materialId);
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Data.FoodMaterial GetOne(int id)
{
Data.FoodMaterial result = _db.FoodMaterials.AsNoTracking().Include(a => a.MaterialPrice).Include(a => a.Food).FirstOrDefault(a => a.Id == id);
return(result);
}
