/// <summary>
/// Deprecated Method for adding a new object to the Companies EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToCompanies(Company company)
{
base.AddObject("Companies", company);
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
SelectedTabElement = 1;
if (LoggedIsUser == null)//means its sign-up process
{
if (ValidateFields() && !companyNameAlreadyExists())
{
User user = new User
{
ReceiveEmails = checkbox.Checked,
FullName = GetFullName(),
Surname = surname.Text,
Forename = firstname.Text,
JobTitle = jobtitle.Text,
Email = emailfield.Text,
Password = Utility.GetMd5Sum(passwordfield.Text),
ReminderQuestionID = byte.Parse(listForgotPasswordQuestion.SelectedValue),
ReminderQuestion = listForgotPasswordQuestion.SelectedItem.Text,
ReminderAnswer = Utility.GetMd5Sum(txtForgotPasswordAnswer.Text),
CreationDate = DateTime.Now,
LastAmendmentDate = DateTime.Now,
Type = Enum.GetName(typeof(Enums.ENTITY_TYPE), Enums.ENTITY_TYPE.COMPANY_ADMIN),
Deleted = false,
OnHold = false,
Verified = false,
Enabled = true,
UserUID = Guid.NewGuid().ToString(),
VerificationCode = Guid.NewGuid().ToString(),
Approved = 0,
PaymentType = 0,
LoginAttempts = 0
};
Address address = fillAddress(user, Enums.ADDRESS_TYPE.PERSONAL);
Address companyAddress = fillAddress(user, Enums.ADDRESS_TYPE.COMPANY);
user.Addresses.Add(address);
user.Addresses.Add(companyAddress);
Simplicity.Data.Company company = new Simplicity.Data.Company();
company.Name = companyname.Text;
company.Address = companyAddress;
DatabaseContext.AddToCompanies(company);
DatabaseContext.SaveChanges();
user.CompanyID = company.CompanyID;
DatabaseContext.SaveChanges();
//call health and safety stored procedure over here to insert company there as well
addCompanyToHS(user);
EmailUtility.SendAccountCreationEmail(user, passwordfield.Text);
Response.Redirect("~/ConfirmMail.aspx");
}
}
else
{
if (companyNameAlreadyExists())
{
return;
}
bool newCompanyAdded = false;
User user = (from c in DatabaseContext.Users where c.UserID == LoggedIsUser.UserID select c).FirstOrDefault();
user.FullName = GetFullName();
user.Surname = surname.Text;
user.Forename = firstname.Text;
user.JobTitle = jobtitle.Text;
if (user.Company == null)//it means i am an old user and i dont have any company attached yet
{
Simplicity.Data.Company company = new Simplicity.Data.Company();
company.Name = companyname.Text;
Address companyAddr = fillAddress(user, Enums.ADDRESS_TYPE.COMPANY);
company.Address = companyAddr;
user.Company = company;
newCompanyAdded = true;
}
user.Company.Name = companyname.Text;
user.LastAmendmentDate = DateTime.Now;
foreach (Address address in user.Addresses)
{
if (address.MultiAddressType == "PERSONAL")
{
address.AddressFull = GetFullAddress();
address.AddressNo = addressno.Text;
address.AddressLine1 = addressline1.Text;
address.AddressLine2 = addressline2.Text;
address.AddressLine3 = addressline3.Text;
address.AddressLine4 = addressline4.Text;
address.AddressLine5 = addressline5.Text;
address.PostalCode = postalcode.Text;
address.Telephone1 = telephone1.Text;
address.Telephone2 = telephone2.Text;
address.Fax = fax.Text;
address.Mobile = mobile.Text;
address.Town = town.Text;
address.County = County.Text;
address.Country = country.Text;
address.LastAmendmentDate = DateTime.Now;
address.AddressName = null;
address.LastAmendedBy = null;
}
}
DatabaseContext.SaveChanges();
SetSuccessMessage("Save information successfully.");
if (newCompanyAdded) addCompanyToHS(user);
}
}
/// <summary>
/// Create a new Company object.
/// </summary>
/// <param name="companyID">Initial value of the CompanyID property.</param>
/// <param name="name">Initial value of the Name property.</param>
/// <param name="addressID">Initial value of the AddressID property.</param>
public static Company CreateCompany(global::System.Int32 companyID, global::System.String name, global::System.Int32 addressID)
{
Company company = new Company();
company.CompanyID = companyID;
company.Name = name;
company.AddressID = addressID;
return company;
}
protected void AddCompanyAdmin_Click(object source, EventArgs e)
{
if (ValidateFields())
{
String CompanyType = Enum.GetName(typeof(Enums.ENTITY_TYPE), Enums.ENTITY_TYPE.USER);
if (!companyNameAlreadyExistsUsingName())
{
CompanyType = Enum.GetName(typeof(Enums.ENTITY_TYPE), Enums.ENTITY_TYPE.COMPANY_ADMIN);
User user = new User
{
ReceiveEmails = checkbox.Checked,
FullName = GetFullName(),
Surname = surname.Text,
Forename = firstname.Text,
JobTitle = jobtitle.Text,
Email = emailfield.Text,
Password = Utility.GetMd5Sum(passwordfield.Text),
ReminderQuestionID = byte.Parse(listForgotPasswordQuestion.SelectedValue),
ReminderQuestion = listForgotPasswordQuestion.SelectedItem.Text,
ReminderAnswer = Utility.GetMd5Sum(txtForgotPasswordAnswer.Text),
CreationDate = DateTime.Now,
LastAmendmentDate = DateTime.Now,
Type = CompanyType,
Deleted = false,
OnHold = false,
Verified = true,
Enabled = true,
UserUID = Guid.NewGuid().ToString(),
VerificationCode = Guid.NewGuid().ToString(),
Approved = 0,
PaymentType = 0,
LoginAttempts = 0
};
Address address = fillAddressUser(user, Enums.ADDRESS_TYPE.PERSONAL);
Address companyAddress = fillAddressUser(user, Enums.ADDRESS_TYPE.COMPANY);
user.Addresses.Add(address);
user.Addresses.Add(companyAddress);
//Simplicity.Data.Company company = (from c in DatabaseContext.Companies where c.Name == companyname.Text select c).FirstOrDefault();
Simplicity.Data.Company company = new Simplicity.Data.Company();
company.Name = CompanyTabCompanyName.Text;
company.Address = companyAddress;
DatabaseContext.AddToCompanies(company);
DatabaseContext.SaveChanges();
user.CompanyID = company.CompanyID;
//DatabaseContext.Users.AddObject(user);
DatabaseContext.SaveChanges();
//call health and safety stored procedure over here to insert company there as well
DatabaseUtility.addCompanyToHS(user);
// EmailUtility.SendAccountCreationEmail(user, passwordfield.Text);
SetSuccessMessage("Company added successfully.");
Response.Redirect("~/Admin/ManageCompanies.aspx");
}
}
}
private void deleteCompanyRow(int companyId)
{
if (companyId >= 0)
{
this.company = (from c in DatabaseContext.Companies where c.CompanyID == companyId select c).FirstOrDefault();//select company
this.company.Address.Deleted = true;//delete address
IEnumerable<Simplicity.Data.CompanyProduct> products = from cp in DatabaseContext.CompanyProducts where cp.CompanyID == companyId select cp;
foreach (CompanyProduct product in products)
{
DatabaseContext.CompanyProducts.DeleteObject(product);
}//delete all company products.
IEnumerable<User> users = from usrs in DatabaseContext.Users where usrs.CompanyID == companyId select usrs;
foreach (User usr in users)
{
usr.CompanyID = null;
usr.Deleted = true;
}//delete users belong to the company also set company id to null so that foriegn key constraint allows company to be deleted.
DatabaseContext.Companies.DeleteObject(this.company);
DatabaseContext.SaveChanges();
if (SearchTextBox.Text.ToString().CompareTo("") != 0)
{
this.SetWhereClause();
}
else
{
//SimplicityDataSource.AutoGenerateWhereClause = false;
UserGrid.DataBind();
}
}
}
private bool companyNameAlreadyExistsUsingName()
{
Simplicity.Data.Company company = null;
company = (from c in DatabaseContext.Companies where c.Name == CompanyTabCompanyName.Text select c).FirstOrDefault();
if (company != null)
{
if (company.Users != null && company.Users.Count > 0)
SetErrorMessage("Company already exist. Please Contact " + company.Users.FirstOrDefault().Email);
else
SetErrorMessage("Company already exist");
return true;
}
else return false;
}
protected void Page_Load(object sender, EventArgs e)
{
String strCompId = Request["companyId"];
if (strCompId != null && strCompId.CompareTo("") != 0){
int id = Int32.Parse(strCompId);
this.company = (from c in DatabaseContext.Companies where c.CompanyID == id select c).FirstOrDefault();
}
if (!IsPostBack)
{
ContentPlaceHolder myContent = (ContentPlaceHolder)this.Master.FindControl("BodyContentPlaceHolder");
HtmlGenericControl gridBoxDiv = (HtmlGenericControl)myContent.FindControl("GridDiv");
HtmlGenericControl editCompanyDiv = (HtmlGenericControl)myContent.FindControl("EditCompanyDetailsDiv");
if (company != null) {
gridBoxDiv.Visible = false;
editCompanyDiv.Visible = true;
companyname.Text = company.Name;
addressno.Text = company.Address.AddressNo;
addressline1.Text = company.Address.AddressLine1;
addressline2.Text = company.Address.AddressLine2;
addressline3.Text = company.Address.AddressLine3;
addressline4.Text = company.Address.AddressLine4;
addressline5.Text = company.Address.AddressLine5;
postalcode.Text = company.Address.PostalCode;
town.Text = company.Address.Town;
County.Text = company.Address.County;
country.Text = company.Address.Country;
telephone1.Text = company.Address.Telephone1;
telephone2.Text = company.Address.Telephone2;
fax.Text = company.Address.Fax;
mobile.Text = company.Address.Mobile;
}
else {
gridBoxDiv.Visible = true;
editCompanyDiv.Visible = false;
}
}
SimplicityDataSource.Where = "";
if (SearchTextBox.Text.ToString().CompareTo("") != 0)
{
this.searchCompanies();
}
}
