private ClientsViewModel MapListOfClientsToListOfClientsViewModel(List <TimeSheet.Models.Client> clients, char?firstLetterOfSearch, IEnumerable <Country> countries, ClientViewModel clientVM, Guid idOfUpdatedClient)
{
var clientsVM = new ClientsViewModel
{
ModelHasErrors = false,
Clients = new List <ClientViewModel>(),
FilterViewModel = new FilterViewModel {
ActionName = "Index", ControllerName = "Clients", Title = "Create new client"
}
};
clientsVM.NewClient = clientVM ?? new ClientViewModel();
clientsVM.NewClient.Countries = ReturnCountries(Guid.Empty, countries);
SettingStateForButtons(clientsVM.FilterViewModel.Buttons, firstLetterOfSearch);
foreach (var client in clients)
{
clientsVM.Clients.Add(MapClientToClientViewModel(client, countries, idOfUpdatedClient));
}
clientsVM.MenuItemName = _menuItemName;
return(clientsVM);
}
public IActionResult Members()
{
ViewBag.CurrentChoice = ControllerContext.RouteData.Values["action"].ToString();
var DBmembers = _userRepository.Users.Where(u => (u.UserType == 2 || u.UserType == 3) && u.IsActive == true);
var members = new List <ClientsViewModel>();
foreach (var user in DBmembers)
{
var userModel = new ClientsViewModel()
{
Id = user.Id,
Username = _userRepository.GetUsername(user.ExtId),
Name = _userRepository.GetName(user.Id),
Email = _userRepository.GetEmail(user.ExtId),
NumberOfOrders = user.TransactionOwner.Where(t => t.IsProcessed == 1 && t.Type == 2).Count(),
UserType = user.UserType
};
members.Add(userModel);
}
var model = new ClientsView()
{
Clients = members
.OrderBy(u => u.UserType)
.ThenByDescending(u => u.NumberOfOrders)
.ToList()
};
return(View(model));
}
public async Task <IActionResult> Edit(int id, [Bind("ID,FirstName,LastName,ClientEmail,Street,Town,PostalCode,Voivodeship,Country, ownerID")] ClientsViewModel client)
{
if (id != client.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(ClientMapper.MapViewToClient(client));
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ClientExists(client.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(client));
}
public bool AddClient(int productOwnerId, ClientsViewModel client)
{
bool success = false;
int count = this._context
.Client
.Where(r => r.ProductOwnerId == productOwnerId && r.CompanyName.ToLower() == client.CompanyName.ToLower())
.Count();
if (count == 0)
{
success = true;
Client theClient = new Client
{
CompanyName = client.CompanyName,
TaxId = client.TaxId,
AddressLine1 = client.AddressLine1,
City = client.City,
State = client.State,
Zip = client.Zip,
ProductOwnerId = productOwnerId,
CurrentUser = client.CurrentUser
};
this._context.Client.Add(theClient);
this._context.SaveChanges();
}
return(success);
}
public ActionResult Save(ClientsViewModel form)
{
System.Threading.Thread.Sleep(2500);
if (!ModelState.IsValid)
{
return(View(nameof(Index), form));
}
using (var context = new SalesEntities())
{
if (form.Id != 0)
{
var clientToUpdate = context.Clients.SingleOrDefault(e => e.Id == form.Id);
clientToUpdate.Email = form.Email;
clientToUpdate.FirstName = form.FirstName;
clientToUpdate.LastName = form.LastName;
clientToUpdate.Discount = form.Discount;
}
else
{
Clients entity = new Clients(form);
context.Clients.Add(entity);
}
context.SaveChanges();
}
TempData["Success"] = true;
return(Redirect(nameof(Index)));
}
private void btnClient_Click(object sender, RoutedEventArgs e)
{
if (dataGrid.SelectedItem != null)
{
viewM = this.Main.DataContext as ReservationsViewModel;
ClientsViewModel cli = new ClientsViewModel(viewM.model);
cli.SelectedData = (dataGrid.SelectedItem as Reservations).Clients;
ClientInsertData view = new ClientInsertData("MOD", cli.SelectedData, cli);
view.ShowDialog();
if (view.Msg == "OK")
{
MessageBox.Show("Opération effectuée avec succès", "Clients", MessageBoxButton.OK, MessageBoxImage.Information);
viewM.Refresh();
}
else if (view.Msg == "Error")
{
MessageBox.Show(" Echec Opération ", "Clients", MessageBoxButton.OK, MessageBoxImage.Warning);
viewM.Refresh();
}
else
{
viewM.Refresh();
}
}
}
//-----------------------------Add Edit----------------------------
public ActionResult AddEdit(int CustID)
{
LaunSysDBEntities db = new LaunSysDBEntities();
List <tb_Titles> TitleList = db.tb_Titles.ToList();
ViewBag.VTitleLists = new SelectList(TitleList, "TitleID", "Title");
List <tb_Gender> GenderList = db.tb_Gender.ToList();
ViewBag.VGenderLists = new SelectList(GenderList, "GenderID", "Gendername");
ClientsViewModel Model = new ClientsViewModel();
if (CustID > 0)
{
tb_Customers Cust = db.tb_Customers.SingleOrDefault(x => x.CustID == CustID && x.IsNotActive == false);
Model.CustID = Cust.CustID;
Model.TitleID = Cust.TitleID;
Model.SurName = Cust.SurName;
Model.OtherNames = Cust.OtherNames;
Model.GenderID = Cust.GenderID;
Model.Cust_Address = Cust.Cust_Address;
Model.Phone = Cust.Phone;
Model.Email = Cust.Email;
Model.CreatedDate = Cust.CreatedDate;
}
return(PartialView("AddEditViewPartialView", Model));
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
try
{
viewM = this.Main.DataContext as ClientsViewModel;
viewM.SelectedData = new Clients();
InsertData view = new InsertData("AJOUT", viewM.SelectedData, viewM);
view.ShowDialog();
if (view.Msg == "OK")
{
MessageBox.Show("Opération effectuée avec succès", "Clients", MessageBoxButton.OK, MessageBoxImage.Information);
viewM.Refresh();
}
else if (view.Msg == "Error")
{
MessageBox.Show(" Echec Opération ", "Clients ", MessageBoxButton.OK, MessageBoxImage.Warning);
viewM.Refresh();
}
else
{
viewM.Refresh();
}
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Clients", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
public ActionResult Edit(ClientsViewModel model)
{
var client = _unitOfWork.RepositoryFor <Clients, int>().Get(model.ClientsID);
Mapper.Map(model, client);
if (TryUpdateModel(client))
{
try
{
if (ModelState.IsValid)
{
_unitOfWork.RepositoryFor <Clients, int>().Update(client);
_unitOfWork.Commit();
// return RedirectToAction("Details/" + model.ClientsID);
return(RedirectToRoute(new { controller = "Clients", action = "Details", id = model.ClientsID }));
}
}
catch (DataException)
{
throw;
}
}
return(View(model));
}
// GET: Users
public ActionResult Index(int id = 0)
{
ViewBag.Header = "Lista de Clientes";
if (TempData.ContainsKey("Success"))
{
TempData.Remove("Success");
ViewBag.Success = true;
}
ClientsViewModel clientsViewModel = null;
if (id != 0)
{
using (var context = new SalesEntities())
{
var resultClient = context.Clients.SingleOrDefault(e => e.Id == id);
clientsViewModel = new ClientsViewModel(resultClient);
}
}
else
{
clientsViewModel = new ClientsViewModel();
}
return(View(clientsViewModel));
}
public IActionResult Index()
{
ClientsViewModel viewModel = new ClientsViewModel
{
ClientList = new List <SelectListItem>()
};
//getting all orders from service
var ordersDTO = _orderService.GetAllOrders();
List <int> ids = new List <int>();
//find all clients
foreach (var order in ordersDTO.OrdersList)
{
if (!ids.Contains(order.ClientId))
{
ids.Add(order.ClientId);
}
}
//add client list to ViewModel
foreach (var id in ids)
{
viewModel.ClientList.Add(new SelectListItem {
Text = id.ToString(), Value = id.ToString()
});
}
return(View(viewModel));
}
public InsertData(string etat, Clients ele, ClientsViewModel view)
{
InitializeComponent();
this.DataContext = viewVM = view;
Etat = etat;
if (etat == "AJOUT")
{
this.Title = "Enregistrement d'un Quartier";
}
else
{
this.Title = "Modification d'un Quartier";
if (ele.Sexe != null)
{
if (ele.Sexe == "M")
{
rdMasc.IsChecked = true;
}
else if (ele.Sexe == "F")
{
rdFem.IsChecked = true;
}
}
}
}
public IActionResult Grid(int payeeclassId)
{
var clients = (from c in _context.Clients.AsNoTracking()
.Include(u => u.Country)
.Include(o => o.Occupation)
orderby c.LastName
select new
{
ID = c.ID.ToString(),
c.LastName,
c.FirstName,
Gender = c.Gender.ToString(),
c.BirthDate,
c.IDNumber,
Country = c.Country.Name,
Occupation = c.Occupation.Name,
c.Payable
}).ToList();
ClientsViewModel viewModel = new ClientsViewModel
{
Clients = clients,
PayeeClassID = payeeclassId
};
return(View(viewModel));
}
public ActionResult AddClient(ClientsViewModel client)
{
if (client != null && ModelState.IsValid)
{
var loggedUser = this._userManager.Users.Where(r => r.UserName == User.Identity.Name).FirstOrDefault();
client.CurrentUser = loggedUser.UserName;
bool success = this._databaseService.AddClient(loggedUser.ProductOwnerId, client);
if (!success)
{
ModelState.AddModelError("CompanyName", "Client Name already exists.");
return(this.GetViewResult(client));
}
else
{
IList <ClientsViewModel> model = this._databaseService.GetClients(loggedUser.ProductOwnerId);
return(this.Json(
new
{
Success = true,
Message = "Saved Successfully",
Html = this.RenderPartialViewToString("_ClientList", model),
Count = model.Count
}));
}
}
else
{
return(this.GetViewResult(client));
}
}
public void ClientsClick(object sender, RoutedEventArgs e)
{
Clients view = new Clients();
ClientsViewModel viewModel = new ClientsViewModel();
view.DataContext = viewModel;
view.ShowDialog();
}
public async Task <ClientsViewModel> CreateClient(ClientsViewModel model)
{
_context.Add(model);
await _context.SaveChangesAsync();
return(model);
}
public async Task <ClientsViewModel> UpdateClient(ClientsViewModel model)
{
_context.Clients.Update(model);
await _context.SaveChangesAsync();
return(model);
}
// to activate Authorization = [AuthorizeRoles(admin,accountant)]
// to add default route = [Route("x/x/{parameter 1}/{parameter 2}")]
// to pass parameter by exception = public ActionResult Index( string Id, ClientsViewModel Model)
public ActionResult Index(ClientsViewModel Model)
{
try
{
//if (ModelState.IsValid == true)
//{
LaunSysDBEntities db = new LaunSysDBEntities();
//------------------------To populate the drop down lists---------------------------
List <tb_Titles> TitleList = db.tb_Titles.ToList();
ViewBag.VTitleLists = new SelectList(TitleList, "TitleID", "Title");
List <tb_Gender> GenderList = db.tb_Gender.ToList();
ViewBag.VGenderLists = new SelectList(GenderList, "GenderID", "Gendername");
//----------------------------------------------------------------------------------
if (Model.CustID > 0)
{
//UPDATE EXISTING RECORD
tb_Customers Clients = db.tb_Customers.SingleOrDefault(x => x.CustID == Model.CustID && x.IsNotActive == false);
Clients.TitleID = Model.TitleID;
Clients.SurName = Model.SurName;
Clients.OtherNames = Model.OtherNames;
Clients.GenderID = Model.GenderID;
Clients.Cust_Address = Model.Cust_Address;
Clients.Phone = Model.Phone;
Clients.Email = Model.Email;
Clients.CreatedDate = Model.CreatedDate;
db.SaveChanges();
}
else
{
//INSERT NEW RECORD
tb_Customers Clients = new tb_Customers();
Clients.TitleID = Model.TitleID;
Clients.SurName = Model.SurName;
Clients.OtherNames = Model.OtherNames;
Clients.GenderID = Model.GenderID;
Clients.Cust_Address = Model.Cust_Address;
Clients.Phone = Model.Phone;
Clients.Email = Model.Email;
Clients.CreatedDate = Model.CreatedDate;
Clients.IsNotActive = false;
db.tb_Customers.Add(Clients);
db.SaveChanges();
}
return(View(Model));
//}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// The service entry.
/// </summary>
/// <returns>
/// The <see cref="ActionResult"/>.
/// </returns>
public ActionResult ServiceEntry()
{
ClientsViewModel clientlist = new ClientsViewModel {
GetClients = GetClients()
};
return(View(clientlist));
}
public ActionResult AddInvoice()
{
ClientsViewModel clientlist = new ClientsViewModel {
GetClients = GetClients()
};
return(View(clientlist));
}
public Clients(ClientsViewModel form)
{
this.Id = form.Id;
this.FirstName = form.FirstName;
this.LastName = form.LastName;
this.Email = form.Email;
this.Discount = form.Discount;
}
private void btnAnnuler_Click(object sender, RoutedEventArgs e)
{
ClientsViewModel vehi = this.DataContext as ClientsViewModel;
vehi.SelectedData = null;
this.Close();
}
public void ClientsClick(object sender, RoutedEventArgs e)
{
Clients view = new Clients();
ClientsViewModel viewModel = new ClientsViewModel();
view.DataContext = viewModel;
view.ShowDialog();
}
public ActionResult PostNairaInvoice()
{
//ClientsViewModel clientlist = new ClientsViewModel { GetServiceEntries = GetEntries() };
ClientsViewModel clientlist = new ClientsViewModel {
GetClients = GetClients()
};
return(View(clientlist));
}
// GET: Clients
public ActionResult Index()
{
ClientsViewModel vm = new ClientsViewModel
{
ListeDesClients = dal.ObtientTousLesClients()
};
return(View(vm));
}
public async Task <IActionResult> Clients()
{
List <Client> clients = await _context.GetAllClients();
ClientsViewModel viewModel = new ClientsViewModel {
Clients = clients
};
return(View(viewModel));
}
public IActionResult Index()
{
ClientsViewModel vm = new ClientsViewModel()
{
Cities = _db.Cities.ToList(),
Clients = _db.Clients.Where(x => x.Archived == false && x.CompanyID == _userService.User.CompanyID).ToList()
};
return(View(vm));
}
public ActionResult GetItems(string search)
{
var items = _clientService.GetItems(search).Select(g => g.MapToViewModel()).ToList();
var model = new ClientsViewModel
{
Items = items
};
return(PartialView("_Items", model));
}
public async Task <IActionResult> Details(string id)
{
Reservation r = await this._context.Reservations
.Include(room => room.Room)
.Include(user => user.User)
.Include(clients => clients.Clients)
.ThenInclude(x => x.Client)
.SingleOrDefaultAsync(r => r.Id == id);
List <ClientsViewModel> clients = new List <ClientsViewModel>();
List <ClientReservation> ch = _context.ClientReservations.Where(res => res.Reservation.Id == id).ToList();
List <string> chId = new List <string>();
List <Client> client = new List <Client>();
foreach (var c in ch)
{
chId.Add(c.Client.Id);
}
foreach (var c in chId)
{
Client client1 = new Client();
client1 = _context.Clients.FirstOrDefault(x => x.Id == c);
client.Add(client1);
}
foreach (var c in client)
{
ClientsViewModel clientReservationsA = new ClientsViewModel()
{
Id = c.Id,
FullName = $"{c.FirstName} {c.LastName}",
Email = c.Email,
Number = c.Number,
IsAdult = c.IsAdult ? "Yes" : "No",
};
clients.Add(clientReservationsA);
}
ReservationsDetailsViewModel reservationsDetailsViewModel = new ReservationsDetailsViewModel
{
Id = r.Id,
UserName = r.User.UserName,
RoomNumber = r.Room.number,
AccommodationDate = r.AccommodationDate,
ReleaseDate = r.ReleaseDate,
HaveBreakFast = r.HaveBreakFast ? "Yes" : "No",
IsAllInclusive = r.IsAllInclusive ? "Yes" : "No",
DueAmount = r.DueAmount,
Clients = clients
};
return(this.View(reservationsDetailsViewModel));
}
private JsonResult GetViewResult(ClientsViewModel client)
{
//user = this.AppendModelCombos(user);
return(this.Json(
new
{
Success = false,
Message = "Validation failed",
Html = this.RenderPartialViewToString("_AddClient", client)
}));
}
public IActionResult PrepareAddClient()
{
ClientsViewModel viewModel = new ClientsViewModel();
return(this.Json(
new
{
Success = true,
Message = string.Empty,
Html = this.RenderPartialViewToString("_AddClient", viewModel)
}));
}
