public string DeleteGenre(GEN gen)
{
var message = "";
try
{
var toDelete = new GEN();
toDelete = gen.GenId == 0 ? context.GENs.FirstOrDefault(t => t.GenId == gen.GenId) : context.GENs.FirstOrDefault(t => t.GenId == gen.GenId);
if (toDelete != null)
{
context.GENs.Remove(toDelete);
context.SaveChanges();
}
else
{
message = "This genre does not exist or has already been deleted!";
}
}
catch (Exception e)
{
message = e.Message;
}
return(message);
}
internal GenDTO getGenDTO(GEN gen)
{
return(new GenDTO()
{
Descriere = gen.Descriere,
GenId = gen.GenId
});
}
public GEN UpdateGenre(GEN gen)
{
using (var context = new ModelDatabaseFirst())
{
context.GENs.AddOrUpdate(gen);
context.SaveChanges();
return(gen);
}
}
public GENDTO S_get_gen_by_name(string name)
{
GEN g = ClassLibrary1.Program.get_gen_by_name(name);
if (g != null)
{
return(S_gen_dto(g));
}
return(null);
}
public GENDTO S_gen_dto(GEN g)
{
//var lista = g.CARTE.Select(x => S_carte_dto(x)).ToList();
GENDTO g1 = new GENDTO()
{
Descriere = g.Descriere
//CARTE = lista
};
return(g1);
}
public string InsertGenre(GEN gen)
{
try
{
context.GENs.Add(gen);
context.SaveChanges();
}
catch (Exception e)
{
return(e.Message);
}
return("");
}
public static void Main(string[] args)
{
Pozycja p = new Pozycja("B5");
Pozycja p2 = new Pozycja("D4");
Figura f = GEN.GenerujFigure(TypFigury.Pionek, p, Kolor.KOLOR_BIALY);
f.Pozycja = new Pozycja("C2");
Console.WriteLine(f.CzyMoznaPrzesunac(p2));
Szachownica sz = Szachownica.Instancja;
sz['A', 1] = "test";
Console.WriteLine(sz['A', 1]);
Console.ReadKey();
}
public string UpdateGenre(GEN gen)
{
var message = "";
try
{
context.GENs.AddOrUpdate(gen);
context.SaveChanges();
}
catch (Exception e)
{
message = e.Message;
}
return(message);
}
public void DeleteGenre(GEN gen)
{
try
{
using (var context = new ModelDatabaseFirst())
{
context.GENs.Remove(gen);
context.SaveChanges();
return;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public Response InsertGenre(GEN gen)
{
var response = new Response();
var mapped = Mapper.Map <GEN, Data.Entities.GEN>(gen);
var reply = _bookRepository.InsertGenre(mapped);
if (reply == "")
{
response.Messages.Add("The genre has been successfully added!");
}
else
{
response.Error = true;
response.Messages.Add(reply);
}
return(response);
}
private void InsertCarte_Click(object sender, EventArgs e)
{
var genre = new GenreRepository();
var author = new AuthorRepository();
var book = new BookRepository();
int genId = 0; int autorId = 0;
var queryGen = genre.VerifyGenreByDescription(boxNumeGenInsertCarte.Text.Trim());
if (queryGen.LongCount() > 0)
{
genId = queryGen[0].GenId;
}
else if (queryGen.LongCount() == 0)
{
GEN gen = new GEN()
{
Descriere = boxNumeGenInsertCarte.Text.Trim(),
};
genId = genre.InsertGenre(gen).GenId;
}
var queryAutor = author.VerifyAuthorByName(boxNumeAutorInsertCarte.Text.Trim());
if (queryAutor.LongCount() > 0)
{
autorId = queryAutor[0].AutorId;
}
else if (queryAutor.LongCount() == 0)
{
string[] splited = boxNumeAutorInsertCarte.Text.Trim().Split(' ');
AUTOR autor = new AUTOR()
{
Nume = splited[0].Trim(),
Prenume = splited[1].Trim(),
};
autorId = author.InsertAuthor(autor).AutorId;
}
int nrExemplare = Convert.ToInt32(Math.Round(boxNrExemplareInsertCarte.Value, 0));
int count_introduse = 0;
while (count_introduse < nrExemplare)
{
CARTE carte = new CARTE()
{
AutorId = autorId,
Titlu = boxTitluCarteInsertCarte.Text.Trim(),
GenId = genId,
};
book.InsertBook(carte);
count_introduse += 1;
}
MessageBox((IntPtr)0, "\nInsert Operation Completed", "Message Box", 0);
boxNumeGenInsertCarte.Text = "";
boxTitluCarteInsertCarte.Text = "";
boxNumeAutorInsertCarte.Text = "";
boxNrExemplareInsertCarte.Value = 0;
}
public Response DeleteGenre(GEN gen)
{
return(_bookServices.DeleteGenre(gen));
}
public Response UpdateGenre(GEN gen)
{
return(_bookServices.UpdateGenre(gen));
}
public Response InsertGenre(GEN gen)
{
return(_bookServices.InsertGenre(gen));
}
