/// <summary>
/// 입출고재고현황기록을 데이터베이스에 저장하고 재고현황수량에서 가감하여 재고현황을 반영한다.
/// </summary>
/// <param name="date"></param>
/// <param name="spec"></param>
/// <param name="count"></param>
/// <param name="seller"></param>
/// <param name="eep"></param>
/// <param name="warehouse"></param>
/// <param name="remark"></param>
public InOutStock Save(StockType type, DateTime date, Specification spec, int count, Seller seller, Employee eep, Warehouse warehouse, string remark)
{
_InOutStock.StockType = type;
_InOutStock.SpecificationUUID = spec.UUID;
_InOutStock.Date = date;
_InOutStock.ItemCount = count;
_InOutStock.EnterpriseUUID = seller.UUID;
_InOutStock.EmployeeUUID = eep.UUID;
_InOutStock.WarehouseUUID = warehouse.UUID;
_InOutStock.Remark = remark;
IIndexQuery<Inventory, string> queryResult = null;
using (var db = DatabaseDirector.GetDbInstance())
{
queryResult = db.Table<Inventory>().IndexQueryByKey("SpecificationUUID", spec.UUID);
}
Inventory stockItem = queryResult.Count() == 0 ?
new Inventory() { SpecificationUUID = spec.UUID, WarehouseUUID = warehouse.UUID } : queryResult.ToList().First();
switch (_InOutStock.StockType)
{
case StockType.IN: stockItem.ItemCount += count; break;
case StockType.OUT: stockItem.ItemCount -= count; break;
}
stockItem.Save<Inventory>();
return _InOutStock.Save<InOutStock>();
}
static void Main(string[] args)
{
//Base class
UserController userController = new UserController();
userController.Login("John.Smith", "secret");
//userController.SetPermissions("John.Smith");
//inherits from userController so gets its methods
AdminController adminController = new AdminController();
adminController.Login("Jane.Doe", "pass123");
adminController.SetPermissions("Jane.Doe");
//inherits from adminController so get its methods and all the methods inherited from userController
AdminController superAdminController = new SuperAdminController();
superAdminController.Login("Joe.Bloggs", "password");
superAdminController.SetPermissions("Joe.Bloggs");
Admin admin = new Admin();
admin.name = "Jane.Doe";
admin.role = "admin";
Seller seller = new Seller();
seller.name = "John.Smith";
seller.role = "Seller";
//AbstractUser user = new AbstractUser(); // Oooops, no can do!
//IDatabaseConnection connection1 = new IDatabaseConnection(); // Not possible!
IDatabaseConnection connection2 = new MicrosoftDbConnection();
Console.ReadLine();
}
private void setEvents()
{
sell = new Seller();
this.sell.Sprzedano += new TraderDelegate(sell.SprzedanoAkcje);
this.sell.Sprzedano += new TraderDelegate(sell.TakieTamZdarzenie);
this.sell.Kupiono += new TraderDelegate(sell.KupionoAkcje);
}
public static int Add(Seller item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("Seller_AddItem"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.DateTime).Value = item.Name;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public ActionResult AddSeller()
{
MembershipCreateStatus mcs = MembershipCreateStatus.InvalidUserName;
if (Request.Form["Username"].Length > 2
&& Request.Form["Password"].Length > 7
&& Request.Form["Name"].Length > 0
&& Request.Form["Surname"].Length > 0)
Membership.CreateUser(Request.Form["Username"], Request.Form["Password"], Request.Form["Username"]+"@empty", "Empty question", "Empty answer", true, out mcs);
if (mcs != MembershipCreateStatus.Success)
throw new ApplicationException("Error");
else
{
// Seller RoleId : 818a7a14-269d-4115-9f26-ac09a92f0b50
Guid guid = new Guid(Request.Form["role"]);
using (MembershipDBEntities context = new MembershipDBEntities())
{
string username = Request.Form["Username"];
var user = (from u in context.aspnet_Users
where u.UserName == username
select u).First();
var role = (from r in context.aspnet_Roles
where r.RoleId == guid
select r).First();
user.aspnet_Roles.Add(role);
guid = user.UserId;
context.SaveChanges();
}
using (AppDBEntities context = new AppDBEntities())
{
Seller seller = new Seller();
seller.Id_user = guid;
seller.Name = Request.Form["Name"];
seller.Surname = Request.Form["Surname"];
seller.Id_branch = int.Parse(Request.Form["branch"]);
context.Sellers.Add(seller);
context.SaveChanges();
}
}
return Content("OK");
}
public Sale(string name, Lot lot, Series series, Seller seller, double startPrice,
double increment, TimeSpan duration, Category category)
{
Name = name;
Number = 0;
Lot = lot;
Series = series;
StartPrice = startPrice;
Increment = increment;
Seller = seller;
Duration = duration;
Category = category;
}
public ActionResult Edit(Seller seller)
{
//NOTE: This is for HTTP post
//Get the correct seller from db
Seller dbSeller = iService.GetSellerById(seller.Id);
//Assign only relevant values since rest are null
dbSeller.Name = seller.Name;
dbSeller.Address = seller.Address;
dbSeller.ZipCode = seller.ZipCode;
dbSeller.Phone = seller.Phone;
dbSeller.Mobile = seller.Mobile;
dbSeller.Email = seller.Email;
//Update seller via service
iService.UpdateSellerSingle(dbSeller);
return View(seller);
}
protected void btRegister_Click(object sender, EventArgs e)
{
Seller u1 = new Seller();
u1.first_name = txtFirstName.Text;
u1.last_name = txtLastName.Text;
u1.gender = rbGender.SelectedValue;
u1.dob = txtDOB.Text;
u1.address = txtStreetAddress.Text;
u1.city = txtCity.Text;
u1.pin = txtPin.Text;
u1.phone = txtMobile.Text;
u1.email = txtEmail.Text;
u1.username = txtUsername.Text;
u1.password = txtPassword.Text;
u1.age = txtAge.Text;
if (u1.SaveData() == true)
{
Response.Redirect("registrationDone.aspx");
}
else
lblSqlError.Text = u1.error;
}
public static List<Seller> GetMacAll()
{
List<Seller> items = new List<Seller>();
using (StoredProcedure sp = new StoredProcedure("MacSeller_GetAll"))
{
var r = sp.ExecuteReader();
if (r != null)
{
while (r.Read())
{
Seller item = new Seller
{
ID = Convert.ToInt32(r["ID"]),
Name = Convert.ToString(r["Name"])
};
items.Add(item);
}
}
}
return items;
}
public string AddSeller([Bind(Include = "SellerName")] Seller seller)
{
return(DatabaseQueries.AddSeller(seller.SellerName, Request.Form["SellingPointTitle"])
? "Success"
: "Error");
}
private static void procedure()
{
uint amount = askAmount(); //you can't have a negative amount of sellers, so lets make space for a lot of them
string docPath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); //using synchronous stream to write to a textfile in the documents folder
StreamWriter outputFile = new StreamWriter(Path.Combine(docPath, "result.txt")); //creates a new textfile in the documents folder to write to. The file is called "result.txt"
Seller[] sellers = new Seller[amount];
Console.WriteLine("\n\n");
for (int j = 0; j < amount; j++)
{
Console.Write("Vad heter säljaren? ");
string fullName = Console.ReadLine();
Console.Write("Vilket distrikt arbetar säljaren i? ");
string district = Console.ReadLine();
uint pNum = askPNum(sellers);;
uint articles = askArticles();
sellers[j] = new Seller(fullName, district, articles, pNum);
Console.WriteLine("\n");
}
inSort(sellers);//sorting the sellers by articles sold, increasing order.
uint[] levels = { 50, 99, 199 };
int iter = 0;
uint currentLevel = levels[iter];
Console.WriteLine("NAMN | PERSONNUMMER | DISTRIKT | ARTIKLAR");
outputFile.WriteLine("NAMN | PERSONNUMMER | DISTRIKT | ARTIKLAR");
int sellerCount = 0;
for (int i = 0; i < sellers.Length; i++)//loop thourh the sellers array, count the amount of sellers on each level and print them out
{
if (sellers[i].getArticles() < currentLevel)
{
sellerCount++;
}
else
{
Console.WriteLine(sellerCount + " säljare har uppnått nivå " + iter + "\n");
outputFile.WriteLine(sellerCount + " säljare har uppnått nivå " + iter + "\n");//writing the same information to the textfile in /documents
sellerCount = 1;
}
while (sellers[i].getArticles() > currentLevel)
{
iter++;
if (iter >= levels.Length)
{
break; //if the level is currently the max level, we can't increase it further
}
currentLevel = levels[iter];
}
Console.WriteLine(sellers[i].ToString());
outputFile.WriteLine(sellers[i].ToString());
}
Console.WriteLine(sellerCount + " säljare har uppnått nivå " + iter + "\n"); //this is to print the last level
outputFile.WriteLine(sellerCount + " säljare har uppnått nivå " + iter + "\n"); //writing the same information to the textfile in /documents
Console.WriteLine("\n\nNivå 0: Färre än 50 artiklar sålda\n" +
"Nivå 1: Mellan 50 och 99 artiklar sålda\n" +
"Nivå 2: Mellan 100 och 199 artiklar sålda\n" +
"Nivå 3: Fler än 199 artiklar sålda");//Just some information about the levels printed out
outputFile.WriteLine("\n\nNivå 0: Färre än 50 artiklar sålda\n" +
"Nivå 1: Mellan 50 och 99 artiklar sålda\n" +
"Nivå 2: Mellan 100 och 199 artiklar sålda\n" +
"Nivå 3: Fler än 199 artiklar sålda"); //writing the same information to the textfile in /documents
outputFile.Close(); //closes the textfile with the information inside
}
public Offer()
{
this.sellerField = new Seller();
}
public IActionResult Create(Seller seller)
{
_sellerService.Insert(seller);
return(RedirectToAction(nameof(Index)));
}
public async Task InsertAsync(Seller obj)
{
_context.Add(obj);
await _context.SaveChangesAsync();
}
public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return;
}
Department d1 = new Department {
Name = "Computers"
};
Department d2 = new Department {
Name = "Electronics"
};
Department d3 = new Department {
Name = "Fashion"
};
Department d4 = new Department {
Name = "Books"
};
Seller s1 = new Seller {
Name = "Bob Brown", Email = "*****@*****.**", BirthDate = new DateTime(1998, 4, 21), BaseSalary = 1000.0, Department = d1
};
Seller s2 = new Seller {
Name = "Maria Green", Email = "*****@*****.**", BirthDate = new DateTime(1979, 12, 31), BaseSalary = 3500.0, Department = d2
};
Seller s3 = new Seller {
Name = "Alex Grey", Email = "*****@*****.**", BirthDate = new DateTime(1988, 1, 15), BaseSalary = 2200.0, Department = d1
};
Seller s4 = new Seller {
Name = "Martha Red", Email = "*****@*****.**", BirthDate = new DateTime(1993, 11, 30), BaseSalary = 3000.0, Department = d4
};
Seller s5 = new Seller {
Name = "Donald Blue", Email = "*****@*****.**", BirthDate = new DateTime(2000, 1, 9), BaseSalary = 4000.0, Department = d3
};
Seller s6 = new Seller {
Name = "Alex Pink", Email = "*****@*****.**", BirthDate = new DateTime(1997, 3, 4), BaseSalary = 3000.0, Department = d2
};
SalesRecord r1 = new SalesRecord {
Date = new DateTime(2018, 09, 25), Amount = 11000.0, Status = SaleStatus.Billed, Seller = s1
};
SalesRecord r2 = new SalesRecord {
Date = new DateTime(2018, 09, 4), Amount = 7000.0, Status = SaleStatus.Billed, Seller = s5
};
SalesRecord r3 = new SalesRecord {
Date = new DateTime(2018, 09, 13), Amount = 4000.0, Status = SaleStatus.Canceled, Seller = s4
};
SalesRecord r4 = new SalesRecord {
Date = new DateTime(2018, 09, 1), Amount = 8000.0, Status = SaleStatus.Billed, Seller = s1
};
SalesRecord r5 = new SalesRecord {
Date = new DateTime(2018, 09, 21), Amount = 3000.0, Status = SaleStatus.Billed, Seller = s3
};
SalesRecord r6 = new SalesRecord {
Date = new DateTime(2018, 09, 15), Amount = 2000.0, Status = SaleStatus.Billed, Seller = s1
};
SalesRecord r7 = new SalesRecord {
Date = new DateTime(2018, 09, 28), Amount = 13000.0, Status = SaleStatus.Billed, Seller = s2
};
SalesRecord r8 = new SalesRecord {
Date = new DateTime(2018, 09, 11), Amount = 4000.0, Status = SaleStatus.Billed, Seller = s4
};
SalesRecord r9 = new SalesRecord {
Date = new DateTime(2018, 09, 14), Amount = 11000.0, Status = SaleStatus.Pending, Seller = s6
};
SalesRecord r10 = new SalesRecord {
Date = new DateTime(2018, 09, 7), Amount = 9000.0, Status = SaleStatus.Billed, Seller = s6
};
SalesRecord r11 = new SalesRecord {
Date = new DateTime(2018, 09, 13), Amount = 6000.0, Status = SaleStatus.Billed, Seller = s2
};
SalesRecord r12 = new SalesRecord {
Date = new DateTime(2018, 09, 25), Amount = 7000.0, Status = SaleStatus.Pending, Seller = s3
};
SalesRecord r13 = new SalesRecord {
Date = new DateTime(2018, 09, 29), Amount = 10000.0, Status = SaleStatus.Billed, Seller = s4
};
SalesRecord r14 = new SalesRecord {
Date = new DateTime(2018, 09, 4), Amount = 3000.0, Status = SaleStatus.Billed, Seller = s5
};
SalesRecord r15 = new SalesRecord {
Date = new DateTime(2018, 09, 12), Amount = 4000.0, Status = SaleStatus.Billed, Seller = s1
};
SalesRecord r16 = new SalesRecord {
Date = new DateTime(2018, 10, 5), Amount = 2000.0, Status = SaleStatus.Billed, Seller = s4
};
SalesRecord r17 = new SalesRecord {
Date = new DateTime(2018, 10, 1), Amount = 12000.0, Status = SaleStatus.Billed, Seller = s1
};
SalesRecord r18 = new SalesRecord {
Date = new DateTime(2018, 10, 24), Amount = 6000.0, Status = SaleStatus.Billed, Seller = s3
};
SalesRecord r19 = new SalesRecord {
Date = new DateTime(2018, 10, 22), Amount = 8000.0, Status = SaleStatus.Billed, Seller = s5
};
SalesRecord r20 = new SalesRecord {
Date = new DateTime(2018, 10, 15), Amount = 8000.0, Status = SaleStatus.Billed, Seller = s6
};
SalesRecord r21 = new SalesRecord {
Date = new DateTime(2018, 10, 17), Amount = 9000.0, Status = SaleStatus.Billed, Seller = s2
};
SalesRecord r22 = new SalesRecord {
Date = new DateTime(2018, 10, 24), Amount = 4000.0, Status = SaleStatus.Billed, Seller = s4
};
SalesRecord r23 = new SalesRecord {
Date = new DateTime(2018, 10, 19), Amount = 11000.0, Status = SaleStatus.Canceled, Seller = s2
};
SalesRecord r24 = new SalesRecord {
Date = new DateTime(2018, 10, 12), Amount = 8000.0, Status = SaleStatus.Billed, Seller = s5
};
SalesRecord r25 = new SalesRecord {
Date = new DateTime(2018, 10, 31), Amount = 7000.0, Status = SaleStatus.Billed, Seller = s3
};
SalesRecord r26 = new SalesRecord {
Date = new DateTime(2018, 10, 6), Amount = 5000.0, Status = SaleStatus.Billed, Seller = s4
};
SalesRecord r27 = new SalesRecord {
Date = new DateTime(2018, 10, 13), Amount = 9000.0, Status = SaleStatus.Pending, Seller = s1
};
SalesRecord r28 = new SalesRecord {
Date = new DateTime(2018, 10, 7), Amount = 4000.0, Status = SaleStatus.Billed, Seller = s3
};
SalesRecord r29 = new SalesRecord {
Date = new DateTime(2018, 10, 23), Amount = 12000.0, Status = SaleStatus.Billed, Seller = s5
};
SalesRecord r30 = new SalesRecord {
Date = new DateTime(2018, 10, 12), Amount = 5000.0, Status = SaleStatus.Billed, Seller = s2
};
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any()) //testa se existe algum registro
{
return; //cortar a execução "DB has been seeded
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
Seller s6 = new Seller(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2);
SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4);
SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3);
SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4);
SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3);
SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5);
SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2);
_context.Department.AddRange(d1, d2, d3, d4); //adicionando os objetos no banco de dados
//AddRange permite adicionar vários objetos de uma vez.
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
);
_context.SaveChanges(); //salva e confirma as alterações no banco de dados.
}
public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return;
}
Department d1 = new Department(1, "Computadores");
Department d2 = new Department(2, "Eletrônicos");
Department d3 = new Department(3, "Filmes");
Department d4 = new Department(4, "Livros");
Seller s1 = new Seller(1, "Carlos Alberto", "*****@*****.**", new DateTime(1988, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Maria Santos", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Seller s3 = new Seller(3, "Pedro Junior", "*****@*****.**", new DateTime(1990, 1, 15), 2200.0, d1);
Seller s4 = new Seller(4, "Marta Lima", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
Seller s5 = new Seller(5, "Davi Correia", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
Seller s6 = new Seller(6, "Roberto Silva", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2);
SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4);
SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3);
SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4);
SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3);
SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5);
SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
);
_context.SaveChanges();
}
public ProductSeller(Seller seller)
{
Id = seller.Id;
Username = seller.Name;
}
[ValidateAntiForgeryToken] // notacao p previnir ataques CSRF (dados maliciosos na autenticação)
public IActionResult Create(Seller seller)
{
_sellerService.Insert(seller);
// retorna para a listagem de vendedores após ciar um novo
return(RedirectToAction(nameof(Index)));
}
public IActionResult Create(Seller obj)
{
_sellerService.Insert(obj);
return(RedirectToAction("Index"));
}
void addParameters(Seller ent)
{
AddParametersToSqlCommand(ent, ref sc);
}
void AddParametersToSqlCommand(Seller ent, ref SqlCommand sc)
{
sc.Parameters.Add("@seller", ent.SellerName);
}
private void Button1_Click(object sender, EventArgs e)
{
Seller = Seller ?? new Seller();
Seller.Name = textBox1.Text;
Close();
}
public IEnumerable<Sale> GetSuccessfulSales(Seller seller)
{
return _sales.Where(s => s.IsSaled && s.Seller == seller);
}
public void addSellItem(Seller sell)
{
listSell.Add(sell);
}
public SellerForm(Seller seller) : this()
{
Seller = seller ?? new Seller();
textBox1.Text = Seller.Name;
}
public void Insert(Seller obj)
{
_context.Add(obj);
_context.SaveChanges();
}
private void userAcButtonLogin_Click(object sender, EventArgs e)
{
string username = userAcTextBoxMail.Text;
string password = userAcTextBoxPassw.Text;
Seller tmpSeller = new Seller();
tmpSeller = ctrl.getSeller(username);
//Rätt användarnamn men fel lösenord
if (tmpSeller.mail == username && tmpSeller.password != password)
{
userAcLabelMessageBox.ForeColor = System.Drawing.Color.Red; //Röd färg för negativ feedback
userAcLabelMessageBox.Text = "Wrong Password";
}
//Rätt användarnamn och lösenord
else if (tmpSeller.mail == username && tmpSeller.password == password)
{
userAcLabelMessageBox.ForeColor = System.Drawing.Color.Green; //Grön färg för positiv feedback
userAcLabelMessageBox.Text = "ACCESS GRANTED";
//Textrutor visas
userAcTextBoxFname.Visible = true;
userAcTextBoxLname.Visible = true;
userAcTextBoxPnbr.Visible = true;
userAcTextBoxCity.Visible = true;
//Textrutor görs ej redigerbara
userAcTextBoxMail.Enabled = false;
userAcTextBoxPassw.Enabled = false;
userAcTextBoxFname.Enabled = false;
userAcTextBoxLname.Enabled = false;
userAcTextBoxPnbr.Enabled = false;
userAcTextBoxCity.Enabled = false;
//Labels visas
userAcLabelFname.Visible = true;
userAcLabelLname.Visible = true;
userAcLabelPnbr.Visible = true;
userAcLabelCity.Visible = true;
//Knappar och annat visas
userAcButtonEditInfo.Visible = true;
userAcButtonRemoveAc.Visible = true;
userAcLabelAds.Visible = true;
userAcFlowLayoutPanel.Visible = true;
userAcButtonCreateAd.Visible = true;
userAcButtonRemoveAd.Visible = true;
userAcButtonRefresh.Visible = true;
userAcButtonLogout.Visible = true;
userAcButtonCreateUsr.Visible = false;
userAcButtonLogin.Visible = false;
//Textrutor fylls i med tmpSellers uppgifter
userAcTextBoxFname.Text = tmpSeller.fName;
userAcTextBoxLname.Text = tmpSeller.lName;
userAcTextBoxPnbr.Text = tmpSeller.phoneNbr;
userAcTextBoxCity.Text = tmpSeller.city;
}
//Användarnamn finns inte
else
{
userAcLabelMessageBox.ForeColor = System.Drawing.Color.Red; //Röd färg för negativ feedback
userAcLabelMessageBox.Text = "User does not exist";
}
}
public void Insert(Seller obj)
{
obj.Departament = _context.Departament.First();
_context.Add(obj);
_context.SaveChanges();
}
public GetSellerResponse(Seller seller)
{
this.Seller = seller;
}
public void AddSeller(Seller seller)
{
if (!_sellers.Any(s => s.Login == seller.Login))
{
_sellers.Add(seller);
}
}
public void Seed()
{
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; // Banco já foi criado e populado
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
Seller s6 = new Seller(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2);
SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4);
SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3);
SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4);
SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3);
SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5);
SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
);
_context.SaveChanges();
}
public void Insert(Seller seller)
{
_context.Seller.Add(seller);
_context.SaveChanges();
}
public async Task InsertAsync(Seller obj)
{
//obj.Department = _context.Department.First();
_context.Add(obj);
await _context.SaveChangesAsync();
}
public void EditProfile(Seller obj)
{
_context.Update(obj);
_context.SaveChanges();
}
public IActionResult Create(Seller seller)
{
_sellerService.Insert(seller); //Uma vez inserido o seller no banco de dados, a requisição será redirecionada para a ação Index, implementação abaixo
return(RedirectToAction(nameof(Index)));
}
public SellerFormViewModel(List <Departments> depto, Seller seller) : this(depto) {
this.Seller = seller;
}
public BasketItem()
{
this.productField = new Product();
this.sellerField = new Seller();
}
public void AddSaller(Seller seller)
{
Sellers.Add(seller);
}
public async Task InsertAsync(Seller obj)
{
obj.Id = _context.Seller.Last().Id + 1; // gambiarra, tem que arrumar!
_context.Add(obj);
await _context.SaveChangesAsync();
}
public async Task InsertAsync(Seller obj)
{
_context.Add(obj); //Adiciona o as informações do formulário no banco
await _context.SaveChangesAsync(); //Salva as alterações no banco
}
public void Seed() //método que vai servir para popular a base
{
if (_context.Department.Any() ||
_context.Seller.Any() || //condição que vai testar e conferir se já tem algum registro na base
_context.SalesRecord.Any())
{
return; // DB já foi populado
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "pessoa1", "*****@*****.**", new DateTime(1998, 5, 21), 1000.0, d1);
Seller s2 = new Seller(2, "pessoa2", "*****@*****.**", new DateTime(1998, 5, 21), 1000.0, d2);
Seller s3 = new Seller(3, "pessoa3", "*****@*****.**", new DateTime(1998, 5, 21), 1000.0, d1);
Seller s4 = new Seller(4, "pessoa4", "*****@*****.**", new DateTime(1998, 5, 21), 1000.0, d4);
Seller s5 = new Seller(5, "pessoa5", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d3);
Seller s6 = new Seller(6, "pessoa6", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d2);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2);
SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4);
SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3);
SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4);
SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3);
SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5);
SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30);
_context.SaveChanges(); //salva e confirma as alterações na base de dados
}
//obs no lugar de Void é posto "Task"
public async Task InsertAsync(Seller obj)
{
_context.Add(obj);
await _context.SaveChangesAsync(); //por ser um async é necessario usar SaveChangesAsync().
}
