public void Should_Create_Company()
{
try
{
var personContext = new PersonsContext();
var uow = new UnitOfWork<PersonsContext>();
var companyRepository = new CompanyRepository(uow);
var company = new Company
{
Name = "P",
Email = "*****@*****.**"
};
companyRepository.Add(company);
Assert.IsNotNull(personContext.Companies.FirstOrDefault(c => c.Name == "P"));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Console.WriteLine(("Property: {0} Error: {1}"), validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
public companyWindow(CompanyRepository companyRepository, BillRepository billRepository, BillManager billManager)
{
this.companyRepository = companyRepository;
this.billRepository = billRepository;
this.billManager = billManager;
CompanyWindowViewModel = new InformationWindowViewModel<Company>();
CompanyWindowViewModel.Items = new ObservableCollection<Company>(companyRepository.All.ToList());
InitializeComponent();
DataContext = this;
controller = new InformationWindowController<Company>(CompanyWindowViewModel, companies_ComboBox,
new TextBox[]
{
companyName_TextBox,
companyStreet_TextBox,
companyCity_TextBox,
companyPostalCode_TextBox,
companyID_TextBox,
companyAccountNumber_TextBox,
companyBankName_TextBox,
companyBankBIC_TextBox,
companyBillerName_TextBox,
companyPhoneNumber_TextBox,
companyEmailAddress_TextBox
});
}
private DataProvider()
{
Companies = new CompanyRepository();
Addresses = new AddressRepository();
Accounts = new AccountRepsitory();
Employees = new EmployeeRepository();
Transactions = new TransactionRepository();
}
protected void OnDropdownCompany_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e)
{
string companyName = e.Text;
if (!string.IsNullOrEmpty(companyName))
{
List<Company> list = new CompanyRepository().FindByName(companyName);
ddlCompany.DataSource = list;
ddlCompany.DataBind();
}
}
public Importer(GetOldDbAsModel getOldDbAsModel,
CompanyRepository companyRepository,
PersonRepository personRepository,
PoliticianRepository politicianRepository,
ClubRepository clubRepository,
TruncateTable truncateTable)
{
_getOldDbAsModel = getOldDbAsModel;
_companyRepository = companyRepository;
_personRepository = personRepository;
_politicianRepository = politicianRepository;
_clubRepository = clubRepository;
_truncateTable = truncateTable;
}
public MainWindow()
{
InitializeComponent();
model = new EzBillingModel();
clientRepository = new ClientRepository(model);
companyRepository = new CompanyRepository(model);
billRepository = new BillRepository(model);
excelConnection = new ExcelConnection();
billManager = new BillManager();
clientWindow = new clientWindow(clientRepository, billRepository, billManager);
companyWindow = new companyWindow(companyRepository, billRepository, billManager);
clientWindow.Closing += new CancelEventHandler(window_Closing);
companyWindow.Closing += new CancelEventHandler(window_Closing);
ClientViewModel = new InformationWindowViewModel<Client>();
ClientViewModel.Items = new ObservableCollection<Client>(clientRepository.All.ToList());
CompanyViewModel = new InformationWindowViewModel<Company>();
CompanyViewModel.Items = new ObservableCollection<Company>(companyRepository.All.ToList());
CompanyViewModel.PropertyChanged += CompanyViewModel_PropertyChanged;
ProductViewModel = new InformationWindowViewModel<Product>();
ProductViewModel.Items = new ObservableCollection<Product>();
ProductViewModel.PropertyChanged += ProductViewModel_PropertyChanged;
BillViewModel = new InformationWindowViewModel<Bill>();
BillViewModel.Items = new ObservableCollection<Bill>();
BillViewModel.PropertyChanged += BillViewModel_PropertyChanged;
this.Closing += MainWindow_Closing;
productSectionInputFields = new TextBox[]
{
productName_TextBox,
productQuantity_TextBox,
productUnit_TextBox,
productUnitPrice_TextBox,
productVATPercent_TextBox
};
DataContext = this;
excelConnection.Open();
}
protected void OnBtnOkClicked(object sender, EventArgs e)
{
if (gridCompany.SelectedValue != null)
{
int companyID = (int)gridCompany.SelectedValue;
Company selectedCompany = new CompanyRepository().FindOne(companyID);
string argument = selectedCompany.CompanyID.ToString() + "/"
+ selectedCompany.CompanyName;
string script = "<script type=\"text/javascript\">";
script += " OnBtnOkClientClicked(\"" + argument + "\");";
script += " </script>";
if (!ClientScript.IsClientScriptBlockRegistered("redirectUser"))
ClientScript.RegisterStartupScript(this.GetType(), "redirectUser", script);
}
}
public void Should_Get_Company()
{
try
{
var uow = new UnitOfWork<PersonsContext>();
var companyRepository = new CompanyRepository(uow);
var companies = companyRepository.GetAll();
Assert.IsNotNull(companies);
Assert.IsTrue(companies.Any());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public ActionResult UpdateDatapoints(Company.ConstituentOfIndex? index)
{
// TODO This can be done in one select
var companyRepository = new CompanyRepository();
var companyList = new List<Company>();
companyList.AddRange(companyRepository.FindByIndex(Company.ConstituentOfIndex.Ftse100));
companyList.AddRange(companyRepository.FindByIndex(Company.ConstituentOfIndex.Ftse250));
companyList.AddRange(companyRepository.FindByIndex(Company.ConstituentOfIndex.SmallCap));
foreach (var company in companyList)
{
try
{
dataManagementService.InsertNewQuotesToDb(company.Symbol);
}
catch (Exception)
{
//TODO: Remove this once bug fixed
}
}
this.TempData["message"] = "Datapoints Updated For Index " + index;
return this.RedirectToAction("Index");
}
public void Should_Update_ToolsLocalization_In_Company()
{
try
{
var personContext = new PersonsContext();
var uow = new UnitOfWork<PersonsContext>();
var companyRepository = new CompanyRepository(uow);
var CompanyAreaRepository = new CompanyAreaRepository(uow);
var CompanyArea =
CompanyAreasDummies.CreateListOfCompanyAreas().FirstOrDefault(t => t.Id == 2);
var company = companyRepository.GetById(4);
CompanyAreaRepository.Add(CompanyArea);
uow.Save();
company.CompanyAreas.Add(CompanyAreaRepository.GetById(6));
companyRepository.Update(company);
uow.Save();
Assert.IsNotNull(personContext.Companies.FirstOrDefault(c => c.Name == "Portoverano"));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Console.WriteLine(("Property: {0} Error: {1}"), validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
catch (Exception ex)
{
Console.WriteLine((" Error: {0}"), ex.Message);
}
}
public void UpdateCompany(Company company)
{
var repository = new CompanyRepository(_db);
repository.Edit(company);
repository.Save();
}
public SearchCompanyController(CompanyRepository companyRepo,
SessionSearch sessionSearch)
{
_companyRepo = companyRepo;
_sessionSearch = sessionSearch;
}
protected void Page_Load(object sender, EventArgs e)
{
if (SessionManager.CurrentUser == null)
{
Common.RedirectToLoginPage(this);
return;
}
else if (!IsPostBack)
{
FillLabelLanguage();
InitData();
if (!string.IsNullOrEmpty(SessionManager.BackUrl)
&& SessionManager.BackUrl.Contains("Companies.aspx")
&& !string.IsNullOrEmpty(Request.QueryString["backurl"])
&& Request.QueryString["backurl"] == "visible")
{
lnkBack.Visible = true;
}
else
{
SessionManager.BackUrl = null;
lnkBack.Visible = false;
}
if (!string.IsNullOrEmpty(Request.QueryString["CompanyId"]))
{
lnkAddNewDocument.Attributes.Add("onclick", string.Format("OnComDocumentEditClientClicked({0},\"\")", Request.QueryString["CompanyID"]));
int companyD = int.Parse(Request.QueryString["CompanyId"]);
CompanyRepository companyRepo = new CompanyRepository();
Company currentCompany = companyRepo.FindOne(companyD);
SessionManager.CurrentCompany = currentCompany;
SaveLastViewCompaniesToCookie(currentCompany);
string script1 = "<script type='text/javascript'>";
script1 += "onSaveOrLoadCompanyProfilePage();";
script1 += "</script>";
if (!ClientScript.IsClientScriptBlockRegistered("onSaveOrLoadCompanyProfilePage"))
ClientScript.RegisterStartupScript(this.GetType(), "onSaveOrLoadCompanyProfilePage", script1);
//Fill data for grids.
FillDataGrid(currentCompany);
FillCurrentCompanyInfo(currentCompany);
if (Request.QueryString["originalPage"] == "Action")
{
lnkBackToAction.Visible = true;
lnkBack.Visible = false;
hidActionUrl.Value = Request.UrlReferrer.PathAndQuery;
}
else
{
lnkBackToAction.Visible = false;
}
if (Request.QueryString["mode"] == "view")
{
EnableCompanyControls(false);
}
else
EnableCompanyControls(true);
if (!string.IsNullOrEmpty(Request.QueryString["tab"]))// == "action")
{
switch (Request.QueryString["tab"])
{
case "action":
radTabStripCompany.FindTabByValue("Actions").Selected = true;
radTabStripCompany.FindTabByValue("Actions").PageView.Selected = true;
break;
case "job":
radTabStripCompany.FindTabByValue("Job").Selected = true;
radTabStripCompany.FindTabByValue("Job").PageView.Selected = true;
break;
case "invoice":
radTabStripCompany.FindTabByValue("Invoice").Selected = true;
radTabStripCompany.FindTabByValue("Invoice").PageView.Selected = true;
break;
}
}
//show the company title
lblCompanyProfileTitle.Text = string.Format(ResourceManager.GetString("lblRightPaneCompanyProfileTitle"), currentCompany.CompanyName);
}
else
{
SessionManager.CurrentCompany = null;
SessionManager.NewCompanyContactList = new List<CompanyContact>();
FillDataGrid(null);
EnableCompanyControls(true);
btnEditSave.Text = ResourceManager.GetString("saveText");
//lnkAddContact.Visible = false;
//lnkAddContactInfo.Visible = false;
lnkAddContact.OnClientClick = "return OnAddNewCompanyContactClientClicked('')";
SessionManager.NewCompanyContactList = null;
lnkAddNewAction.Visible = false;
chkRemoveLogo.Visible = false;
lnkAddNewDocument.Visible = false;
//show the title
lblCompanyProfileTitle.Text = ResourceManager.GetString("lblRightPaneAddNewCompanyTitle");
}
}
string script = "<script type='text/javascript'>";
script += "onLoadCompanyProfilePage();";
script += "</script>";
if (!ClientScript.IsClientScriptBlockRegistered("LoadCompanyProfilePage"))
ClientScript.RegisterStartupScript(this.GetType(), "LoadCompanyProfilePage", script);
}
public Search(CompanyRepository companyRepository)
{
_companyRepository = companyRepository;
}
public HttpResponseMessage Invite(Bizdoc.Data.ViewModels.InviteUserModel model)
{
if (model.companyId==0)
{
ModelState.AddModelError("companyId", "companyId must be a valid number");
}
if (!ModelState.IsValid)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
//Get the current user who is inviting
var header = ControllerContext.Request.Headers.SingleOrDefault(x => x.Key == "ApiTicket");
UserTicket ticket = TicketManager.getTicket(header.Value.First());
//get the company that the user is invited to
Company company = new CompanyRepository().GetById(model.companyId);
//Check if user is allowed to invite
if (!ticket.user.affiliations.Any(o => o.company.id==company.id && (o.role.name.Equals("Ejer") || o.role.name.Equals("Admin"))))
{
return Request.CreateErrorResponse(HttpStatusCode.Forbidden, "User is not allowed to invite users to company " + company.name);
}
if (model.role.name==null)
{
model.role = new RoleRepository().GetById(model.role.id);
}
if (model.role.name.Equals("Ejer"))
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Only one user can be owner");
}
if (model.role.name.Equals("Admin"))
{
if (!ticket.user.affiliations.Any(o => o.company.id == company.id && o.role.name.Equals("Ejer")))
{
return Request.CreateErrorResponse(HttpStatusCode.Forbidden, "Only owners can grant admin");
}
}
//Get user or create new
User user = new UserRepository().GetByEmail(model.email);
if (user==null)
{
user = UserManager.createUserFromInvite(model.email, false);
}
//Get role and check if valid role name
Role role = new RoleRepository().GetByName(model.role.name);
if (role==null)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Invalid role name");
}
if (user.affiliations.Any(x => x.company.id==company.id))
{
return Request.CreateErrorResponse(HttpStatusCode.Conflict, "Affiliation already exists");
}
UserAffiliation newAffiliation = AffiliationManager.inviteUser(user, company, role, ticket.user);
return Request.CreateResponse(HttpStatusCode.Created, newAffiliation);
}
private Company SaveCompanyData()
{
if (string.IsNullOrEmpty(txtCompanyName.Text))
{
string message = ResourceManager.GetString("messageComNameMustNotBeEmpty");
string script = "<script type=\"text/javascript\">";
script += " alert(\"" + message + "\")";
script += " </script>";
if (!ClientScript.IsClientScriptBlockRegistered("redirectUser"))
ClientScript.RegisterStartupScript(this.GetType(), "redirectUser", script);
return null;
}
bool isNew = false;
//Save Company
Company currentCompany = new Company();
if (SessionManager.CurrentCompany != null)
{
currentCompany = SessionManager.CurrentCompany;
}
else
{
isNew = true;
currentCompany = new Company();
}
//header
currentCompany.CompanyName = txtCompanyName.Text.Trim();
currentCompany.WebLink = txtWebsite.Text.Trim();
if (!string.IsNullOrEmpty(ddlNeosResp.SelectedValue))
currentCompany.Responsible = ddlNeosResp.SelectedValue;
else
currentCompany.Responsible = null;
//tab contact info
currentCompany.Address = txtCompanyAddress.Text.Trim();
currentCompany.ZipCode = txtCompanyZipCode.Text.Trim();
currentCompany.City = txtCompanyCity.Text.Trim();
currentCompany.Email = txtCompanyEmail.Text.Trim();
currentCompany.TelephoneZone = txtCompanyPhoneArea.Text.Trim();
currentCompany.Group = txtCompanyGroup.Text.Trim();
currentCompany.Telephone = txtCompanyPhone.Text.Trim();
currentCompany.Fax = txtCompanyFax.Text.Trim();
currentCompany.NVAT = txtCompanyVAT.Text.Trim();
if (!string.IsNullOrEmpty(ddlCompanyLegalForm.SelectedValue))
currentCompany.LegalForm = ddlCompanyLegalForm.SelectedValue;
else
currentCompany.LegalForm = null;
if (!string.IsNullOrEmpty(ddlParamClientStatus.SelectedValue))
currentCompany.Status = int.Parse(ddlParamClientStatus.SelectedValue);
else
currentCompany.Status = null;
//tab client info
currentCompany.Activity = txtActivity.Text.Trim();
currentCompany.Remark = txtRemark.Text.Trim();
currentCompany.CreatedDate = datCreatedDate.SelectedDate;
if (!string.IsNullOrEmpty(ddlUnit.SelectedValue))
currentCompany.UnitCode = ddlUnit.SelectedValue;
else
currentCompany.UnitCode = null;
currentCompany.SponsorArea = chkSponsor.Checked;
CompanyRepository repo = new CompanyRepository();
if (isNew)
{
currentCompany.CreatedDate = DateTime.Now;
repo.Insert(currentCompany);
}
else
repo.Update(currentCompany);
//insert company logo
if (chkRemoveLogo.Checked)
{
CompanyLogoRepository companyLogoRepo = new CompanyLogoRepository();
companyLogoRepo.Delete(new CompanyLogo(currentCompany.CompanyID));
}
else
{
if (fileCompanyLogo.HasFile)
{
string fileName = string.Format("{0}_{1}", currentCompany.CompanyID, System.IO.Path.GetFileName(fileCompanyLogo.PostedFile.FileName.ToString()));//fileCompanyLogo.PostedFile.FileName
CompanyLogoRepository companyLogoRepo = new CompanyLogoRepository();
CompanyLogo logo = companyLogoRepo.FindOne(new CompanyLogo(currentCompany.CompanyID));
if (logo != null)
{
logo.LogoPath = WebConfig.UserImagePath + fileName;
companyLogoRepo.Update(logo);
}
else
{
logo = new CompanyLogo();
logo.CompanyID = currentCompany.CompanyID;
logo.LogoPath = WebConfig.UserImagePath + fileName;
companyLogoRepo.Insert(logo);
}
fileCompanyLogo.SaveAs(WebConfig.UserImages + fileName);
}
}
currentCompany = repo.FindOne(currentCompany);
SessionManager.CurrentCompany = currentCompany;
SaveLastViewCompaniesToCookie(currentCompany);
if (isNew)
{
string script1 = "<script type='text/javascript'>";
script1 += "onSaveOrLoadCompanyProfilePage();";
script1 += "</script>";
if (!ClientScript.IsClientScriptBlockRegistered("onSaveOrLoadCompanyProfilePage"))
ClientScript.RegisterStartupScript(this.GetType(), "onSaveOrLoadCompanyProfilePage", script1);
}
//Save company contact
SaveCompanyContact(currentCompany);
return currentCompany;
}
private string GetEmailOfCompany(int companyID)
{
IList<CompanyAddress> addressList = new CompanyAddressRepository().GetAddressesOfCompany(companyID);
foreach (CompanyAddress addr in addressList)
{
if (!string.IsNullOrEmpty(addr.Email))
return addr.Email;
}
Company com = new CompanyRepository().FindOne(new Company(companyID));
if (com != null)
return com.Email;
return "";
}
private void BindLast5ViewedCompany()
{
//Company
//Last 5 viewed company.
XmlDocument doc = new XmlDocument();
IList<Company> last5Companies = new List<Company>();
try
{
doc.Load(Server.MapPath("~/App_Data/LastViewedCompanies.xml"));
XmlElement rootNode = doc.DocumentElement;
if (rootNode != null)
{
XmlNode userNode = rootNode.SelectSingleNode("User[@id='" + SessionManager.CurrentUser.UserID + "']");
if (userNode != null) //user node existed
{
if (userNode.Attributes["viewed-companies"] != null && !string.IsNullOrEmpty(userNode.Attributes["viewed-companies"].Value))
{
List<string> list = new List<string>(userNode.Attributes["viewed-companies"].Value.Split('&'));
foreach (string companyID in list)
{
if (!string.IsNullOrEmpty(companyID))
{
Company com = new CompanyRepository().FindOne(Convert.ToInt32(companyID));
if (com != null)
{
last5Companies.Add(com);
}
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
/*
if (lastComCookie != null)
{
CompanyRepository canRepo = new CompanyRepository();
string[] values = lastComCookie.Values.ToString().Split('&');
if (values.Length > 0 && !string.IsNullOrEmpty(values[0]))
{
string idList = string.Empty;
for (int i = 0; i < values.Length; i++)
{
string[] userAndComIds = values[i].Split('=');
if (userAndComIds[0] == SessionManager.CurrentUser.UserID.Trim())
{
idList = userAndComIds[1];
break;
}
}
if (idList != string.Empty)
{
string[] idArray = idList.Split('A');
for (int j = idArray.Length - 1; j >= 0; j--)
{
int id = int.Parse(idArray[j]);
Company com = canRepo.FindOne(new Company(id));
if (com != null)
{
last5Companies.Add(com);
}
}
}
}
}
*/
rptLastViewedCompanies.DataSource = last5Companies;
rptLastViewedCompanies.DataBind();
}
public static CompanyRepository GetCompanyRepository(IUnitOfWork unitOfWork)
{
var repository = new CompanyRepository();
repository.UnitOfWork = unitOfWork;
return repository;
}
public ICollection<Company> GetCompanies()
{
var repository = new CompanyRepository(_db);
return repository.GetAll().ToList();
}
public ICollection<Company> SearchCompanyByName(string searchTerm)
{
var repository = new CompanyRepository(_db);
return repository.SearchCompanyByName(searchTerm);
}
public void CreateCompany(Company company)
{
var repository = new CompanyRepository(_db);
repository.Add(company);
repository.Save();
}
public Company GetCompany(int Id)
{
var repository = new CompanyRepository(_db);
return repository.FindBy(c => c.Id == Id).SingleOrDefault();
}
public ICollection<Company> GetCompaniesById(ICollection<int> listOfIds)
{
var repository = new CompanyRepository(_db);
return repository.FindBy(c => listOfIds.Contains(c.Id)).ToList();
}
private void BindCompanyGrid(GridSortCommandEventArgs sortEventArgs)
{
if (!string.IsNullOrEmpty(txtName.Text))
{
int pageSize = 10;
int pageNumber = gridCompany.CurrentPageIndex + 1;
string sortExpress = string.Empty;
string sortExpressInvert = string.Empty;
foreach (GridSortExpression item in gridCompany.MasterTableView.SortExpressions)
{
GridSortOrder newSortOrder = item.SortOrder;
if (sortEventArgs != null && item.FieldName == sortEventArgs.SortExpression)
{
newSortOrder = sortEventArgs.NewSortOrder;
}
if (!string.IsNullOrEmpty(sortExpress) && newSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (newSortOrder == GridSortOrder.Ascending)
{
sortExpress += item.FieldName + " ASC";
sortExpressInvert += item.FieldName + " DESC";
}
else if (newSortOrder == GridSortOrder.Descending)
{
sortExpress += item.FieldName + " DESC";
sortExpressInvert += item.FieldName + " ASC";
}
}
if (sortEventArgs != null && !sortExpress.Contains(sortEventArgs.SortExpression))
{
if (!string.IsNullOrEmpty(sortExpress) && sortEventArgs.NewSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (sortEventArgs.NewSortOrder == GridSortOrder.Ascending)
{
sortExpress += sortEventArgs.SortExpression + " ASC";
sortExpressInvert += sortEventArgs.SortExpression + " DESC";
}
else if (sortEventArgs.NewSortOrder == GridSortOrder.Descending)
{
sortExpress += sortEventArgs.SortExpression + " DESC";
sortExpressInvert += sortEventArgs.SortExpression + " ASC";
}
}
if (!string.IsNullOrEmpty(sortExpress))
{
if (sortExpress.Contains("CompanyName"))
{
sortExpress = sortExpress.Replace("CompanyName", "SocNom");
sortExpressInvert = sortExpressInvert.Replace("CompanyName", "SocNom");
}
if (sortExpress.Contains("City"))
{
sortExpress = sortExpress.Replace("City", "Commune");
sortExpressInvert = sortExpressInvert.Replace("City", "Commune");
}
if (sortExpress.Contains("StatusLabel"))
{
sortExpress = sortExpress.Replace("StatusLabel", "StatusLabel");
sortExpressInvert = sortExpressInvert.Replace("StatusLabel", "StatusLabel");
}
if (sortExpress.Contains("Responsible"))
{
sortExpress = sortExpress.Replace("Responsible", "Responsable");
sortExpressInvert = sortExpressInvert.Replace("Responsible", "Responsable");
}
if (sortExpress.Contains("CreatedDate"))
{
sortExpress = sortExpress.Replace("CreatedDate", "DateCreation");
sortExpressInvert = sortExpressInvert.Replace("CreatedDate", "DateCreation");
}
}
else
{
sortExpress = "SocNom ASC";
sortExpressInvert = "SocNom DESC";
}
CompanyRepository companyRepo = new CompanyRepository();
gridCompany.VirtualItemCount = companyRepo.CountSearchCompaniesByName(txtName.Text);
gridCompany.DataSource = companyRepo.FindByName(txtName.Text,
pageSize, pageNumber, sortExpress, sortExpressInvert);
}
else
{
IList<Company> comList = new List<Company>();
gridCompany.DataSource = comList;
}
}
protected void OnCompanyDropdownItemRequested(object o, RadComboBoxItemsRequestedEventArgs e)
{
string companyName = e.Text;
if (!string.IsNullOrEmpty(companyName))
{
CompanyRepository companyRepo = new CompanyRepository();
ddlCompany.DataTextField = "CompanyName";
ddlCompany.DataValueField = "CompanyID";
ddlCompany.DataSource = companyRepo.FindByName(companyName);// .GetAllCompanies();
ddlCompany.DataBind();
}
}
public ActionResult UserManage()
{
ViewBag.Organization = CompanyRepository.SelOrganization();
return(View());
}
private void GetCompanyGridDataSource(GridSortCommandEventArgs sortEventArgs)
{
int pageNumber = CompanyGrid.CurrentPageIndex + 1;
string sortExpress = string.Empty;
string sortExpressInvert = string.Empty;
foreach (GridSortExpression item in CompanyGrid.MasterTableView.SortExpressions)
{
GridSortOrder newSortOrder = item.SortOrder;
if (sortEventArgs != null && item.FieldName == sortEventArgs.SortExpression)
{
newSortOrder = sortEventArgs.NewSortOrder;
}
if (!string.IsNullOrEmpty(sortExpress) && newSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (newSortOrder == GridSortOrder.Ascending)
{
sortExpress += item.FieldName + " ASC";
sortExpressInvert += item.FieldName + " DESC";
}
else if (newSortOrder == GridSortOrder.Descending)
{
sortExpress += item.FieldName + " DESC";
sortExpressInvert += item.FieldName + " ASC";
}
}
if (sortEventArgs != null && !sortExpress.Contains(sortEventArgs.SortExpression))
{
if (!string.IsNullOrEmpty(sortExpress) && sortEventArgs.NewSortOrder != GridSortOrder.None)
{
sortExpress += ", ";
sortExpressInvert += ", ";
}
if (sortEventArgs.NewSortOrder == GridSortOrder.Ascending)
{
sortExpress += sortEventArgs.SortExpression + " ASC";
sortExpressInvert += sortEventArgs.SortExpression + " DESC";
}
else if (sortEventArgs.NewSortOrder == GridSortOrder.Descending)
{
sortExpress += sortEventArgs.SortExpression + " DESC";
sortExpressInvert += sortEventArgs.SortExpression + " ASC";
}
}
if (!string.IsNullOrEmpty(sortExpress))
{
if (sortExpress.Contains("CompanyName"))
{
sortExpress = sortExpress.Replace("CompanyName", "SocNom");
sortExpressInvert = sortExpressInvert.Replace("CompanyName", "SocNom");
}
if (sortExpress.Contains("City"))
{
sortExpress = sortExpress.Replace("City", "Commune");
sortExpressInvert = sortExpressInvert.Replace("City", "Commune");
}
if (sortExpress.Contains("StatusLabel"))
{
sortExpress = sortExpress.Replace("StatusLabel", "StatusLabel");
sortExpressInvert = sortExpressInvert.Replace("StatusLabel", "StatusLabel");
}
if (sortExpress.Contains("Responsible"))
{
sortExpress = sortExpress.Replace("Responsible", "Responsable");
sortExpressInvert = sortExpressInvert.Replace("Responsible", "Responsable");
}
if (sortExpress.Contains("CreatedDate"))
{
sortExpress = sortExpress.Replace("CreatedDate", "DateCreation");
sortExpressInvert = sortExpressInvert.Replace("CreatedDate", "DateCreation");
}
}
else
{
sortExpress = "SocNom ASC";
sortExpressInvert = "SocNom DESC";
}
CompanyRepository companyRepo = new CompanyRepository();
List<Company> companyList = new List<Company>();
/*if (!string.IsNullOrEmpty(Request.QueryString["type"])) //search by type
{
switch (Request.QueryString["type"])
{
case "all":
CompanyGrid.VirtualItemCount = companyRepo.CountAllCompanies();
companyList = companyRepo.GetAllCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "client":
CompanyGrid.VirtualItemCount = companyRepo.CountCustomerCompanies();
companyList = companyRepo.GetCustomerCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "prospect":
CompanyGrid.VirtualItemCount = companyRepo.CountPropectCompanies();
companyList = companyRepo.GetPropectCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "inactive":
CompanyGrid.VirtualItemCount = companyRepo.CountInactiveCompanies();
companyList = companyRepo.GetInactiveCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
default:
CompanyGrid.VirtualItemCount = companyRepo.CountAllCompanies();
companyList = companyRepo.GetAllCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
}
}
else*/
//if ((!string.IsNullOrEmpty(Request.QueryString["cname"]))) // search by name
//{
if (!string.IsNullOrEmpty(Request.QueryString["ctype"]))
{
switch(Request.QueryString["ctype"])
{
case "all":
CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByName(Request.QueryString["cname"]);
companyList = companyRepo.FindByName(Request.QueryString["cname"], pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "client":
CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByNameAndType(Request.QueryString["cname"], "1");
companyList = companyRepo.FindByNameAndType(Request.QueryString["cname"],"1", pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "prospect":
CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByNameAndType(Request.QueryString["cname"], "2");
companyList = companyRepo.FindByNameAndType(Request.QueryString["cname"], "2", pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
case "inactive":
CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByNameAndType(Request.QueryString["cname"], "0");
companyList = companyRepo.FindByNameAndType(Request.QueryString["cname"], "0", pageSize, pageNumber, sortExpress, sortExpressInvert);
break;
}
}
else
{
//CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByName(Request.QueryString["cname"]);
//companyList = companyRepo.FindByName(Request.QueryString["cname"], pageSize, pageNumber, sortExpress, sortExpressInvert);
companyList = companyRepo.GetTopCompany(pageSize);
}
//}
//else //view a number of recent company
//{
// companyList = companyRepo.GetTopCompany(pageSize);
//}
CompanyGrid.DataSource = companyList;
}
public void DeleteCompany(int Id)
{
var repository = new CompanyRepository(_db);
repository.Delete(Id);
repository.Save();
}
public void OwnedCollectionRemove()
{
using (var uow = new TestDbContext(_connection, new GraphdiffAggregateUpdateStrategy()))
{
var company1 = uow.Companies
.Include(p => p.Contacts.Select(m => m.Infos))
.Single(p => p.Id == 2);
var contact = company1.Contacts.Single();
company1.Contacts.Remove(contact);
var repo = new CompanyRepository(uow);
repo.AlterarAgregacao(company1, cfg => cfg.HasMany(c => c.Contacts));
uow.Commit();
}
using (var uow = new TestDbContext(_connection))
{
var company = uow.Companies.Include(p => p.Contacts.Select(m => m.Infos)).Single(p => p.Id == 2);
Assert.IsTrue(company.Contacts.Count == 0);
}
}
protected void OnMyAjaxManagerAjaxRequest(object sender, AjaxRequestEventArgs e)
{
if (e.Argument.IndexOf("RebindContactGrid") != -1)
{
//System.Threading.Thread.Sleep(1000);
//divContact.Visible = true;
//divContact.Style.Add("display", "block");
CompanyAjaxManager.AjaxSettings.AddAjaxSetting(CompanyAjaxManager, CompanyContactGrid);
CompanyAjaxManager.AjaxSettings.AddAjaxSetting(CompanyAjaxManager, pnlAddContact);
string[] args = e.Argument.Split('/');
if (args.Length == 3)
{
try
{
int companyID = Int32.Parse(args[1]);
int rowIndex = Int32.Parse(args[2]);
CompanyGrid.MasterTableView.ClearSelectedItems();
CompanyGrid.MasterTableView.Items[rowIndex - 1].Selected = true;
}
catch (Exception ex) { throw ex; }
CompanyContactGrid.Rebind();
}
}
else if (e.Argument.IndexOf("RebindContactInfoGrid") != -1)
{
//divContactInfo.Style.Add("display","block");
CompanyAjaxManager.AjaxSettings.AddAjaxSetting(CompanyAjaxManager, ContactInfoGrid);
CompanyAjaxManager.AjaxSettings.AddAjaxSetting(CompanyAjaxManager, pnlAddContactInfo);
string[] args = e.Argument.Split('/');
if (args.Length == 3)
{
try
{
int contactID = Int32.Parse(args[1]);
int rowIndex = Int32.Parse(args[2]);
CompanyContactGrid.MasterTableView.ClearSelectedItems();
CompanyContactGrid.MasterTableView.Items[rowIndex - 1].Selected = true;
}
catch (Exception ex)
{
throw ex;
}
ContactInfoGrid.Rebind();
}
}
else if (e.Argument.IndexOf("AddCompanyContact") != -1)
{
CompanyAjaxManager.AjaxSettings.AddAjaxSetting(CompanyAjaxManager, CompanyContactGrid);
string[] args = e.Argument.Split('/');
if (args.Length == 2)
{
try
{
int companyID = Int32.Parse(args[1]);
CompanyContactRepository contactRepo = new CompanyContactRepository();
CompanyContact contact = new CompanyContact();
contact.CompanyID = companyID;
contact.LastName = txtLastName.Text.Trim();
contact.FirstName = txtFirstName.Text.Trim();
contact.Position = ddlFunction.Text;
contactRepo.Insert(contact);
CompanyContactGrid.Rebind();
}
catch (Exception ex)
{
throw ex;
}
}
}
else if (e.Argument.IndexOf("AddContactInfo") != -1)
{
CompanyAjaxManager.AjaxSettings.AddAjaxSetting(CompanyAjaxManager, ContactInfoGrid);
string[] args = e.Argument.Split('/');
if (args.Length == 2)
{
try
{
int contactID = Int32.Parse(args[1]);
CompanyContactTelephoneRepository contactInfoRepo = new CompanyContactTelephoneRepository();
CompanyContactTelephone contactInfo = new CompanyContactTelephone();
contactInfo.ContactID = contactID;
contactInfo.Type = ddlType.SelectedValue;
contactInfo.TelephoneZone = txtPhoneZone.Text.Trim();
contactInfo.Tel = txtInfo.Text.Trim();
contactInfo.Location = txtPlace.Text.Trim();
contactInfoRepo.Insert(contactInfo);
ContactInfoGrid.Rebind();
}
catch (Exception ex)
{
throw ex;
}
}
}
else if (e.Argument.IndexOf("DeleteSelectedCompany") != -1)
{
if (CompanyGrid.SelectedItems.Count == 1)
{
CompanyAjaxManager.AjaxSettings.AddAjaxSetting(CompanyAjaxManager, CompanyGrid);
CompanyRepository companyRepo = new CompanyRepository();
companyRepo.Delete(new Company(GetSelectedCompanyID()));
CompanyGrid.Rebind();
}
}
else if (e.Argument.IndexOf("OpenSeletectedCompany") != -1)
{
if (CompanyGrid.SelectedItems.Count == 1)
{
Response.Redirect(string.Format("~/CompanyProfile.aspx?CompanyId={0}&mode=edit&backurl=visible", GetSelectedCompanyID()), true);
}
}
else if (e.Argument.IndexOf("ViewCompanyActions") != -1)
{
if (CompanyGrid.SelectedItems.Count == 1)
{
Response.Redirect(string.Format("~/CompanyProfile.aspx?CompanyId={0}&tab=action&mode=edit&backurl=visible", GetSelectedCompanyID()), true);
}
}
else if (e.Argument.IndexOf("ViewCompanyJobs") != -1)
{
if (CompanyGrid.SelectedItems.Count == 1)
{
Response.Redirect(string.Format("~/CompanyProfile.aspx?CompanyId={0}&tab=job&mode=edit&backurl=visible", GetSelectedCompanyID()), true);
}
}
else if (e.Argument.IndexOf("ViewCompanyInvoices") != -1)
{
if (CompanyGrid.SelectedItems.Count == 1)
{
Response.Redirect(string.Format("~/InvoicesPage.aspx?type=search&customer={0}", GetSelectedCompanyID()), true);
}
}
}
public ControlPanelCompanyHandler(CompanyRepository companyRepository)
{
_companyRepository = companyRepository;
}
