protected override void PopulateEditModel(EditVM model, ref bool valid)
{
if (valid == true)
{
if (!AuthenticationManager.LoggedUser.IsAdmin)
{
model.UserId = AuthenticationManager.LoggedUser.Id;
}
if (model.UserId == 0)
{
model.UserId = AuthenticationManager.LoggedUser.Id;
}
ActivitiesRepository repo = new ActivitiesRepository();
model.activity = repo.GetById(model.ActivityId);
if (model.activity != null)
{
model.Title = model.activity.Name;
if (model.StartDateTime != null)
{
TimeSpan duration = TimeSpan.FromHours(model.activity.Duration);
model.EndDateTime = model.StartDateTime.Value.Add(duration);
}
}
else
{
valid = false;
}
}
}
public ActionResult AutocompleteActivities(string term)
{
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
var legalEntities = activitiesRepository.GetValid().Where(c => c.Name.Contains(term) || c.Code.Contains(term)).OrderBy(x => x.Name);
return(Json(legalEntities.Select(c => new { value = c.Name + " (" + c.Code + ")", value_id = c.ActivityPK }), JsonRequestBehavior.AllowGet));
}
public SMSGenerator()
{
FromProgramToDb = new ConvertFromProgramToDb();
FromDbToProgram = new ConvertFromDbToProgramModel();
LRepo = new LineRepository();
ARepo = new ActivitiesRepository();
}
public UnitOfWork(LibarysystemDBcontext libarysystemDBcontext)
{
_context = libarysystemDBcontext;
activities = new ActivitiesRepository(_context);
alumnus = new AlumnusRepository(_context);
program = new ProgramRepository(_context);
section = new SectionRepository(_context);
employee = new EmployeeRepository(_context);
person = new PersonRepository(_context);
}
public BillGenerator()
{
BillingMonth = (DateTime.Now.Month - 1);
BillingYear = (DateTime.Now.Year - 1);
ConvertDbToProgram = new ConvertFromDbToProgramModel();
ConvertProgramToDb = new ConvertFromProgramToDb();
URepo = new UserRepository();
ARepo = new ActivitiesRepository();
Calculator = new BillCalculator();
NewBills = new List <BillModel>();
}
public BillGenerator(int month, int year)
{
BillingMonth = month;
BillingYear = year;
ConvertDbToProgram = new ConvertFromDbToProgramModel();
ConvertProgramToDb = new ConvertFromProgramToDb();
URepo = new UserRepository();
ARepo = new ActivitiesRepository();
Calculator = new BillCalculator();
NewBills = new List <BillModel>();
}
public void BindDDLs(LegalEntityView legalEntityView, ObjectContext db)
{
//forms ddl
IFormsRepository formsRepository = new FormsRepository(db);
legalEntityView.Forms = new SelectList(formsRepository.GetValid().OrderBy("Name ASC").ToList(), "FormPK", "Name");
//activities ddl
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
var activities = activitiesRepository.GetValid().OrderBy("Name ASC").ToList();
//regional offices ddl
IRegionalOfficesRepository regionalOfficesRepository = new RegionalOfficesRepository(db);
legalEntityView.RegionalOffices = new SelectList(regionalOfficesRepository.GetValid().OrderBy("Name ASC").ToList(), "RegionalOfficePK", "Name");
}
public ActionResult Edit(int?activityPK)
{
if (activityPK != null)
{
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
Activity activity = activitiesRepository.GetActivityByPK((int)activityPK);
ActivityView activityView = new ActivityView();
activityView.ConvertFrom(activity, activityView);
return(View(activityView));
}
else
{
return(RedirectToAction("Index", "Activity"));
}
}
public ActionResult Delete(int?activityPK)
{
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
if (activityPK != null)
{
Activity activity = activitiesRepository.GetActivityByPK((int)activityPK);
activity.Deleted = true;
activitiesRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("DELETE", activity.ActivityPK);
}
return(Redirect(Request.UrlReferrer.AbsoluteUri));
}
public ActionResult Index()
{
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
int page = !String.IsNullOrWhiteSpace(Request.QueryString["page"]) ? Convert.ToInt32(Request.QueryString["page"]) : 1;
int pageSize = !String.IsNullOrWhiteSpace(Request.QueryString["pageSize"]) ? Convert.ToInt32(Request.QueryString["pageSize"]) : Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ResultsPerPage"]);
string sortOrder = !String.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC";
string sortColumn = !String.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "ActivityPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <ActivityView> activities = ActivityView.GetHomeView(activitiesRepository.GetValid())
.OrderBy(ordering);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
activities = activities.Where(c => c.Name.Contains(searchString) || c.Code.Contains(searchString));
}
activities = activities.Page(page, pageSize);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
ViewData["numberOfRecords"] = activitiesRepository.GetValid().Where(c => c.Name.Contains(searchString) || c.Code.Contains(searchString)).Count();
}
else
{
ViewData["numberOfRecords"] = activitiesRepository.GetValid().Count();
}
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("Activity?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", activities.ToList()));
}
}
public ActionResult Edit(ActivityView activityView)
{
if (ModelState.IsValid)
{
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
Activity activity = activitiesRepository.GetActivityByPK((int)activityView.ActivityPK);
activityView.ConvertTo(activityView, activity);
activitiesRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("UPDATE", activity.ActivityPK);
return(RedirectToAction("Index", "Activity"));
}
else
{
return(View(activityView));
}
}
protected override void PopulateModel(IndexVM model)
{
if (!AuthenticationManager.LoggedUser.IsAdmin)
{
model.Filter.UserId = AuthenticationManager.LoggedUser.Id;
}
else
{
UsersRepository uRepo = new UsersRepository();
model.user = uRepo.GetById(model.Filter.UserId);
}
if (model.Filter.UserId == 0)
{
model.Filter.UserId = AuthenticationManager.LoggedUser.Id;
}
ActivitiesRepository aRepo = new ActivitiesRepository();
List <Activity> dbActivities = aRepo.GetAll(a => true);
List <SelectListItem> listItems = new List <SelectListItem>();
listItems.Add(new SelectListItem()
{
Text = "",
Value = null
});
foreach (Activity activity in dbActivities)
{
listItems.Add(new SelectListItem()
{
Text = activity.Name,
Value = activity.Id.ToString()
});
}
model.Filter.activitiesList = new SelectList(listItems, "Value", "Text", model.Filter.ActivityId ?? null);
}
private void button4_Click(object sender, EventArgs e)
{
var activityRepo = new ActivitiesRepository();
Console.WriteLine(textBoxHour.Text);
int timespent = Convert.ToInt32(textBoxHour.Text);
/*if (timespent>60 && timespent>0)
* {
* if (timespent % 60 == 0)
* {
* timehours = timespent / 60;
* }
* else
* {
* timeminutes = timespent % 60;
* }
* }
* else if(timespent>0 && timespent<60)
* {
* timeminutes = timespent;
* }*/
DateTime data = DateTime.Now;
if (!textBoxHour.Text.Equals(null))
{
var activity = new Activity
{
Description = rTBEdit.Text,
TimeSpent = timespent,
Day = Day,
Month = data.Month,
};
activityRepo.AddActivity(activity);
}
else
{
MessageBox.Show("Atribua quantos minutos vai usar para esta atividade");
}
}
public void LoadActivities()
{
lvObjectives.Items.Clear();
var actRepository = new ActivitiesRepository();
try
{
var activities = actRepository.GetActivitiesForDay(Day, Month);
foreach (Activity act in activities)
{
var item = new ListViewItem(act.Description);
item.SubItems.Add(act.TimeSpent.ToString());
lvObjectives.Items.Add(item);
}
}
catch (Exception error)
{
Console.WriteLine(error);
MessageBox.Show("Algo deu errado");
}
}
public Edit(int day)
{
InitializeComponent();
var activityRepo = new ActivitiesRepository();
MainForm md = new MainForm();
labelMonth.Text = md.GetMonthName();
//labelDayedit.Text = "Dia : " + day;
textBoxHour.MaxLength = 3;
Day = day;
int tempoDispTotalMinutos = 24 * 60 - activityRepo.GetAvailableTime(Day, DateTime.Now.Month);
int tempoDispHoras = tempoDispTotalMinutos / 60;
int tempoDispMinutos = tempoDispTotalMinutos % 60;
string tempoText = tempoDispHoras.ToString() + "h";
if (tempoDispMinutos > 0)
{
tempoText += " " + tempoDispMinutos + "m";
}
labelSchedule.Text = tempoText;
}
public AddCompanyViewModel InitFormView([QueryString] int?companyId)
{
List <ActivityViewModel> activitiesVM = null;
List <Activity> activities = ActivitiesRepository.GetActivities();
activitiesVM = Mapper.Map <List <Activity>, List <ActivityViewModel> >(activities);
AddCompanyViewModel model = null;
if (companyId.HasValue)
{
Company company = CompanyRepository.GetCompanyByID(companyId.Value);
model = Mapper.Map <Company, AddCompanyViewModel>(company);
}
else
{
model = new AddCompanyViewModel
{
Name = this.ViewStateCompanyName
};
}
model.Activities = activitiesVM;
return(model);
}
public ActivitiesController(ActivitiesRepository activitiesRepository)
{
_activitiesRepository = activitiesRepository;
}
public EntriesController(EntriesRepository entriesRepository, ActivitiesRepository activitiesRepository)
{
_entriesRepository = entriesRepository;
_activitiesRepository = activitiesRepository;
}
public ActionResult Edit(AssessmentsView assessmentView, FormCollection form)
{
if (ModelState.IsValid)
{
IAssessmentsRepository assessmentsRepository = new AssessmentsRepository(db);
Assessment assessment = assessmentsRepository.GetAssessmentByPK((int)assessmentView.AssessmentPK);
IAssessmentAnswersRepository assessmentAnswersRepository = new AssessmentAnswersRepository(db);
// Delete old values
assessmentAnswersRepository.Delete(a => a.AssessmentFK == assessment.AssessmentPK);
// Add new values
IAssessmentGroupsRepository assessmentGroupsRepository = new AssessmentGroupsRepository(db);
IAssessmentQuestionsRepository assessmentQuestionsRepository = new AssessmentQuestionsRepository(db);
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
assessmentView.AssessmentsTypesView = AssessmentsView.FillQuiz(assessmentTypesRepository.GetValid(), assessmentGroupsRepository, assessmentQuestionsRepository, form);
// Fetching answered type
AssessmentsTypeView atw = assessmentView.AssessmentsTypesView.Where(a => a.AssessmentType.AssessmentTypePK == assessmentView.AssessmentTypeFK).First();
List <AssessmentAnswers> assessmentAnswers = AssessmentAnswerView.ExtractQuizAnswers(atw, assessment.AssessmentPK);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)assessmentView.LegalEntityFK);
bool activityHighRisky = legalEntity.Activity.HighRisk != null && (bool)legalEntity.Activity.HighRisk ? true : false;
bool activityLowRisky = legalEntity.Activity.LowRisk != null && (bool)legalEntity.Activity.LowRisk ? true : false;
bool headquarterCountryRisky = legalEntity.Country.Risk != null && (bool)legalEntity.Country.Risk ? true : false;
IRisksRepository risksRepository = new RisksRepository(db);
if (activityHighRisky || headquarterCountryRisky) // check explicitly if related legalEntity activity is high risk
{
assessmentView.RiskFK = risksRepository.GetRiskByName("Visok").RiskPK;
}
else if (activityLowRisky) // check explicitly if related legalEntity activity is low risk
{
assessmentView.RiskFK = risksRepository.GetRiskByName("Nizak").RiskPK;
}
else // run assesment quiz
{
ILegalEntityOwnersRepository legalEntityOwnersRepository = new LegalEntityOwnersRepository(db);
IQueryable <LegalEntityOwner> legalEntityOwnersTable = legalEntityOwnersRepository.GetValid();
ICountriesRepository countriesRepository = new CountriesRepository(db);
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
List <LegalEntityOwner> coList = legalEntityOwnersRepository.GetFirstLegalEntityOwnersForLegalEntity((int)assessmentView.LegalEntityFK).ToList();
legalEntityOwnersTable = LegalEntityOwnerView.GetLegalEntityOwnersForLegalEntity(Convert.ToInt32(assessmentView.LegalEntityFK), coList, legalEntityOwnersTable);
IQueryable <LegalEntity> legalEntityView = LegalEntityOwnerView.GetRelatedLegalEntities(legalEntityOwnersTable, legalEntitiesRepository.GetValid(), countriesRepository.GetValid(), activitiesRepository.GetValid());
// check owners risks
bool ownersResidenceCountryRisky = false;
bool ownersActivitiesHighlyRisky = false;
bool ownersActivitiesLowRisky = false;
if (legalEntityView.Count() > 0)
{
if (legalEntityView.ToList().TrueForAll(le => le.Country.Risk == null || (le.Country.Risk != null && (bool)le.Country.Risk != true)) == false)
{
ownersResidenceCountryRisky = true;
}
if (legalEntityView.ToList().TrueForAll(le => le.Activity == null || (le.Activity.HighRisk == null || (le.Activity.HighRisk != null && (bool)le.Activity.HighRisk != true))) == false)
{
ownersActivitiesHighlyRisky = true;
}
if (legalEntityView.ToList().TrueForAll(le => le.Activity == null || (le.Activity.LowRisk == null || (le.Activity.LowRisk != null && (bool)le.Activity.LowRisk != true))) == false)
{
ownersActivitiesLowRisky = true;
}
}
// check form
bool allAnswersYes = false;
bool allAnswersNo = false;
bool mixedAnswers = false;
if (assessmentAnswers.TrueForAll(aa => aa.AssessmentAnswer != null && (bool)aa.AssessmentAnswer == true))
{
allAnswersYes = true;
}
if (assessmentAnswers.TrueForAll(aa => aa.AssessmentAnswer != null && (bool)aa.AssessmentAnswer == false))
{
allAnswersNo = true;
}
if (allAnswersYes == false && allAnswersNo == false)
{
mixedAnswers = true;
}
// check general conditions
if (ownersActivitiesLowRisky)
{
assessmentView.RiskFK = risksRepository.GetRiskByName("Nizak").RiskPK;
}
else if (allAnswersYes || ownersResidenceCountryRisky || ownersActivitiesHighlyRisky)
{
assessmentView.RiskFK = risksRepository.GetRiskByName("Visok").RiskPK;
}
else if (allAnswersNo || mixedAnswers)
{
assessmentView.RiskFK = risksRepository.GetRiskByName("Srednji").RiskPK;
}
}
if (assessmentAnswers.Count() > 0)
{
assessmentAnswersRepository.AddAll(assessmentAnswers);
assessmentAnswersRepository.SaveChanges();
}
assessmentView.ConvertTo(assessmentView, assessment);
assessmentsRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("UPDATE", assessment.AssessmentPK);
return(RedirectToAction("Index", "Assessment"));
}
else
{
IAssessmentGroupsRepository assessmentGroupsRepository = new AssessmentGroupsRepository(db);
IAssessmentQuestionsRepository assessmentQuestionsRepository = new AssessmentQuestionsRepository(db);
//Assessment types ddl
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
assessmentView.AssessmentTypes = new SelectList(assessmentTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "AssessmentTypePK", "Name");
//legalEntities ddl
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
assessmentView.LegalEntities = new SelectList(legalEntitiesRepository.GetValidLegalEntities().ToList(), "LegalEntityPK", "Name");
assessmentView.AssessmentsTypesView = AssessmentsView.FillQuiz(assessmentTypesRepository.GetValid(), assessmentGroupsRepository, assessmentQuestionsRepository, form);
return(View(assessmentView));
}
}
public DataService()
{
_repo = new ActivitiesRepository();
}
public static List <LegalEntityAuditView> GetLegalEntityAuditView(ObjectContext context, int relatedEntityPK)
{
IAuditingDetailsRepository auditingDetailsRepository = new AuditingDetailsRepository(context);
IAuditingMasterRepository auditingMasterRepository = new AuditingMasterRepository(context);
List <LegalEntityAuditView> legalEntityAuditViewList = new List <LegalEntityAuditView>();
var sessionTokens = (from am in auditingMasterRepository.GetAll().Where(c => c.TableName == "LegalEntities")
where am.RelatedEntityPK == relatedEntityPK
select new {
auditingMasterPK = am.AuditingMasterPK,
sessionToken = am.SessionToken
}).ToList();
foreach (var item in sessionTokens)
{
var record = auditingDetailsRepository.GetAuditingDetailByAuditingMasterPK(item.auditingMasterPK).ToList();
LegalEntityAuditView leav = new LegalEntityAuditView();
leav.Name = record.checkString("Name");
leav.ShortName = record.checkString("ShortName");
leav.OIB = record.checkString("OIB");
leav.MB = record.checkString("MB");
leav.MBS = record.checkString("MBS");
leav.ActivityFK = record.checkInteger("ActivityFK");
leav.ActivityDescription = record.checkString("ActivityDescription");
leav.FormFK = record.checkInteger("FormFK");
leav.FundamentalCapital = record.checkDecimal("FundamentalCapital");
leav.CountryFK = record.checkInteger("CountryFK");
leav.CountyFK = record.checkInteger("CountyFK");
leav.PlaceFK = record.checkInteger("PlaceFK");
leav.PostalOfficeFK = record.checkInteger("PostalOfficeFK");
leav.Place = record.checkString("Place");
leav.CityCommunityFK = record.checkInteger("CityCommunityFK");
leav.StreetName = record.checkString("StreetName");
leav.RegionalOfficeFK = record.checkInteger("RegionalOfficeFK");
leav.SubstationFK = record.checkInteger("SubstationFK");
leav.ReferentFK = record.checkInteger("ReferentFK");
leav.DateOfRegistration = record.checkDate("DateOfRegistration");
leav.CommercialCourtFK = record.checkInteger("CommercialCourtFK");
leav.TaxFK = record.checkInteger("TaxFK");
leav.Phone = record.checkString("Phone");
leav.Fax = record.checkString("Fax");
leav.Mobile = record.checkString("Mobile");
leav.EMail = record.checkString("EMail");
leav.FirstContactDate = record.checkDate("FirstContactDate");
leav.TouristOffice = record.checkBoolean("TouristOffice");
leav.TouristOfficeDescription = record.checkString("TouristOfficeDescription");
leav.MonumentAnnuity = record.checkBoolean("MonumentAnnuity");
leav.MonumentAnnuityDescription = record.checkString("MonumentAnnuityDescription");
leav.NumberOfEmployees = record.checkInteger("NumberOfEmployees");
leav.MIORRegistrationNumber = record.checkString("MIORRegistrationNumber");
leav.HZZOObligationNumber = record.checkString("HZZOObligationNumber");
leav.HZZOBussinesEntityCode = record.checkString("HZZOBussinesEntityCode");
leav.ChangeDate = record.checkDate("ChangeDate");
leav.Owner = record.checkBoolean("Owner");
leav.LegalEntity = record.checkBoolean("LegalEntity");
leav.Active = record.checkBoolean("Active");
legalEntityAuditViewList.Add(leav);
}
// Connect all foreign keys and return data collection as List<LegalEntityAuditView>
IFormsRepository formsRepository = new FormsRepository(context);
IQueryable <Form> formsTable = formsRepository.GetValid();
IActivitiesRepository activitiesRepository = new ActivitiesRepository(context);
IQueryable <Activity> activitiesTable = activitiesRepository.GetValid();
IRegionalOfficesRepository regionalOfficesRepository = new RegionalOfficesRepository(context);
IQueryable <RegionalOffice> regionalOfficesTable = regionalOfficesRepository.GetValid();
ISubstationsRepository substationsRepository = new SubstationsRepository(context);
IQueryable <Substation> substationsTable = substationsRepository.GetValid();
ICommercialCourtsRepository commercialCourtsRepository = new CommercialCourtsRepository(context);
IQueryable <CommercialCourt> commercialCourtsTable = commercialCourtsRepository.GetValid();
ITaxesRepository taxesRepository = new TaxesRepository(context);
IQueryable <Tax> taxesTable = taxesRepository.GetValid();
ICountriesRepository countriesRepository = new CountriesRepository(context);
IQueryable <Country> countriesTable = countriesRepository.GetValid();
ICountiesRepository countiesRepository = new CountiesRepository(context);
IQueryable <County> countiesTable = countiesRepository.GetValid();
ICitiesCommunitiesRepository citiesCommunitiesRepository = new CitiesCommunitiesRepository(context);
IQueryable <CityCommunity> cityCommunityTable = citiesCommunitiesRepository.GetValid();
IPostalOfficesRepository postalOfficesRepository = new PostalOfficesRepository(context);
IQueryable <PostalOffice> postalOfficeTable = postalOfficesRepository.GetValid();
IPlacesRepository placesRepository = new PlacesRepository(context);
IQueryable <Place> placesTable = placesRepository.GetValid();
IPhysicalEntitiesRepository physicalEntitiesRepository = new PhysicalEntitiesRepository(context);
IQueryable <PhysicalEntity> physicalEntitiesTable = physicalEntitiesRepository.GetValid();
List <LegalEntityAuditView> legalEntityAuditView =
(from t in legalEntityAuditViewList
from t1 in formsTable.Where(tbl => tbl.FormPK == t.FormFK).DefaultIfEmpty()
from t2 in activitiesTable.Where(tbl => tbl.ActivityPK == t.ActivityFK).DefaultIfEmpty()
from t3 in regionalOfficesTable.Where(tbl => tbl.RegionalOfficePK == t.RegionalOfficeFK).DefaultIfEmpty()
from t4 in substationsTable.Where(tbl => tbl.SubstationPK == t.SubstationFK).DefaultIfEmpty()
from t5 in commercialCourtsTable.Where(tbl => tbl.CommercialCourtPK == t.CommercialCourtFK).DefaultIfEmpty()
from t6 in taxesTable.Where(tbl => tbl.TaxPK == t.TaxFK).DefaultIfEmpty()
from t7 in countriesTable.Where(tbl => tbl.CountryPK == t.CountryFK).DefaultIfEmpty()
from t8 in countiesTable.Where(tbl => tbl.CountyPK == t.CountyFK).DefaultIfEmpty()
from t9 in cityCommunityTable.Where(tbl => tbl.CityCommunityPK == t.CityCommunityFK).DefaultIfEmpty()
from t10 in postalOfficeTable.Where(tbl => tbl.PostalOfficePK == t.PostalOfficeFK).DefaultIfEmpty()
from t11 in placesTable.Where(tbl => tbl.PlacePK == t.PlaceFK).DefaultIfEmpty()
from t12 in physicalEntitiesTable.Where(tbl => tbl.PhysicalEntityPK == t.ReferentFK).DefaultIfEmpty()
select new LegalEntityAuditView
{
LegalEntityPK = t.LegalEntityPK,
Name = t.Name != null ? t.Name : null,
ShortName = t.ShortName != null ? t.ShortName : null,
OIB = t.OIB != null ? t.OIB : null,
MB = t.MB != null ? t.MB : null,
MBS = t.MBS != null ? t.MBS : null,
ActivityFK = t.ActivityFK != null ? t.ActivityFK : null,
ActivityDescription = t.ActivityDescription != null ? t.ActivityDescription : null,
FormFK = t.FormFK != null ? t.FormFK : null,
FundamentalCapital = t.FundamentalCapital != null ? t.FundamentalCapital : null,
CountryFK = t.CountryFK != null ? t.CountryFK : null,
CountyFK = t.CountyFK != null ? t.CountyFK : null,
CityCommunityFK = t.CityCommunityFK != null ? t.CityCommunityFK : null,
PostalOfficeFK = t.PostalOfficeFK != null ? t.PostalOfficeFK : null,
PlaceFK = t.PlaceFK != null ? t.PlaceFK : null,
Place = t.Place != null ? t.Place : null,
StreetName = t.StreetName != null ? t.StreetName : null,
RegionalOfficeFK = t.RegionalOfficeFK != null ? t.RegionalOfficeFK : null,
SubstationFK = t.SubstationFK != null ? t.SubstationFK : null,
ReferentFK = t.ReferentFK != null ? t.ReferentFK : null,
DateOfRegistration = t.DateOfRegistration != null ? t.DateOfRegistration : null,
CommercialCourtFK = t.CommercialCourtFK != null ? t.CommercialCourtFK : null,
TaxFK = t.TaxFK != null ? t.TaxFK : null,
Phone = t.Phone != null ? t.Phone : null,
Fax = t.Fax != null ? t.Fax : null,
Mobile = t.Mobile != null ? t.Mobile : null,
EMail = t.EMail != null ? t.EMail : null,
FirstContactDate = t.FirstContactDate != null ? t.FirstContactDate : null,
TouristOffice = t.TouristOffice != null ? t.TouristOffice : null,
TouristOfficeDescription = t.TouristOfficeDescription != null ? t.TouristOfficeDescription : null,
MonumentAnnuity = t.MonumentAnnuity != null ? t.MonumentAnnuity : null,
MonumentAnnuityDescription = t.MonumentAnnuityDescription != null ? t.MonumentAnnuityDescription : null,
NumberOfEmployees = t.NumberOfEmployees != null ? t.NumberOfEmployees : null,
MIORRegistrationNumber = t.MIORRegistrationNumber != null ? t.MIORRegistrationNumber : null,
HZZOObligationNumber = t.HZZOObligationNumber != null ? t.HZZOObligationNumber : null,
HZZOBussinesEntityCode = t.HZZOBussinesEntityCode != null ? t.HZZOBussinesEntityCode : null,
ChangeDate = t.ChangeDate != null ? t.ChangeDate : null,
Owner = t.Owner != null ? t.Owner : null,
LegalEntity = t.LegalEntity != null ? t.LegalEntity : null,
Active = t.Active != null ? t.Active : null,
Deleted = t.Deleted != null ? t.Deleted : null,
FormName = t1 != null && t1.Name != null ? t1.Name : null,
ActivityName = t2 != null && t2.Name != null ? t2.Name : null,
RegionalOfficeName = t3 != null && t3.Name != null ? t3.Name : null,
SubstationName = t4 != null && t4.Name != null ? t4.Name : null,
ReferentName = t12 != null && t12.Firstname != null && t12.Lastname != null ? t12.Firstname + " " + t12.Lastname : null,
CommercialCourtName = t5 != null && t5.Name != null ? t5.Name : null,
TaxName = t6 != null && t6.Name != null ? t6.Name : null,
CountryName = t7 != null && t7.Name != null ? t7.Name : null,
CountyName = t8 != null && t8.Name != null ? t8.Name : null,
CityCommunityName = t9 != null && t9.Name != null ? t9.Name : null,
PostalOfficeName = t10 != null && t10.Name != null ? t10.Name : null,
PlaceName = t11 != null && t11.Name != null ? t11.Name : null,
}).OrderBy(c => c.ChangeDate).ToList();
return(legalEntityAuditView);
}
public ActivitiesApiController(ActivitiesRepository repository)
{
this.repository = repository;
this.OnCreated();
}
public ActionResult LegalEntities(string Name, string OIB, string MB, string MBS, int?BankPK, int?TaxPK, int?FormPK, int?ActivityPK, int?SubstationPK, int?CommercialCourtPK, int?NumberOfEmployeesFrom, int?NumberOfEmployeesTo, int?FundamentalCapitalFrom, int?FundamentalCapitalTo, string TouristOffice, string MonumentAnnuity)
{
string sortOrder = !string.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC";
string sortColumn = !string.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "LegalEntityPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IBanksRepository banksRepository = new BanksRepository(db);
ITaxesRepository taxesRepository = new TaxesRepository(db);
IFormsRepository formsRepository = new FormsRepository(db);
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
ISubstationsRepository substationsRepository = new SubstationsRepository(db);
ICommercialCourtsRepository commercialCourtsRepository = new CommercialCourtsRepository(db);
// Binding DDL for report search
ViewBag.Banks = new SelectList(banksRepository.GetValid().OrderBy("Name ASC").ToList(), "BankPK", "Name", BankPK);
ViewBag.Taxes = new SelectList(taxesRepository.GetValid().OrderBy("Name ASC").ToList(), "TaxPK", "Name", TaxPK);
ViewBag.Forms = new SelectList(formsRepository.GetValid().OrderBy("Name ASC").ToList(), "FormPK", "Name", FormPK);
ViewBag.Activities = new SelectList(activitiesRepository.GetValid().OrderBy("Name ASC").ToList(), "ActivityPK", "Name", ActivityPK);
ViewBag.Substations = new SelectList(substationsRepository.GetValid().OrderBy("Name ASC").ToList(), "SubstationPK", "Name", SubstationPK);
ViewBag.CommercialCourts = new SelectList(commercialCourtsRepository.GetValid().OrderBy("Name ASC").ToList(), "CommercialCourtPK", "Name", CommercialCourtPK);
if (BankPK != null)
{
ViewBag.Bank = banksRepository.GetBankByPK((int)BankPK).Name;
}
if (TaxPK != null)
{
ViewBag.Tax = taxesRepository.GetTaxByPK((int)TaxPK).Name;
}
if (SubstationPK != null)
{
ViewBag.Substation = substationsRepository.GetSubstationByPK((int)SubstationPK).Name;
}
if (CommercialCourtPK != null)
{
ViewBag.CommercialCourt = commercialCourtsRepository.GetCommercialCourtByPK((int)CommercialCourtPK).Name;
}
if (FormPK != null)
{
ViewBag.Form = formsRepository.GetFormByPK((int)FormPK).Name;
}
if (ActivityPK != null)
{
ViewBag.Activity = activitiesRepository.GetActivityByPK((int)ActivityPK).Name;
}
bool?TouristOfficeFlag = null;
bool?MonumentAnnuityFlag = null;
if (TouristOffice == "on")
{
TouristOfficeFlag = true;
}
if (MonumentAnnuity == "on")
{
MonumentAnnuityFlag = true;
}
// Applying filters
IQueryable <LegalEntityView> legalEntities = LegalEntityView.GetLegalEntitiesReport(db, Name, OIB, MB, MBS, BankPK, TaxPK, FormPK, ActivityPK, SubstationPK, CommercialCourtPK, NumberOfEmployeesFrom, NumberOfEmployeesTo, FundamentalCapitalFrom, FundamentalCapitalTo, TouristOfficeFlag, MonumentAnnuityFlag)
.OrderBy(ordering);
// Excluding temporary deleted items from view
legalEntitiesPKsToExclude = new List <int>();
// Empty session on first request
if (Request.QueryString.Count == 0)
{
Session["legalEntitiesPKsToExclude"] = null;
}
if (Session["legalEntitiesPKsToExclude"] != null)
{
legalEntitiesPKsToExclude = (List <int>)Session["legalEntitiesPKsToExclude"];
legalEntities = legalEntities.Where(c => !legalEntitiesPKsToExclude.Contains(c.LegalEntityPK));
}
return(View("LegalEntities", legalEntities.ToList()));
}
/// <summary>
/// Initializes the view model.
/// </summary>
public void Init(ActivitiesRepository activitiesRepository)
{
ActivitiesSelectListItems = new SelectList(
activitiesRepository.GetList(), "Id", "Name");
}
public ActivitiesController()
{
_repo = new ActivitiesRepository();
}
protected void Page_Unload(object sender, EventArgs e)
{
ContactsRepository.Dispose();
ActivitiesRepository.Dispose();
CompanyRepository.Dispose();
}
