public static List <Connection.Model.AllGoods> ReturnAllGoods()
{
using (var context = new Connection.Model.PersianModel())
{
return(context.AllGoods.AsNoTracking().ToList());
}
}
public static List <Connection.Model.Arz> ReturnArz()
{
using (var context = new Connection.Model.PersianModel())
{
//var x = context.Customers.ToList();
return(context.Arz.AsNoTracking().ToList());
}
}
public static bool Delete()
{
using (var context = new Connection.Model.PersianModel())
{
try
{
context.AllGoods.RemoveRange(context.AllGoods.ToList());
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
return(false);
}
}
}
public static bool Create(Connection.Model.AllGoods AllGoodsInstance)
{
using (var context = new Connection.Model.PersianModel())
{
try
{
context.AllGoods.Add(AllGoodsInstance);
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
return(false);
}
}
}
public static List <GoodsReportService> ReturnGoodsForReport(string v1, string v2)
{
using (var context = new Connection.Model.PersianModel())
{
return((from read in context.AllGoods.AsNoTracking().Where(a => a.ActDate.CompareTo(v1) >= 0 && a.ActDate.CompareTo(v2) <= 0)
join read2 in context.Arz on read.ArzID equals read2.ArzID
select new GoodsReportService
{
ActDate = read.ActDate,
ArzPrice = read2.Price,
BuyPrice = read.BuyPrice,
KolPrice = 0,
GoodsName = read.GoodsName,
OtherPrices = read.OtherPrices,
RowID = 0,
ArzName = read.ArzName,
}).ToList());
}
}
public static bool Update(Connection.Model.Arz ObjectName)
{
using (var context = new Connection.Model.PersianModel())
{
try
{
var Ins = context.Arz.Where(a => a.ArzID == ObjectName.ArzID).FirstOrDefault();
Ins.ArzName = ObjectName.ArzName;
Ins.Price = ObjectName.Price;
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
return(false);
}
}
}
