public bool UpdateContract(ContractsViewModel contractsVM)
{
//IEnumerable<Contracts> list = GetAll();
List <Contracts> list = new List <Contracts>();
list = ctr.LoadListObject <Contracts>();
var result = list.FirstOrDefault(x => x.ID == contractsVM.ID);
if (result != null)
{
try
{
result.ContractNumber = contractsVM.ContractNumber;
result.ContractName = contractsVM.ContractName;
result.CustomerID = contractsVM.CustomerID;
result.UnitInfoID = contractsVM.UnitInfoID;
result.ContractContent = contractsVM.ContractContent;
result.Description1 = contractsVM.Description1;
result.Description2 = contractsVM.Description2;
result.ContractTypeID = contractsVM.ContractTypeID;
result.IsLock = contractsVM.IsLock;
ctr.Update <Contracts>(result);
return(true);
}
catch (Exception ex)
{
}
}
return(false);
}
public ActionResult Index(int?page, string sortOrder, string searchString)
{
int noPage = (page ?? 1) - 1;
var cvm = new ContractsViewModel
{
Portfolios = portfolioRepository.GetPortfoliosByUserScope((long)Session["id"])
};
if (searchString != null)
{
page = 1;
}
var contracts = contractRepository.Pagination(c => c.Name, noPage, 10, out int total);
contracts = zoneRepository.GetAll().Include("Contracts").Where(z => z.Label.ToLower().Contains(searchString.ToLower())).SelectMany(z => z.Contracts);
if (contracts.Count() == 0)
{
cvm.IsListEmpty = true;
return(View(cvm));
}
if (!string.IsNullOrEmpty(searchString))
{
contracts = contractRepository.GetByFilter(c => c.Name.ToLower().Contains(searchString.ToLower()));
}
cvm.Contracts = new StaticPagedList <Contract>(contracts, noPage + 1, Utils.Constants.ITEMS_PER_PAGE, total);
return(View(cvm));
}
public bool CreateContract(ContractsViewModel contractsVM)
{
try
{
Contracts contract = new Contracts()
{
ContractNumber = contractsVM.ContractNumber,
ContractName = contractsVM.ContractName,
CustomerID = contractsVM.CustomerID,
UnitInfoID = contractsVM.UnitInfoID,
ContractContent = contractsVM.ContractContent,
ContractTime = "1 năm",
CreateDate = SystemDefine.SystemDate.Date,
Description1 = contractsVM.Description1,
Description2 = contractsVM.Description2,
CreateBy = "admin",
ContractTypeID = contractsVM.ContractTypeID,
IsLock = contractsVM.IsLock
};
ctr.Insert <Contracts>(contract);
return(true);
}
catch
{
}
return(false);
}
private async void Initialize()
{
ContractsViewModel vm = null;
await Task.Delay(30);
var t = Task.Run(async() =>
{
vm = SimpleIoc.Default.GetInstanceWithoutCaching <ContractsViewModel>();
countries = await vm.GetCountries().ConfigureAwait(false);
});
await Task.WhenAll(t, loadedTsc.Task);
DataContext = vm;
contractCollectionViewSource = new CollectionViewSource
{
IsSourceGrouped = true,
Source = countries,
ItemsPath = new PropertyPath("Contracts")
};
ContractListView.ItemsSource = contractCollectionViewSource.View;
ContractsListViewZoomOut.ItemsSource = contractCollectionViewSource.View.CollectionGroups;
foreach (var country in countries)
{
if (country.ImageByteArray != null)
{
var bitmap = await ByteArrayToImageAsync(country.ImageByteArray as byte[]);
bitmap.DecodePixelWidth = 60;
country.ImageSource = bitmap;
}
await Task.Delay(1);
}
}
public HttpResponseMessage UpdateContract(HttpRequestMessage request, ContractsViewModel contractsVM)
{
HttpResponseMessage response = null;
if (!ModelState.IsValid)
{
response = request.CreateResponse(HttpStatusCode.BadRequest, ModelState);
}
else
{
bool checkData = contractsService.UpdateContract(contractsVM);
response = request.CreateResponse(HttpStatusCode.Created, checkData);
}
return(response);
}
// GET: Contracts
public async Task <IActionResult> Index(string searchStatus, string searchClient, string searchString)
//public async Task<IActionResult> Index()
{
//var contractsResults = _context.Contracts.Include(c => c.Client).Where(n => n.Name.Contains(searchString));
//return View(await nataDbContext.ToListAsync());
IQueryable <bool> statusQuery = from a in _context.Contracts
select a.Status;
IQueryable <string> clientsQuery = from a in _context.Contracts
orderby a.Account.Name
select a.Account.Name;
//var contracts = from a in _context.Contracts
// join v in _context.Accounts on a.ClientId equals v.Id
// select a;
var contractsResults = _context.Contracts.Include(a => a.Account).Include(ct => ct.ContractType).AsQueryable();
if (!string.IsNullOrEmpty(searchString))
{
//contracts = contracts.Include(c => c.Client).Where(n => n.Name.Contains(searchString));
contractsResults = _context.Contracts.Include(a => a.Account).Include(ct => ct.ContractType).Where(n => n.Name.Contains(searchString));
}
if (!string.IsNullOrEmpty(searchClient))
{
contractsResults = _context.Contracts.Include(a => a.Account).Include(ct => ct.ContractType).Where(n => n.Account.Name.Equals(searchClient));
}
if (!string.IsNullOrEmpty(searchStatus))
{
contractsResults = _context.Contracts.Include(a => a.Account).Include(ct => ct.ContractType).Where(s => s.Status == Convert.ToBoolean(searchStatus));
}
var contractsViewModel = new ContractsViewModel
{
Status = new SelectList(await statusQuery.Distinct().ToListAsync()),
Accounts = new SelectList(await clientsQuery.Distinct().ToListAsync()),
Contracts = await contractsResults.ToListAsync()
};
return(View(contractsViewModel));
}
// GET: Contracts
public async Task <IActionResult> Index(string searchStatus, string searchClient, string searchString)
{
IQueryable <bool> statusQuery = from a in _context.Contracts
select a.Status;
IQueryable <string> clientsQuery = from a in _context.Contracts
orderby a.Account.Name
select a.Account.Name;
var contractsResults = _context.Contracts.Include(a => a.Account).Include(ct => ct.ContractType).AsQueryable();
if (!string.IsNullOrEmpty(searchString))
{
contractsResults = contractsResults.Where(n => n.Name.Contains(searchString));
}
if (!string.IsNullOrEmpty(searchClient))
{
contractsResults = contractsResults.Where(n => n.Account.Name.Equals(searchClient));
}
if (!string.IsNullOrEmpty(searchStatus) && (searchStatus.ToString() != "all"))
{
contractsResults = contractsResults.Where(s => s.Status == Convert.ToBoolean(searchStatus));
}
if (string.IsNullOrEmpty(searchStatus))
{
contractsResults = contractsResults.Where(s => s.Status == true);
}
var contractsViewModel = new ContractsViewModel
{
Status = new SelectList(await statusQuery.Distinct().ToListAsync(), bool.Parse("True")),
Accounts = new SelectList(await clientsQuery.Distinct().ToListAsync()),
Contracts = await contractsResults.ToListAsync()
};
return(View(contractsViewModel));
}
public ActionResult Contracts(long id, int?page, string sortOrder, string searchString)
{
int noPage = (page ?? 1) - 1;
var contractsViewModels = new ContractsViewModel
{
Portfolio = portfolioRepository.GetById(id)
};
if (searchString != null)
{
page = 1;
}
var contracts = contractRepository.Pagination(p => p.PortfolioId == id, c => c.Name, noPage, Constants.ITEMS_PER_PAGE, out int total);
contractsViewModels.Portfolio.Scope = scopeRepository.GetScopeByPortfolio(id) ? "Initial" : "Extent";
string zoneUser = (string)Session["zone"];
contracts = zoneRepository.GetAll().Include("Contracts").Where(z => z.Label == zoneUser).SelectMany(z => z.Contracts).Where(c => c.PortfolioId == id);
if (contracts.Count() == 0)
{
contractsViewModels.IsListEmpty = true;
return(View(contractsViewModels));
}
if (!string.IsNullOrEmpty(searchString))
{
contracts = contracts.Where(c => c.Name.ToLower().Contains(searchString.ToLower()));
}
contractsViewModels.Contracts = new StaticPagedList <Contract>(contracts, noPage + 1, Constants.ITEMS_PER_PAGE, total);
return(View(contractsViewModels));
}
public ContractsPage()
{
InitializeComponent();
BindingContext = _viewModel = new ContractsViewModel();
}
private void InitContractsViewModel(int id_person, GenericPersonViewModel vm)
{
var lstContracts = this._databaseContext.HR_Contracts.Where(c => c.id_person == id_person);
vm.lstContracts = new ObservableCollection <ContractsViewModel>();
foreach (var contract in lstContracts)
{
var lstAssignments = this._databaseContext.HR_Assignments.Where(a => a.id_contract == contract.id_contract).ToList();
var baseAssignment = lstAssignments.Single(a => a.IsAdditionalAssignment == false);
ContractsViewModel cvm = new ContractsViewModel();
cvm.ActiveFrom = baseAssignment.AssignmentDate;
cvm.ContractDate = baseAssignment.ContractDate;
cvm.ContractNumber = baseAssignment.ContractNumber;
cvm.Level1 = (baseAssignment.HR_StructurePositions.UN_Departments.Level == 4) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 3) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 2) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 1) ? baseAssignment.HR_StructurePositions.UN_Departments.Name : null;
cvm.Level2 = (baseAssignment.HR_StructurePositions.UN_Departments.Level == 4) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 3) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 2) ? baseAssignment.HR_StructurePositions.UN_Departments.Name : null;
cvm.Level3 = (baseAssignment.HR_StructurePositions.UN_Departments.Level == 4) ? (baseAssignment.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(baseAssignment.HR_StructurePositions.UN_Departments.Level == 3) ? baseAssignment.HR_StructurePositions.UN_Departments.Name : null;
cvm.Level4 = (baseAssignment.HR_StructurePositions.UN_Departments.Level == 4) ? baseAssignment.HR_StructurePositions.UN_Departments.Name : null;
cvm.StructurePosition = baseAssignment.HR_StructurePositions.HR_GlobalPositions.Name;
var lstAdditionalAssignments = lstAssignments.Where(a => a.IsAdditionalAssignment == true).ToList();
foreach (var ass in lstAdditionalAssignments)
{
ContractsViewModel cam = new ContractsViewModel();
cam.ActiveFrom = ass.AssignmentDate;
cam.ContractDate = ass.ContractDate;
cam.ContractNumber = ass.ContractNumber;
cam.Level1 = (ass.HR_StructurePositions.UN_Departments.Level == 4) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 3) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 2) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 1) ? ass.HR_StructurePositions.UN_Departments.Name : null;
cam.Level2 = (ass.HR_StructurePositions.UN_Departments.Level == 4) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 3) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 2) ? ass.HR_StructurePositions.UN_Departments.Name : null;
cam.Level3 = (ass.HR_StructurePositions.UN_Departments.Level == 4) ? (ass.HR_StructurePositions.UN_Departments.UN_Departments2.Name) :
(ass.HR_StructurePositions.UN_Departments.Level == 3) ? ass.HR_StructurePositions.UN_Departments.Name : null;
cam.Level4 = (ass.HR_StructurePositions.UN_Departments.Level == 4) ? ass.HR_StructurePositions.UN_Departments.Name : null;
cam.StructurePosition = ass.HR_StructurePositions.HR_GlobalPositions.Name;
cvm.lstAdditionalAssignments.Add(cam);
}
vm.lstContracts.Add(cvm);
}
}
public bool UpdateContract(ContractsViewModel contractsVM)
{
return(contractsData.UpdateContract(contractsVM));
}
public bool CreateContract(ContractsViewModel contractsVM)
{
return(contractsData.CreateContract(contractsVM));
}
