public void AddPublicationCode(Author owner, string publicationcode)
{
var objj = _context.Artwork.First(obj => obj.Owner == owner && obj.Status == Models.Enums.ArtworkStatus.FreeToUse);
var obj1 = objj;
_context.Artwork.Remove(objj);
_context.SaveChanges();
obj1.PublicationCode = publicationcode;
_context.Artwork.Add(obj1);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Team.Any() || _context.Author.Any() || _context.Artwork.Any() || _context.ArtworkCode.Any())
{
return; // DB has been seeded
}
Team t0 = new Team(3, "John Deere");
Team t1 = new Team(1, "John Deere Luedtke");
Team t2 = new Team(2, "N.E.I.V.A.");
//Rafael Neves Poersch - Manager
Author a5 = new Author(5, "Rafael Neves Poersch", "RP46668", "*****@*****.**", t1);
User u5 = new User();
u5.Login = "******";
u5.Name = "Rafael Neves Poersch";
u5.Password = "******";
u5.OwnerId = 5;
u5.Admin = true;
u5.Id = 5;
//Ricardo dos Santos
Author a1 = new Author(1, "Ricardo dos Santos", "RS85424", "*****@*****.**", t1);
User u1 = new User();
u1.Login = "******";
u1.Name = "Ricardo dos Santos";
u1.Password = "******";
u1.OwnerId = 1;
u1.Admin = false;
u1.Id = 1;
//Lucas Rech
Author a2 = new Author(2, "Lucas Rech", "LR35023", "*****@*****.**", t1);
User u2 = new User();
u2.Login = "******";
u2.Name = "Lucas Rech";
u2.Password = "******";
u2.OwnerId = 2;
u2.Admin = false;
u2.Id = 2;
//Tassiane Strassburger
Author a3 = new Author(3, "Tassiane Strassburger", "TS95756", "*****@*****.**", t1);
User u3 = new User();
u3.Login = "******";
u3.Name = "Tassiane Strassburger";
u3.Password = "******";
u3.OwnerId = 3;
u3.Admin = false;
u3.Id = 3;
//Kaizan Kolbek
Author a4 = new Author(4, "Kaizan F Kolbek", "KK69021", "*****@*****.**", t1);
User u4 = new User();
u4.Login = "******";
u4.Name = "Kaizan F Kolbek";
u4.Password = "******";
u4.OwnerId = 4;
u4.Admin = false;
u4.Id = 4;
_context.Team.AddRange(t0, t1, t2);
_context.Author.AddRange(a1, a2, a3, a4, a5);
_context.User.AddRange(u1, u2, u3, u4, u5);
// Creating artworks...
string x = "BML";
int n = 999; //Total of artworks!!!
List <string> listOfArtworks = new List <string>();
int num = 0;
string number = num.ToString();
for (int i = 000001; i <= n; i++) // "i" represents the first parameter code to begin the range!
{
int id = i;
string q1code = number + i;
string code = q1code.ToString().PadLeft(6, '0');
if (code.Length > 6)
{
double codex = double.Parse(code);
code = codex.ToString();
}
string codexx = x + code;
string artwork = i + "," + codexx;
listOfArtworks.Add(artwork);
}
a1.LoadCodePack(listOfArtworks);
a2.LoadCodePack(listOfArtworks);
a3.LoadCodePack(listOfArtworks);
a4.LoadCodePack(listOfArtworks);
a5.LoadCodePack(listOfArtworks);
_context.SaveChanges();
var listOfArtworkJustCodes = listOfArtworks;
foreach (string objArtwork in listOfArtworkJustCodes)
{
var artworkWithCode = objArtwork;
string[] artwork = artworkWithCode.Split(',');
int artworkId = int.Parse(artwork[0]);
string artworkNumber = artwork[1];
ArtworkCode artworkCode = new ArtworkCode(artworkId, artworkNumber);
_context.ArtworkCode.Add(artworkCode);
}
_context.SaveChanges();
}
