public async Task addEmployee(MadeToMeasureContext context)
{
BusinessEntity b = new BusinessEntity();
// b.EntityAddress = address;
// b.EntityType = 3;
// context.BusinessEntity.Add(b);
await context.SaveChangesAsync();
}
public async Task addShop(MadeToMeasureContext context)
{
BusinessEntity b = new BusinessEntity();
b.EntityAddress = address;
b.EntityType = 1;
context.BusinessEntity.Add(b);
await context.SaveChangesAsync();
}
public async Task addShop(MadeToMeasureContext context, int shopcode, int warehousecode)
{
Madetomeasure.Data.Shop shop = new Madetomeasure.Data.Shop();
shop.ShopCode = shopcode;
shop.AssociatedWarehouseCode = warehousecode;
context.Shop.Add(shop);
await context.SaveChangesAsync();
}
public async Task add(MadeToMeasureContext context, int stitchingcode, int warehousecode)
{
Warehouse warehouse = new Warehouse();
warehouse.AssociatedStitchingUnitCode = stitchingcode;
warehouse.WarehouseCode = warehousecode;
context.Warehouse.Add(warehouse);
await context.SaveChangesAsync();
}
public async Task AddStunitEmployee(MadeToMeasureContext context, string name, int id, int duty)
{
StitchingUnitEmployee st = new StitchingUnitEmployee();
st.Name = name;
st.WarehouseId = id;
st.DepartmentId = duty;
// b.EntityAddress = address;
// ;/ b.EntityType = 3;
context.StitchingUnitEmployee.Add(st);
await context.SaveChangesAsync();
}
public async Task logProductionActivity(MadeToMeasureContext _context, int employeeid, int stitchingjodid, int progressstatus)
{
ProductionActivity p = new ProductionActivity();
p.StitchingUnitEmployeeId = employeeid;
p.TimeStamp = DateTime.Now;
p.StitchingJobId = stitchingjodid;
p.ProgressStatus = progressstatus;
_context.ProductionActivity.Add(p);
if (progressstatus == 5)
{
p.ProgressStatus = 6;
}
_context.ProductionActivity.Add(p);
await _context.SaveChangesAsync();
}
public async Task addemployeecom(MadeToMeasureContext context, string name, string id, DateTime date, string password, int works, int entitycod)
{
Users user = new Users();
user.WorksAt = works;
user.UserId = id;
user.UserType = entitycod;
user.Password = password;
user.JoiningDate = date;
user.Name = name;
// b.EntityAddress = address;
// ;/ b.EntityType = 3;
context.Users.Add(user);
await context.SaveChangesAsync();
}
public List <StitchingUnitEmployee> getEmployees(MadeToMeasureContext _context, int stitchingUnitId, int userid)
{
var dept = from d in _context.StitchingUnitDepartmentHead
where d.Id == userid
select d;
int departmentType = 0;
foreach (var x in dept)
{
departmentType = x.AssociatedDepartmentId;
}
return((from employee in _context.StitchingUnitEmployee
where employee.DepartmentId == departmentType && employee.WarehouseId == stitchingUnitId
select employee
).ToList());
}
public async Task addstdp(MadeToMeasureContext context, string name, string id, DateTime date, string password, int entitycode, int deprtmentcode)
{
Users user = new Users();
user.WorksAt = entitycode;
user.UserId = id;
user.UserType = 5;
user.Password = password;
user.JoiningDate = date;
user.Name = name;
context.Users.Add(user);
await context.SaveChangesAsync();
var a = from k in context.Users
where k.UserId == id
select k.Id;
int idd = 0;
// b.EntityAddress = address;
// ;/ b.EntityType = 3;
foreach (var b in a)
{
idd = (int)b;
StitchingUnitDepartmentHead sthead = new StitchingUnitDepartmentHead();
sthead.Id = idd;
sthead.AssociatedDepartmentId = deprtmentcode;
context.StitchingUnitDepartmentHead.Add(sthead);
}
await context.SaveChangesAsync();
}
public SelectShopOrder(MadeToMeasureContext context)
{
_context = context;
}
public AdminController(MadeToMeasureContext context)
{
_context = context;
}
public Gettablestitchingunitwarehouse(MadeToMeasureContext context)
{
_context = context;
}
public CustomerHistory(MadeToMeasureContext context)
{
_context = context;
}
public AccountController(MadeToMeasureContext dbContext)
{
db = dbContext;
}
public Gettablewarehouse(MadeToMeasureContext context)
{
_context = context;
}
public VendorListSave(MadeToMeasureContext dbContext)
{
db = dbContext;
}
public ProcessStitchingJob(MadeToMeasureContext dbContext)
{
db = dbContext;
}
public CustomerPendingOrders(MadeToMeasureContext context)
{
_context = context;
}
public StitchingJobContentRetrieval(MadeToMeasureContext dbContext)
{
db = dbContext;
}
public ShopOrdersRetrieval(MadeToMeasureContext dbContext)
{
db = dbContext;
}
public GetUserId(MadeToMeasureContext context)
{
_context = context;
}
public ItemManagement(MadeToMeasureContext dbContext)
{
db = dbContext;
}
public LoginVerification(MadeToMeasureContext dbContext, ISession session)
{
db = dbContext;
_session = session;
}
public WarehouseController(MadeToMeasureContext context)
{
db = context;
}
public CategoryManagement(MadeToMeasureContext dbContext)
{
db = dbContext;
}
public CustomerController(MadeToMeasureContext context)
{
_context = context;
}
public GetEntity(MadeToMeasureContext context)
{
_context = context;
}
public StitchingUnitDepartmentHeadController(MadeToMeasureContext context)
{
_context = context;
}
