private Salariat CreateSalariat(XElement salariat, int clientId)
{
Salariat salariatNou = new Salariat
{
Nume = salariat.Element("nume").Value.ToString(),
Prenume = salariat.Element("prenume").Value.ToString(),
locatie = salariat.Element("locatie").Value.ToString(),
functie = salariat.Element("functie").Value.ToString(),
datai = DateTime.Parse(salariat.Element("datai").Value),
tip = salariat.Element("tip").Value.ToString(),
ore_zi = int.Parse(salariat.Element("ore_zi").Value),
grupa = salariat.Element("grupa").Value.ToString(),
nr_zile_co = int.Parse(salariat.Element("nr_zile_co").Value),
tip_rem = salariat.Element("tip_rem").Value.ToString(),
salar_brut = int.Parse(salariat.Element("salar_brut").Value),
cn = salariat.Element("cn").Value.ToString(),
judet = TestNullOrEmpty(salariat.Element("judet").Value.ToString()),
localitate = TestNullOrEmpty(salariat.Element("localitate").Value.ToString()),
str = TestNullOrEmpty(salariat.Element("str").Value.ToString()),
nr = TestNullOrEmpty(salariat.Element("nr").Value.ToString()),
cod_post = TestNullOrEmpty(salariat.Element("cod_post").Value.ToString()),
d_contract = String.IsNullOrEmpty(salariat.Element("d_contract").Value.ToString()) ? DateTime.Now : DateTime.Parse(salariat.Element("d_contract").Value),
ClientId = clientId
};
return(salariatNou);
}
public int ModificaSalariat(Salariat salariat)
{
using (var model = new ModelContainer())
{
try
{
var salariatExistent = model.Salariati.FirstOrDefault(s => s.Nr_crt == salariat.Nr_crt);
if (salariatExistent != null)
{
salariatExistent.Nume = salariat.Nume;
salariatExistent.Prenume = salariat.Prenume;
salariatExistent.Functie = salariat.Functie;
salariatExistent.SalariuBaza = salariat.SalariuBaza;
salariatExistent.ProcentSpor = salariat.ProcentSpor;
salariatExistent.Retineri = salariat.Retineri;
salariatExistent.PremiiBrute = salariat.PremiiBrute;
salariatExistent.Imagine = salariat.Imagine;
model.SaveChanges();
}
return(1);
}
catch
{
return(-1);
}
}
}
public async Task <IActionResult> Edit(int id, Salariat salariat)
{
if (id != salariat.SalariatId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Salariat.Update(salariat);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SalariatExists(salariat.SalariatId))
{
return(NotFound());
}
else
{
throw;
}
}
TempData["Message"] = "Salariat actualizat cu succes!";
TempData["Success"] = "true";
return(RedirectToAction(nameof(Index)));
}
ViewData["ClientId"] = new SelectList(_context.Client.OrderBy(x => x.Denumire), "ClientId", "Denumire", salariat.ClientId);
return(View(salariat));
}
public async Task <IActionResult> ImportSalariati(int?id)
{
DocumentVM documentVM = new DocumentVM()
{
};
documentVM.ApplicationUserId = _context.ApplicationUsers.FirstOrDefault(u => u.UserName == User.Identity.Name).Id;
var documentTip = await _context.TipDocument.FirstOrDefaultAsync(u => u.Denumire == "Salariati XML");
if (id != 0)
{
documentVM.ClientId = id.Value;
}
// preluam documentele primite prin ajax
var files = Request.Form.Files;
// parcurgem fiecare document si il adaugam
foreach (var file in files)
{
Document document = new Document()
{
ApplicationUserId = documentVM.ApplicationUserId,
ClientId = documentVM.ClientId,
TipDocumentId = documentTip.TipDocumentId,
DocumentPath = await _fileManager.SaveDocument(file, documentTip.Denumire, documentVM.ClientId, documentVM.ApplicationUserId),
Data = DateTime.Now
};
if (ModelState.IsValid)
{
_context.Document.Add(document);
// procesam XML-ul
// adaugam salariatii preluati din acesta clientului ales de utilizator
var fullPath = $"C:/Users/user/source/repos/Licenta/wwwroot/xml/{document.DocumentPath}";
XDocument doc = XDocument.Load(fullPath);
var salariati = from salariat in doc.Root.Elements()
select salariat;
foreach (XElement salariat in salariati)
{
Salariat salariatNou = CreateSalariat(salariat, document.ClientId);
_context.Salariat.Add(salariatNou);
}
// stergem din memorie: bd si server XML-ul
_fileManager.DeleteDocumentXML(document.DocumentPath);
_context.Document.Remove(document);
_context.SaveChanges();
}
}
return(PartialView("_AddSalariatiImport", documentVM));
}
// Create, Edit
#region
public IActionResult Create()
{
Salariat salariat = new Salariat();
ViewData["ClientId"] = new SelectList(_context.Client.OrderBy(x => x.Denumire), "ClientId", "Denumire");
if (User.IsInRole(ConstantVar.Rol_Admin_Firma))
{
salariat.ClientId = _context.ApplicationUsers.Where(x => x.Email == User.Identity.Name).First().ClientId.Value;
}
return(View(salariat));
}
public void TestSalariati()
{
Cont cont = new Cont(10);
Salariat salariat = new Salariat("salariat1", 55, cont);
Assert.AreEqual("salariat1", salariat.Nume);
Assert.AreEqual(55, salariat.Salariu);
Assert.AreEqual(cont, salariat.Cont);
}
public async Task <IActionResult> Create(DocumentVM documentVM, int?id)
{
var denumireDocument = _context.TipDocument.Find(documentVM.TipDocumentId);
Document document = new Document()
{
DocumentId = documentVM.DocumentId,
ApplicationUserId = documentVM.ApplicationUserId,
ClientId = documentVM.ClientId,
TipDocumentId = documentVM.TipDocumentId,
DocumentPath = await _fileManager.SaveDocument(documentVM.DocumentPathUrl, denumireDocument.Denumire, documentVM.ClientId, documentVM.ApplicationUserId),
Data = documentVM.Data
};
if (ModelState.IsValid)
{
_context.Document.Add(document);
await _context.SaveChangesAsync();
// aici notificam user-ul ca a primit un document
Notificare notificare = new Notificare();
string redirectToPage = "https://localhost:44342/img/documente/" + document.DocumentPath;
if (id == 0 || id == null)
{
notificare.Text = $"{denumireDocument.Denumire} pentru {document.Data} a fost incarcate pe data de {DateTime.Now}";
notificare.RedirectToPage = redirectToPage;
await _notificationManager.CreateAsync(notificare, document.ClientId);
}
else
{
// atunci am fost redirectati dinspre "Incarca document" - modul cereri documente, incarcare cerere
var cerereDocument = _context.CereriDocumente.FindAsync(id).Result;
Salariat salariat = _context.Salariat.FirstOrDefault(x => x.SalariatId == cerereDocument.SalariatId);
notificare.Text = "Cererea pentru " + cerereDocument.DenumireCerere + " pentru firma " + cerereDocument.DenumireClient + ", salariatul "
+ salariat.NumePrenume + " deadline la " + cerereDocument.DataStart + " a fost incarcata " + DateTime.Now;
notificare.RedirectToPage = redirectToPage;
await _notificationManager.CreateAsync(notificare, _context.Client.FirstOrDefault(x => x.Denumire == cerereDocument.DenumireClient).ClientId);
cerereDocument.Resolved = true;
cerereDocument.AdeverintaPath = document.DocumentPath;
_context.CereriDocumente.Update(cerereDocument);
await _context.SaveChangesAsync();
}
TempData["Message"] = "Document adaugat cu succes!";
TempData["Success"] = "true";
return(RedirectToAction(nameof(Index)));
}
ViewData["ClientId"] = new SelectList(_context.Client.OrderBy(x => x.Denumire), "ClientId", "Denumire", document.ClientId);
ViewData["ApplicationUserId"] = new SelectList(_context.ApplicationUsers.OrderBy(x => x.Nume), "Id", "Nume", document.ApplicationUserId);
ViewData["TipDocumentId"] = new SelectList(_context.TipDocument.OrderBy(x => x.Denumire), "TipDocumentId", "Denumire", document.TipDocumentId);
return(View(documentVM));
}
private void SyncDataEvidenta()
{
var salariuBaza = 0;
var spor = 0;
var premii = 0;
var cas = 0;
var cass = 0;
var impozit = 0;
var virat = 0;
var retineri = 0;
var totalBrut = 0;
var salarImpozabil = 0;
salariatBindingSource.Clear();
CalculatorViewModel.SalariatiFiltrati.ForEach(s =>
{
salariatBindingSource.Add(s);
salariuBaza += s.SalariuBaza;
spor += s.ProcentSpor;
premii += s.PremiiBrute;
cas += s.CAS ?? 0;
cass += s.CASS ?? 0;
impozit += s.Impozit ?? 0;
virat += s.ViratCard ?? 0;
retineri += s.Retineri;
totalBrut += s.TotalBrut ?? 0;
salarImpozabil += s.BrutImpozabil ?? 0;
});
spor = spor / CalculatorViewModel.SalariatiFiltrati.Count;
var salariat = new Salariat
{
Nume = "",
Prenume = "",
Functie = "TOTAL",
SalariuBaza = salariuBaza,
ProcentSpor = spor,
PremiiBrute = premii,
CAS = cas,
CASS = cass,
Impozit = impozit,
ViratCard = virat,
Retineri = retineri,
TotalBrut = totalBrut,
BrutImpozabil = salarImpozabil
};
salariatBindingSource.Add(salariat);
}
public CalculatorSalariiViewModel()
{
Salariati = new List <Salariat>();
SalariatiFiltrati = new List <Salariat>();
Parametrii = new Parametrii();
Filtru = "";
DataService = new DataService();
SalariatSelectat = new Salariat {
Nume = "", Prenume = "", Functie = ""
};
}
public async Task <IActionResult> Create(Salariat salariat)
{
if (ModelState.IsValid)
{
_context.Salariat.Add(salariat);
await _context.SaveChangesAsync();
TempData["Message"] = "Salariat creat cu succes!";
TempData["Success"] = "true";
return(RedirectToAction(nameof(Index)));
}
ViewData["ClientId"] = new SelectList(_context.Client.OrderBy(x => x.Denumire), "ClientId", "Denumire");
return(View(salariat));
}
public void PositiveTest_PlatesteAngajati()
{
Cont contfirma = new Cont(50);
Cont contAngajat = new Cont(30);
Salariat salariat = new Salariat("popescu", 15, contAngajat);
Salariati salariati = new Salariati();
salariati.AdaugaSalariat(salariat);
PlatesteAngajat plateste_angajat = new PlatesteAngajat();
plateste_angajat.PlatesteAngajati(contfirma, salariati.GetSalariati);
Assert.AreEqual(45, contAngajat.GetBalance());
}
public async Task <IActionResult> DeleteAPI(int id)
{
Salariat salariat = _context.Salariat.Find(id);
if (salariat == null)
{
return(Json(new { success = false, message = "Eroare la stergerea salariatului!" }));
}
else
{
_context.Salariat.Remove(salariat);
await _context.SaveChangesAsync();
return(Json(new { success = true, message = "Salariat sters cu succes!" }));
}
}
public int AdaugaSalariat(Salariat salariat)
{
using (var model = new ModelContainer())
{
try
{
model.Salariati.Add(salariat);
model.SaveChanges();
return(1);
}
catch
{
return(-1);
}
}
}
public int StergeSalariat(Salariat salariat)
{
using (var model = new ModelContainer())
{
try
{
var salariatExistent = model.Salariati.FirstOrDefault(s => s.Nr_crt == salariat.Nr_crt);
model.Salariati.Remove(salariatExistent);
model.SaveChanges();
return(1);
}
catch
{
return(-1);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
Cont cont_salariat1 = new Cont(10);
Salariat salariat1 = new Salariat("salariat1", 500, cont_salariat1);
Cont cont_salariat2 = new Cont(10);
Salariat salariat2 = new Salariat("salariat2", 650, cont_salariat1);
Salariati salariati = new Salariati();
salariati.AdaugaSalariat(salariat1);
salariati.AdaugaSalariat(salariat2);
Cont client1cont = new Cont(50);
Client client1 = new Client("client1", client1cont);
Cont client2cont = new Cont(50);
Client client2 = new Client("client2", client2cont);
Clienti clienti = new Clienti();
clienti.AdaugaClient(client1);
clienti.AdaugaClient(client2);
MijlocFix mijloacefixe = new MijlocFix("sediu", 56656);
CapitalPasiv capitalpasiv = new CapitalPasiv();
capitalpasiv.AddMijlocFix(mijloacefixe);
CapitalActiv capitalactiv = new CapitalActiv(46);
Cont contsocietate = new Cont(8000);
FactorySocietate factory = new FactorySocietate();
Societate societate = factory.CreeazaSocietate("sac1", salariati.GetSalariati, clienti.GetClienti, capitalactiv, capitalpasiv, contsocietate, 5);
SocietateRepositories repo = new SocietateRepositories();
repo.AdaugaSocietate(societate);
}
public void TestSocietate()
{
Cont cont_salariat1 = new Cont(10);
Salariat salariat1 = new Salariat("salariat1", 500, cont_salariat1);
Cont cont_salariat2 = new Cont(10);
Salariat salariat2 = new Salariat("salariat2", 650, cont_salariat1);
Salariati salariati = new Salariati();
salariati.AdaugaSalariat(salariat1);
salariati.AdaugaSalariat(salariat2);
Cont client1cont = new Cont(50);
Client client1 = new Client("client1", client1cont);
Cont client2cont = new Cont(50);
Client client2 = new Client("client2", client2cont);
Clienti clienti = new Clienti();
clienti.AdaugaClient(client1);
clienti.AdaugaClient(client2);
MijlocFix mijloacefixe = new MijlocFix("sediu", 56656);
CapitalPasiv capitalpasiv = new CapitalPasiv();
capitalpasiv.AddMijlocFix(mijloacefixe);
CapitalActiv capitalactiv = new CapitalActiv(46);
Cont contsocietate = new Cont(8000);
FactorySocietate factory = new FactorySocietate();
Societate societate = factory.CreeazaSocietate("societate", salariati.GetSalariati, clienti.GetClienti, capitalactiv, capitalpasiv, contsocietate, 5);
Assert.AreEqual("societate", societate.Nume);
Assert.AreEqual(salariati.GetSalariati, societate.GetSalariati);
Assert.AreEqual(clienti.GetClienti, societate.Clienti);
}
public void NegativeTest_PlatesteAngajati()
{
Cont contfirma = new Cont(50);
Cont contAngajat = new Cont(30);
Salariat salariat = new Salariat("popescu", 60, contAngajat);
Salariati salariati = new Salariati();
salariati.AdaugaSalariat(salariat);
PlatesteAngajat plateste_angajat = new PlatesteAngajat();
//act
try
{
plateste_angajat.PlatesteAngajati(contfirma, salariati.GetSalariati);
} catch (NotFundsException)
{
falgException = 1;
}
//asert
Assert.AreEqual(1, falgException);
}
private void SyncDataDetaliiSalariat(Salariat salariat)
{
if (salariat == null || salariat.Nr_crt == 0)
{
detaliiSalariatGroup.Visible = false;
return;
}
detaliiSalariatGroup.Visible = true;
numeLabel.Text = (salariat.Nume != null ? salariat.Nume.ToUpper() : "") + " " + (salariat.Prenume ?? "");
functieLabel.Text = salariat.Functie ?? "";
tableLayoutPanel1.Visible = false;
salariuLabel.Text = salariat.SalariuBaza + " RON";
sporLabel.Text = salariat.ProcentSpor + " %";
premiiBruteLabel.Text = salariat.PremiiBrute + " RON";
totalBrutLabel.Text = (salariat.TotalBrut ?? 0) + " RON";
brutImpozabilLabel.Text = (salariat.BrutImpozabil ?? 0) + " RON";
impozitLabel.Text = (salariat.Impozit ?? 0) + " RON";
casLabel.Text = (salariat.CAS ?? 0) + " RON";
cassLabel.Text = (salariat.CASS ?? 0) + " RON";
retineriLabel.Text = salariat.Retineri + " RON";
viratCardLabel.Text = (salariat.ViratCard ?? 0) + " RON";
tableLayoutPanel1.Visible = true;
if (salariat.Imagine != null)
{
var imagine = ImageUtils.ConvertByteToImage(salariat.Imagine);
pictureBox.Image = imagine;
}
else
{
pictureBox.Image = null;
}
}
public AdaugaSalariat(Salariat salariat)
{
InitializeComponent();
if (salariat != null)
{
Salariat = salariat;
numeTextBox.Text = Salariat.Nume;
prenumeTextBox.Text = Salariat.Prenume;
functieTextBox.Text = Salariat.Functie;
salariuBazaNumeric.Value = Salariat.SalariuBaza;
sporNumeric.Value = Salariat.ProcentSpor;
premiiBruteNumeric.Value = Salariat.PremiiBrute;
retineriNumeric.Value = Salariat.Retineri;
if (Salariat.Imagine != null)
{
try
{
var image = ImageUtils.ConvertByteToImage(Salariat.Imagine);
pictureBox.Image = image;
}
catch
{
}
}
this.Text = "Modifică salariat";
}
else
{
Salariat = new Salariat();
}
}
public void AdaugaSalariat(Salariat salariat)
{
Contract.Requires(salariat != null, "salariat");
salariati.Add(salariat);
}
public int AdaugaSalariat(Salariat salariat)
{
return(DataService.AdaugaSalariat(salariat));
}
public int ModificaSalariat(Salariat salariat)
{
return(DataService.ModificaSalariat(salariat));
}
public int StergeSalariat(Salariat salariat)
{
return(DataService.StergeSalariat(salariat));
}
void AdaugaSalariat(Salariat salariat, Salariati salariati)
{
Contract.Requires(salariat != null, "salariat");
salariati.AdaugaSalariat(salariat);
}
