public ReportViewSpareSalesByPeriod(DateTime df, DateTime dt, int SpareID, int WID)
{
InitializeComponent();
dateTo = dt;
dateFrom = df;
WarehouseID = WID;
DataAccess db = new DataAccess();
Spare = db.GetSpareView(SpareID);
if (Spare == null)
return;
}
public SpareView SpareCreateSilent(string Name, string CodeShatem, string GroupName, string ParentGroupName, string BrandName, string UnitName, string Description)
{
DataAccess da = new DataAccess();
spare s = da.SpareCreateSilent(Name, CodeShatem, GroupName, ParentGroupName, BrandName, UnitName, Description);
SpareView SpareViewItem = da.GetSpareView(s.id);
SpareContainer.Instance.Update(s.id);
int BrandID = SpareViewItem.BrandID;
int GroupID = SpareViewItem.GroupID;
if (SpareContainer.Instance.Spares.Where(i => i.BrandID == BrandID && i.GroupID == GroupID).Count() == 1)
{
if (s.brand == null)
s.brandReference.Load();
da.SpareGroupCreate(GroupID, s.brand.name);
}
return SpareViewItem;
}
// ЗАПЧАСТЬ - ДОБАВИТЬ
public SpareView SpareCreate()
{
if (!ready())
return null;// null;
SpareView result = null;
SpareEditView v = new SpareEditView();
v._id = -1;
v.ParentWorkspace = mainWindowObj;
v.ShowDialog();
if (v._spare != null)
{
DataAccess db = new DataAccess();
result = db.GetSpareView(v._spare.id);
mainWindowObj.LoadSpares();
mainWindowObj.LoadGroups(false);
}
return result;
}
private void OfferingAdd(int SpareID, decimal Q, decimal Pusd, string GroupName, string ParentGroupName)
{
SpareInSpareIncomeView sisi = new SpareInSpareIncomeView();
if (Income.currency == null)
Income.currencyReference.Load();
sisi.num = offerings.Count + 1;
sisi.CurrencyID = Income.currency.id;
sisi.description = "";
sisi.Markup = 0;
sisi.PIn = Pusd;
sisi.PInBasic = Pusd;
sisi.POut = Pusd;
sisi.POutBasic = Pusd;
sisi.QIn = Q;
sisi.QRest = Q;
sisi.S = Q * Pusd;
sisi.SBasic = sisi.S;
sisi.GroupName = GroupName;
sisi.ParentGroupName = ParentGroupName;
DataAccess db = new DataAccess();
sisi.SpareID = SpareID;
SpareView sv = db.GetSpareView(SpareID);
sisi.SpareName = sv.name;
sisi.SpareCode = sv.code;
sisi.SpareCodeShatem = sv.codeShatem;
sisi.BrandName = sv.BrandName;
sisi.SpareIncomeID = Income.id;
sisi.VatRateName = "0%";
offerings.Add(sisi);
}
private void OfferingAdd(int SpareID)
{
SpareInSpareIncomeView sisi = new SpareInSpareIncomeView();
if (Income.currency == null)
Income.currencyReference.Load();
sisi.num = offerings.Count + 1;
sisi.CurrencyID = Income.currency.id;
sisi.description = "";
sisi.Markup = 0;
sisi.PIn = 1;
sisi.PInBasic = 1;
sisi.POut = 1;
sisi.POutBasic = 1;
sisi.QIn = 1;
sisi.QRest = 1;
sisi.S = 1;
sisi.SBasic = 1;
DataAccess db = new DataAccess();
sisi.SpareID = SpareID;
SpareView sv = db.GetSpareView(SpareID);
sisi.SpareName = sv.name;
sisi.SpareCode = sv.code;
sisi.SpareCodeShatem = sv.codeShatem;
sisi.BrandName = sv.BrandName;
sisi.SpareIncomeID = Income.id;
sisi.VatRateName = "0%";
sisi.GroupName = db.GetSpareGroup(sv.GroupID).name;
sisi.ParentGroupName = db.GetSpareGroup(sv.spare_group1_id.Value).name;
offerings.Add(sisi);
}
private void Window_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
if (IsNew && TemporarySaved)
{
DataAccess db = new DataAccess();
SpareViewItem = db.GetSpareView(this._id);
Marvin.Instance.SpareDelete(SpareViewItem);
}
}
/*
* OLD
public void Update(SpareView spare)
{
if (Spares.Where(x => x!= null).Where(x => x.id != null).Where(x => x.id == spare.id).Count() > 0)
{
SpareView sv = spares.Where(x => x != null).Where(x => x.id != null).FirstOrDefault(x => x.id == spare.id);
if(sv != null)
Spares.Remove(sv);
}
Spares.Add(spare);
}*/
/* dec2012
public void Update(SpareView NewSpareInstance, bool UpdateFromDB = true) // обновление без удаления
{
if (UpdateFromDB)
{
DataAccess da = new DataAccess();
SpareView OldSpareInstance = Spares.Where(x => x != null).FirstOrDefault(x => x.id == NewSpareInstance.id);
// если в кэше такая есть, запоминает индекс и перезаписываем
if (OldSpareInstance != null)
{
int i = Spares.IndexOf(OldSpareInstance);
spares[i] = NewSpareInstance;
}
else
{
spares.Add(NewSpareInstance);
}
}
else
{
List<SpareView> items = this.Spares;
SpareView ind = items.Where(x => x != null).FirstOrDefault(x => x.id == NewSpareInstance.id);
if (ind != null)
{
int i = spares.IndexOf(ind);
spares[i] = NewSpareInstance;
}
else
{
spares.Add(NewSpareInstance);
}
}
}
*/
public void Update(int SpareID, bool UpdateFromDB = true, bool SkipQRestsCalculation = false)
{
if (UpdateFromDB)
{
DataAccess da = new DataAccess();
SpareView OldSpareInstance = Spares.Where(x => x != null).FirstOrDefault(x => x.id == SpareID);
SpareView NewSpareInstance = da.GetSpareView(SpareID);
// если в кэше такая есть, запоминает индекс и перезаписываем
if (OldSpareInstance != null)
{
int i = Spares.IndexOf(OldSpareInstance);
spares[i] = NewSpareInstance;
}
else
{
spares.Add(NewSpareInstance);
}
}
else
{
List<SpareView> items = this.Spares.ToList();
SpareView ind = items.Where(x => x != null).FirstOrDefault(x => x.id == SpareID);
if (ind != null)
{
int i = spares.IndexOf(ind);
spares[i] = ind;
}
else
{
DataAccess db = new DataAccess();
SpareView sv = db.GetSpareView(SpareID);
spares.Add(sv);
}
}
if (!SkipQRestsCalculation)
{
Helper.CalculateQRests(SpareID);
Update(SpareID, true, true);
}
}
