public void GetAllPozitieFacturaIesireTest()
{
var target = PozitieFacturaIesire.GetAll();
if (target == null)
{
Assert.Fail();
}
}
private void facturiGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == facturiGrid.Columns["btnColumn"].Index)
{
var factura = (FacturaIesire)facturiGrid.Rows[e.RowIndex].Tag;
new ReportViewerForm
{
FacturaIesire = factura,
PozitiiFacturaIesire = PozitieFacturaIesire.GetAll().Where(p => p.IdFacturaIesire == factura.ID).ToList()
}.Show();
}
}
private void MakeChartWithProdus(Produs produs, DateTime beginDate, DateTime endDate, IntervalType interval = IntervalType.Zilnic)
{
string comparer = "";
switch (interval)
{
case IntervalType.Zilnic:
comparer = "dd/MM/yyyy";
break;
case IntervalType.Lunar:
comparer = "MM/yyyy";
break;
}
chartVanzari.Series.Clear();
var vanzariPeProdus = new List <VanzareProdus>();
while (beginDate.Date <= endDate.Date)
{
var result = from poz in PozitieFacturaIesire.GetAll()
where poz.FacturaIesireObject.Data.ToString(comparer) == beginDate.Date.ToString(comparer) && poz.StocObject.IdProdus == produs.ID
group poz by poz.FacturaIesireObject.Data.ToString(comparer) into poz_nou
select new VanzareProdus
{
Cantitate = poz_nou.Sum(p => p.Cantitate).ToString("0.00"),
DataVanzarii = beginDate.Date.ToString(comparer)
};
VanzareProdus vanzare = null;
vanzare = result.FirstOrDefault() == null ? new VanzareProdus {
Cantitate = "0", DataVanzarii = beginDate.Date.ToString(comparer)
} : result.FirstOrDefault();
vanzariPeProdus.Add(vanzare);
switch (interval)
{
case IntervalType.Zilnic:
beginDate = beginDate.AddDays(1);
break;
case IntervalType.Lunar:
beginDate = beginDate.AddMonths(1);
break;
}
}
var series = new Series(produs.Nume);
series.XValueMember = "DataVanzarii";
series.XValueType = ChartValueType.Date;
series.YValueMembers = "Cantitate";
series.YValueType = ChartValueType.String;
chartVanzari.DataSource = vanzariPeProdus.ToList();
chartVanzari.Series.Add(series);
}
public void InsertPozitieFacturaIesireTest()
{
var target = new PozitieFacturaIesire
{
Cantitate = 12m,
IdFacturaIesire = 23,
IdStoc = 26,
PretUnitar = 12m
};
if (target.Save().Status == StatusEnum.Errors)
{
Assert.Fail();
}
}
private void LoadData()
{
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca bancile...";
Banca.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca delegatii...";
Delegat.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca drepturile...";
Drept.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca facturile...";
FacturaIntrare.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca facturile...";
FacturaIesire.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca firmele...";
Firma.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca platile...";
Plata.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca platile...";
PlataFactura.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca platile...";
PozitieFacturaIesire.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca platile...";
PozitieFacturaIntrare.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca produsele...";
Produs.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca rolurile...";
Rol.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca platile...";
RolDrept.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca stocurile...";
Stoc.GetAll();
progressBar.Invoke(new UpdateDelegate(UpdateProgressBar));
runningOperationLbl.Text = "Se incarca utilizatorii...";
Utilizator.GetAll();
}
public void UpdatePozitieFacturaIesireTest()
{
var target = new PozitieFacturaIesire
{
Cantitate = 333.50m,
IdFacturaIesire = 3,
IdStoc = 1,
PretUnitar = 555.55m,
ID = 1
};
if (target.Save().Status == StatusEnum.Errors)
{
Assert.Fail();
}
}
private void addBtn_Click(object sender, EventArgs e)
{
if (SelectedProdus == null)
{
return;
}
if (SelectedProdus.CantitateDisponibila() == 0)
{
MessageBox.Show("Produsul '" + produs.Nume + "' nu este disponibil!");
return;
}
decimal cantitate = 0m;
decimal.TryParse(cantitateTbox.Text, out cantitate);
if (cantitate <= 0)
{
MessageBox.Show("Introduceti o cantitate!");
return;
}
if (cantitate > produs.CantitateDisponibila())
{
MessageBox.Show("Ati ales o cantitate mai mare decat cantitatea disponibila!");
return;
}
decimal pretUnitar = 0;
decimal.TryParse(pretUnitarTbox.Text, out pretUnitar);
bool verifiedErrorsFlag = false;
string cantitateString = cantitate.ToString("0.00");
List <PozitieFacturaIesire> pozitiiNoiList = new List <PozitieFacturaIesire>();
while (cantitate > 0)
{
var pozitieIesireNoua = new PozitieFacturaIesire();
pozitieIesireNoua.IdFacturaIesire = 2;// pt a evita avertismentele
pozitieIesireNoua.PretUnitar = pretUnitar;
var stocDisponibil = Stoc.GetAll().Where(p => p.Cantitate > 0 && p.IdProdus == produs.ID).First();
pozitieIesireNoua.IdStoc = stocDisponibil.ID;
pozitieIesireNoua.Cantitate = stocDisponibil.Cantitate;
if (!verifiedErrorsFlag)
{
verifiedErrorsFlag = true;
var errors = pozitieIesireNoua.GetErrorString();
if (errors.Trim() != string.Empty)
{
MessageBox.Show(errors);
return;
}
}
if (stocDisponibil.Cantitate >= cantitate)
{
stocDisponibil.Cantitate -= cantitate;
pozitieIesireNoua.Cantitate = cantitate;
cantitate = 0;
}
else
{
cantitate -= stocDisponibil.Cantitate;
stocDisponibil.Cantitate = 0;
}
pozitiiNoiList.Add(pozitieIesireNoua);
pozitiiOut.Add(pozitieIesireNoua);
}
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(dataGrid, produs.Nume, cantitateString, pretUnitar.ToString("0.00"));
row.Tag = pozitiiNoiList;
dataGrid.Rows.Add(row);
RefreshCantitateDisponibila();
}
