[Route("DeleteUser")] //get customer and agent user //[FromBody] UsersView userView
public ActionResult <UsersView> deleteUser([FromBody] UsersView userView)
{
UserRoles userRole = _context.UserRoles.Where(obj => obj.UserId == userView.UserId).FirstOrDefault();
_context.Remove(userRole);
DistributorAgents distributorAgent = _context.DistributorAgents.Where(obj => obj.UserId == userView.UserId).FirstOrDefault();
_context.Remove(distributorAgent);
Users userbeing_deleted = _context.Users.Find(userView.UserId);
_context.Remove(userbeing_deleted);
_context.SaveChanges();
var data = (from u in _context.Users
join user_Role in _context.UserRoles on u.Id equals user_Role.UserId
join
roles in _context.Roles on user_Role.RoleId equals roles.Id
join
distributor_Agents in _context.DistributorAgents on u.Id equals distributor_Agents.UserId
where distributor_Agents.DistributorId == userView.DistId
select new { User = u, User_Role = roles }).ToList();
return(Ok(new
{
UserStatus = "DeleteSuccess",
usersList = data
}));
// return CreatedAtAction("GetUsers", new { id = users.Id }, users);
}
[Route("CreateUser")] //create customer and agent user //[FromBody] UsersView userView
public async Task <IActionResult> CreateUser([FromBody] UsersView userView)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
// int userId = _context.Users.Max(obj => obj.Id) + 1;
// int roleId= _context.Roles.Max(obj => obj.Id) + 1;
Users users = new Users();
users.FirstName = userView.FirstName;
users.LastName = userView.LastName;
users.Email = userView.Email;
users.Contact = userView.Contact;
users.Address = userView.Address;
users.Password = "******";
_context.Users.Add(users);
//Roles adminRole = new Roles();
//adminRole.Name = userView.RoleName;
//_context.Roles.Add(adminRole);
int roleId = _context.Roles.Where(obj => obj.Name == userView.RoleName).FirstOrDefault().Id;
await _context.SaveChangesAsync();
UserRoles userRole = new UserRoles();
userRole.UserId = users.Id;
userRole.RoleId = roleId;
_context.UserRoles.Add(userRole);
List <string> saleAgentPossibleList = new List <string>()
{
"sale agent", "saleagent",
};
//if (saleAgentPossibleList.Contains(userView.RoleName.ToLower()))
//{
DistributorAgents distributorAgents = new DistributorAgents();
distributorAgents.DistributorId = userView.DistId;
distributorAgents.UserId = users.Id;
_context.DistributorAgents.Add(distributorAgents);
//}
// await
await _context.SaveChangesAsync();
var data = (from u in _context.Users
join user_Role in _context.UserRoles on u.Id equals user_Role.UserId
join
roles in _context.Roles on user_Role.RoleId equals roles.Id
join
distributor_Agents in _context.DistributorAgents on u.Id equals distributor_Agents.UserId
where distributor_Agents.DistributorId == userView.DistId
select new { User = u, User_Role = roles }).ToList();
return(Ok(new
{
UserStatus = "UserRegisteredSuccess",
usersList = data
}));
// return CreatedAtAction("GetUsers", new { id = users.Id }, users);
}
public async Task <ActionResult <AgentCustomer> > getdistributorAgentwithCustomer(DistributorAgents distributorAgents)
{
var data = (from user in _context.Users
join userrole in _context.UserRoles on user.Id equals userrole.UserId
join role in _context.Roles on
userrole.RoleId equals role.Id
where role.Name == "sale agent"
join distagent in _context.DistributorAgents on user.Id equals distagent.UserId
where distagent.DistributorId == distributorAgents.DistributorId
join agentcus in _context.AgentCustomer on user.Id equals agentcus.SaleAgentId
join
agentordstat in _context.AgentOrderStatus on agentcus.Id equals agentordstat.AgentCustomerId
join tartype in _context.TargetStatusType on
agentordstat.AgentTargetStatusId equals tartype.Id
join ordertype in _context.OrderStatusType on agentordstat.OrderStatusId equals ordertype.Id
// join
// orderprod in _context.OrderProducts on agentordstat.Id equals orderprod.AgentOrderStatusId join invent in _context.Inventory on
// orderprod.InventoryId equals invent.Id join Prod in _context.Products on invent.ProductId equals Prod.Id
select new
{
agentObject = user,
customerObject = (from customer in _context.Users where customer.Id == agentcus.CustomerId select new { customerObject = customer }).FirstOrDefault(),
TargetType = tartype.Type,
OrderType = ordertype.OrderStatus,
ProductInventoryList = (from orderprod in _context.OrderProducts where agentordstat.Id == orderprod.AgentOrderStatusId join invent in
_context.Inventory on orderprod.InventoryId equals invent.Id join Prod in _context.Products on invent.ProductId equals Prod.Id
select new { productObj = Prod, inventoryObj = invent, orderProd = orderprod }).ToList(),
}
).ToList();
return(Ok(new { distributorAgentCustomerDetailStatus = "GetSuccess", distributorAgentCustomerDetailList = data }));
}
