/// <summary>
/// Add a new object of type <see cref="Auto"/> in the database
/// </summary>
/// <param name="nrAuto"></param>
/// <param name="serieSasiu"></param>
/// <param name="codSasiu"></param>
/// <param name="denumireSasiu"></param>
/// <param name="clientId"></param>
public static void Add(string nrAuto, string serieSasiu, string codSasiu, string denumireSasiu, int clientId)
{
int sasiuID = 0;
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
//Verifica daca exista deja acest sasiu
//var codSasiuExistent = context.SasiuSet.SingleOrDefault(s => s.CodSasiu == codSasiu);
var denumireSasiuExistenta = context.SasiuSet.SingleOrDefault(s => s.Denumire == denumireSasiu);
if (denumireSasiuExistenta != null)
{
sasiuID = denumireSasiuExistenta.Id;
}
else
{
Sasiu sasiu = new Sasiu()
{
CodSasiu = codSasiu,
Denumire = denumireSasiu
};
context.SasiuSet.Add(sasiu);
context.SaveChanges();
sasiuID = sasiu.Id;
}
try
{
Auto auto = new Auto()
{
NumarAuto = nrAuto,
SerieSasiu = serieSasiu,
SasiuId = sasiuID,
ClientId = clientId
};
context.AutoSet.Add(auto);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors)
{
foreach (DbValidationError error in entityErr.ValidationErrors)
{
throw;
}
}
}
}
}
/// <summary>
/// Add method, adds a new operation to the Operatie entity
/// </summary>
/// <param name="denumire"></param>
/// <param name="timpExec"></param>
public static void Add(string denumire, Decimal timpExec)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
try
{
Operatie operatie = new Operatie()
{
Denumire = denumire,
TimpExecutie = timpExec
};
context.OperatieSet.Add(operatie);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors)
{
foreach (DbValidationError error in entityErr.ValidationErrors)
{
throw;
}
}
}
}
}
/// <summary>
/// Add method, adds a new mecanic
/// </summary>
/// <param name="nume"></param>
/// <param name="prenume"></param>
public static void Add(string nume, string prenume)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
try
{
Mecanic mecanic = new Mecanic()
{
Nume = nume,
Prenume = prenume
};
context.MecanicSet.Add(mecanic);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors)
{
foreach (DbValidationError error in entityErr.ValidationErrors)
{
throw;
}
}
}
}
}
/// <summary>
/// Adds a new object of type <see cref="Material"/>
/// </summary>
/// <param name="denumire"></param>
/// <param name="cantitate"></param>
/// <param name="pret"></param>
/// <param name="dataAprovizionare"></param>
public static void Add(string denumire, Decimal cantitate, Decimal pret, DateTime dataAprovizionare)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
try
{
Material material = new Material()
{
Denumire = denumire,
Cantitate = cantitate,
Pret = pret,
DataAprovizionare = dataAprovizionare
};
context.MaterialSet.Add(material);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors)
{
foreach (DbValidationError error in entityErr.ValidationErrors)
{
throw;
}
}
}
}
}
/// <summary>
/// Deletes an object from the DB. It requires the id of the object
/// </summary>
/// <param name="id"></param>
public static void Delete(int id)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
Operatie operatie = new Operatie()
{
Id = id
};
context.OperatieSet.Attach(operatie);
context.OperatieSet.Remove(operatie);
context.SaveChanges();
}
}
/// <summary>
/// Delete method, deletes an object from the DB. It requires the id of the object
/// </summary>
/// <param name="id"></param>
public static void Delete(int id)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
Auto auto = new Auto()
{
Id = id
};
context.AutoSet.Attach(auto);
context.AutoSet.Remove(auto);
context.SaveChanges();
}
}
/// <summary>
/// Deletes an object of type <see cref="Imagine"/>
/// </summary>
/// <param name="id"></param>
public static void Delete(int id)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
Imagine imagine = new Imagine()
{
Id = id
};
context.ImagineSet.Attach(imagine);
context.ImagineSet.Remove(imagine);
context.SaveChanges();
}
}
/// <summary>
/// Delete method, deletes an object from the DB. It requires the id of the object
/// </summary>
/// <param name="id"></param>
public static void Delete(int id)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
Mecanic mecanic = new Mecanic()
{
Id = id
};
context.MecanicSet.Attach(mecanic);
context.MecanicSet.Remove(mecanic);
context.SaveChanges();
}
}
/// <summary>
/// Deletes an object of type <see cref="Material"/>
/// </summary>
/// <param name="id"></param>
public static void Delete(int id)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
Material material = new Material()
{
Id = id
};
context.MaterialSet.Attach(material);
context.MaterialSet.Remove(material);
context.SaveChanges();
}
}
/// <summary>
/// Deletes an object of type <see cref="DetaliuComanda"/>
/// </summary>
/// <param name="id"></param>
public static void Delete(int id)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
DetaliuComanda detaliu = new DetaliuComanda()
{
Id = id
};
context.DetaliuComandaSet.Attach(detaliu);
context.DetaliuComandaSet.Remove(detaliu);
context.SaveChanges();
}
}
/// <summary>
/// Delete method, deletes an object from the DB. It requires the id of the object
/// </summary>
/// <param name="id"></param>
public static void Delete(int?id)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
if (id != null)
{
Client client = new Client()
{
Id = id.GetValueOrDefault()
};
context.ClientSet.Attach(client);
context.ClientSet.Remove(client);
context.SaveChanges();
}
}
}
/// <summary>
/// Update method, changes the values of an object of type <see cref="Auto"/>
/// </summary>
/// <param name="id"></param>
/// <param name="nrAuto"></param>
/// <param name="serieSasiu"></param>
/// <param name="codSasiu"></param>
/// <param name="denumireSasiu"></param>
/// <param name="clientId"></param>
public static void Update(int id, string nrAuto, string serieSasiu, string codSasiu, string denumireSasiu, int clientId)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
var autoId = context.AutoSet.SingleOrDefault(i => i.Id == id);
var sasiu = context.SasiuSet.SingleOrDefault(s => s.Id == autoId.SasiuId);
if (autoId != null)
{
autoId.NumarAuto = nrAuto;
autoId.SerieSasiu = serieSasiu;
sasiu.CodSasiu = codSasiu;
sasiu.Denumire = denumireSasiu;
autoId.ClientId = clientId;
context.SaveChanges();
}
}
}
/// <summary>
/// Update method. Requires <paramref name="id"/> of the entity Mecanic and
/// the new values for <paramref name="nume"/> and <paramref name="prenume"/> to be changed
/// </summary>
/// <param name="id"></param>
/// <param name="nume"></param>
/// <param name="prenume"></param>
public static void Update(int id, string nume, string prenume)
{
Mecanic mecanic = new Mecanic()
{
Id = id,
Nume = nume,
Prenume = prenume
};
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
var result = context.MecanicSet.SingleOrDefault(m => m.Id == id);
if (result != null)
{
result.Nume = nume;
result.Prenume = prenume;
context.SaveChanges();
}
}
}
public static void AddClient(Client client)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
try
{
context.Database.Connection.Open();
context.ClientSet.Add(client);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors)
{
foreach (DbValidationError error in entityErr.ValidationErrors)
{
throw;
}
}
}
}
}
/// <summary>
/// Add method, adds a new client
/// </summary>
/// <param name="fName"></param>
/// <param name="lName"></param>
/// <param name="addrs"></param>
/// <param name="localitate"></param>
/// <param name="judet"></param>
/// <param name="tel"></param>
/// <param name="email"></param>
public static void Add(string fName, string lName, string addrs, string localitate, string judet, string tel, string email)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
try
{
Client client = new Client()
{
Nume = fName,
Prenume = lName,
Adresa = addrs,
Localitate = localitate,
Judet = judet,
Telefon = tel,
Email = email
};
context.ClientSet.Add(client);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors)
{
foreach (DbValidationError error in entityErr.ValidationErrors)
{
//Console.WriteLine("Error: {0}", error.ErrorMessage);
//return error.ErrorMessage;
throw;
}
}
}
}
}
/// <summary>
/// Adds a new object of type <see cref="Comanda"/>
/// </summary>
/// <param name="autoId"></param>
/// <param name="clientId"></param>
/// <param name="stare"></param>
/// <param name="dataProgramare"></param>
/// <param name="dataFinalizare"></param>
/// <param name="kmBord"></param>
/// <param name="descriere"></param>
public static void Add(int autoId, int clientId, string stare, DateTime dataProgramare, DateTime dataFinalizare, int kmBord, string descriere)
{
using (ModelCarServiceContainer context = new ModelCarServiceContainer())
{
context.Database.Connection.Open();
try
{
Comanda comanda = new Comanda()
{
AutoId = autoId,
ClientId = clientId,
StareComanda = stare,
DataSystem = DateTime.Now,
DataProgramare = dataProgramare,
DataFinalizare = dataFinalizare,
KmBord = kmBord,
Descriere = descriere,
ValoarePiese = 0
};
context.ComandaSet.Add(comanda);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult entityErr in ex.EntityValidationErrors)
{
foreach (DbValidationError error in entityErr.ValidationErrors)
{
throw;
}
}
}
}
}
