public bool Save()
{
bool fielddataOk = ValidateFields();
if (fielddataOk)
{
if (CurrentEstateAgent == null)
{
CurrentEstateAgent = EstateAgentController.Instance.MakeNewEstateAgent(stbName.Text, stbPhone.Text,
stbEmail.Text, (DateTime)dafStartDate.GetDateTime(), dafTerminationDate.GetDateTime(), stbUsername.Text, stbPassword.Text);
EstateAgentController.Instance.SaveActiveEstateAgent();
if (CurrentEstateAgent.Id == -1)
{
MessageBox.Show("Tilykke, du fandt en fejl!");
fielddataOk = false;
}
}
else
{
EstateAgentController.Instance.SetActiveEstateAgent(CurrentEstateAgent);
EstateAgentController.Instance.SetName(stbName.Text);
EstateAgentController.Instance.SetTelephone(stbPhone.Text);
EstateAgentController.Instance.SetEmail(stbEmail.Text);
EstateAgentController.Instance.SetStartingDate((DateTime)dafStartDate.GetDateTime());
EstateAgentController.Instance.SetTerminationDate(dafTerminationDate.GetDateTime());
EstateAgentController.Instance.SaveActiveEstateAgent();
}
}
return(fielddataOk);
}
internal void AddToCatalog(EstateAgent estateAgent)
{
if (!estateAgents.ContainsKey(estateAgent.Id))
{
estateAgents.Add(estateAgent.Id, estateAgent);
}
}
internal void RemoveFromCatalog(EstateAgent estateAgent)
{
if (estateAgents.ContainsKey(estateAgent.Id))
{
estateAgents.Remove(estateAgent.Id);
}
}
public static void ShowBaseForm(EstateAgent estateAgent)
{
Thread loginThread = new Thread(RunBaseForm); //Kalder metoden RunLogin i en ny tråd
loginThread.SetApartmentState(ApartmentState.STA); //Indstiller tråden til at køre med en enkelt tråd
loginThread.Start(estateAgent); //Starter tråden med en parameter
}
/// <summary>
/// Sætter mægler
/// </summary>
/// <param name="estateAgent"></param>
/// <author>Mathias Poulsen</author>
public void SetEstateAgent(EstateAgent estateAgent)
{
if (activeCase.EstateAgent != estateAgent)
{
activeCase.EstateAgent = estateAgent;
}
}
private void PerformLogin()
{
//Hvis input er gyldig, prøv at logge ind
if (stbUsername.Validate() && stbPassword.Validate())
{
string username = stbUsername.Text;
string password = stbPassword.Text;
EstateAgent estateAgent = EstateAgentController.Instance.LoginEstateAgent(username, password);
//Hvis estateAgent ikke er null, var login'et korrekt
if (estateAgent != null)
{
if (chbAutoLogin.Checked)
{
SaveAutomaticLogin(username, password);
}
OpenMainForm(estateAgent);
}
else
{
MessageBox.Show("Forkerte log ind oplysninger", "Living Smart", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
/// <summary>
/// Distributes Cases to EstateAgents based on the Key in given in the constructor.
/// The key could be the price of the house
/// </summary>
/// <returns>Returns a dictionary containing Broker as key and a list of Cases as value.</returns>
/// <author>René Sørensen</author>>
public Dictionary <EstateAgent, List <Case> > ReturnOpenHouseShuffle()
{
LoadPriorityQueue();
if (brokers.Count > 0)
{
int brokerIndex = 0;
while (pq.Count > 0)
{
if (brokerIndex == 0)
{
Shuffle(brokers);
}
EstateAgent b = brokers[brokerIndex];
Case c = pq.RemoveMax();
if (!openHouse.ContainsKey(b))
{
openHouse.Add(b, new List <Case>());
}
openHouse[b].Add(c);
brokerIndex = (brokerIndex + 1) % brokers.Count;
}
}
return(openHouse);
}
public async Task <EstateAgent> AddEstateAgent(EstateAgent estateAgent)
{
var result = await _directoryContext.EstateAgent.AddAsync(estateAgent);
await _directoryContext.SaveChangesAsync();
return(result.Entity);
}
public EstateAgentLine(BaseForm baseForm, EstateAgent estateAgent)
{
this.estateAgent = estateAgent;
this.baseForm = baseForm;
InitializeComponent();
UpdateFields();
}
private void FinishCreating(EstateAgent estateAgent)
{
EstateAgentController.Instance.CancelActiveEstateAgent();
if (callback != null)
{
callback(estateAgent);
}
Close();
}
public OpenHousePair(EstateAgent agent, List <Case> cases)
{
EstateAgent = agent;
Properties = cases;
InitializeComponent();
UpdateFields();
UpdateList();
}
private void UpdateEstateAgent(EstateAgent estateAgent)
{
if (estateAgent != null)
{
CaseController.Instance.SetEstateAgent(estateAgent);
lblEstateAgentName.Text = estateAgent.Name;
}
}
public EstateAgentLineSelect(SelectEstateAgentDropIn dropIn, EstateAgent estateAgent)
{
EstateAgent = estateAgent;
this.dropIn = dropIn;
InitializeComponent();
UpdateFields();
BindEvent(this);
}
public EstateAgentLineSearch(EstateAgentSearchDropIn dropIn, EstateAgent estateAgent)
{
this.dropIn = dropIn;
EstateAgent = estateAgent;
InitializeComponent();
UpdateFields();
BindEvent(this);
}
/// <summary>
///
/// </summary>
/// <param name="estateAgent"></param>
/// <author>Mathias Petersen</author>
internal void Save(EstateAgent estateAgent)
{
if (estateAgent.Id == -1)
{
estateAgent.Id = db.CreateEstateAgent(estateAgent);
}
else
{
db.UpdateEstateAgent(estateAgent);
}
}
private void NewEstateAgentAdded(EstateAgent estateAgent)
{
if (estateAgent != null)
{
var control = new EstateAgentLine(baseForm, estateAgent)
{
Margin = Padding.Empty
};
clsEstateAgents.AddControl(control);
sblActiveCases.Text = clsEstateAgents.Controls.Count.ToString();
}
}
public async Task <IActionResult> AddEstateAgent([FromBody] EstateAgentForAddDto estateAgent)
{
var estateAgentToCreate = new EstateAgent
{
Name = estateAgent.Name,
Gender = estateAgent.Gender,
Age = estateAgent.Age,
Login = estateAgent.Login,
LastActive = estateAgent.LastActive,
City = estateAgent.City
};
var creatEstateAgent = await _repo.AddEstateAgent(estateAgentToCreate);
return(StatusCode(201));
}
/// <summary>
/// Creates a new EstateAgent in the database.
/// </summary>
/// <param name="estateAgent">EstateAgent to be created.</param>
/// <returns>Returns the Id of the EstateAgent created.</returns>
/// <author>René Sørensen</author>
public int CreateEstateAgent(EstateAgent estateAgent)
{
SqlCommand cmd = new SqlCommand
{
CommandText = "INSERT INTO EstateAgent OUTPUT INSERTED.EstateAgentId VALUES (@Name, @Telephone, @Email, @StartingDate, @TerminationDate, @Username, @Password); "
};
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 50, "Name").Value = estateAgent.Name;
cmd.Parameters.Add("@Telephone", SqlDbType.NVarChar, 20, "Telephone").Value = estateAgent.Telephone;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar, 50, "Email").Value = estateAgent.Email;
cmd.Parameters.Add("@StartingDate", SqlDbType.Date, 8, "StartingDate").Value = estateAgent.StartingDate;
cmd.Parameters.Add("@TerminationDate", SqlDbType.Date, 8, "TerminationDate").Value = (object)estateAgent.TerminationDate ?? DBNull.Value;
cmd.Parameters.Add("@Username", SqlDbType.NVarChar, 15, "Username").Value = estateAgent.Username;
cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 25, "Password").Value = estateAgent.Password;
return((int)DBConnectionMSSQL.Instance.ExecuteScalar(cmd, -1));
}
private void PerformAutoLogin()
{
string username = Convert.ToString(RegistryWrapper.RegKey.GetValue("AutomaticLoginEstateAgentId", null));
string password = Convert.ToString(RegistryWrapper.RegKey.GetValue("AutomaticLoginPassword", null));
EstateAgent estateAgent = EstateAgentController.Instance.LoginEstateAgent(username, password);
if (estateAgent != null)
{
OpenMainForm(estateAgent);
}
else
{
ClearAutomaticLogin();
MessageBox.Show("Forkerte log ind oplysninger", "Living Smart", MessageBoxButtons.OK, MessageBoxIcon.Error);
stbUsername.Text = username;
}
}
/// <summary>
/// Returns an EstateAgent having the specified username and password.
/// </summary>
/// <param name="username">username of the estate agent.</param>
/// <param name="password">password of the estate agent.</param>
/// <returns>The estate agent having the given username and password, null otherwise</returns>
/// <author>René Sørensen</author>
public EstateAgent LoginEstateAgent(string username, string password)
{
EstateAgent estateAgent = null;
SqlCommand cmd = new SqlCommand
{
CommandText = "SELECT * FROM EstateAgent WHERE Username = (@Username) AND Password = (@Password);",
};
cmd.Parameters.Add("@Username", SqlDbType.NVarChar, 15, "Username").Value = username;
cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 25, "Password").Value = password;
SqlDataReader reader = null;
try
{
reader = DBConnectionMSSQL.Instance.ExecuteReader(cmd);
while (reader.Read())
{
int readEstateAgentId = (int)reader["EstateAgentId"];
string name = (string)reader["Name"];
string telephone = (string)reader["Telephone"];
string email = (string)reader["Email"];
DateTime startingDate = (DateTime)reader["StartingDate"];
DateTime?terminationDate = (reader["TerminationDate"].GetType() == typeof(DBNull)) ? null : (DateTime?)reader["TerminationDate"];
string usernameData = (string)reader["Username"];
string passwordData = (string)reader["Password"];
estateAgent = new EstateAgent(readEstateAgentId, name, telephone, email, startingDate, terminationDate, usernameData, passwordData);
}
}
catch (SqlException e)
{
Console.WriteLine(e.Message);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(estateAgent);
}
/// <summary>
/// Updates the information from an EstateAgent, in the database.
/// </summary>
/// <param name="estateAgent">EstateAgent to be updated.</param>
/// <author>René Sørensen</author>
public void UpdateEstateAgent(EstateAgent estateAgent)
{
int estateagentId = estateAgent.Id;
SqlCommand cmd = new SqlCommand
{
CommandText = "UPDATE EstateAgent SET Name = (@Name), Telephone = (@Telephone), Email = (@Email), StartingDate = (@StartingDate), TerminationDate = (@TerminationDate) WHERE EstateAgentId = (@EstateAgentId)"
};
cmd.Parameters.Add("@EstateAgentId", SqlDbType.Int, 4, "EstateAgentId").Value = estateagentId;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 50, "Name").Value = estateAgent.Name;
cmd.Parameters.Add("@Telephone", SqlDbType.NVarChar, 20, "Telephone").Value = estateAgent.Telephone;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar, 50, "Email").Value = estateAgent.Email;
cmd.Parameters.Add("@StartingDate", SqlDbType.Date, 8, "StartingDate").Value = estateAgent.StartingDate;
cmd.Parameters.Add("@TerminationDate", SqlDbType.Date, 8, "TerminationDate").Value = (object)estateAgent.TerminationDate ?? DBNull.Value;
DBConnectionMSSQL.Instance.ExecuteNonQuery(cmd);
}
public NewEstateAgentDropIn(BaseForm baseForm, EstateAgent estateAgent, NewEstateAgentFinish callback)
: base(baseForm)
{
InitializeComponent();
this.currentEstateAgent = estateAgent;
this.callback = callback;
if (currentEstateAgent != null)
{
btnSave.Text = @"Gem";
lblNewEstateAgent.Text = @"Redigér ejendomsmægler";
}
newEstateAgentForm = new NewEstateAgent(baseForm, estateAgent);
newEstateAgentForm.Anchor = AnchorStyles.Left | AnchorStyles.Right | AnchorStyles.Top;
newEstateAgentForm.Location = new Point(10, 10);
pnlContentHolder.Controls.Add(newEstateAgentForm);
}
/// <summary>
/// Returns all the EstateAgents from the database.
/// </summary>
/// <returns>Returns a List of all the EstateAgents from the database.</returns>
/// <author>René Sørensen</author>
public List <EstateAgent> ReadEstateAgents()
{
List <EstateAgent> estateAgentList = new List <EstateAgent>();
SqlCommand cmd = new SqlCommand
{
CommandText = "SELECT * FROM EstateAgent;",
};
SqlDataReader reader = null;
try
{
reader = DBConnectionMSSQL.Instance.ExecuteReader(cmd);
while (reader.Read())
{
int estateAgentId = (int)reader["EstateAgentId"];
string name = (string)reader["Name"];
string telephone = (string)reader["Telephone"];
string email = (string)reader["Email"];
DateTime startingDate = (DateTime)reader["StartingDate"];
DateTime?terminationDate = reader["TerminationDate"] is DBNull ? null : (DateTime?)reader["TerminationDate"];
string username = (string)reader["Username"];
string password = (string)reader["Password"];
EstateAgent estateAgent = new EstateAgent(estateAgentId, name, telephone, email, startingDate, terminationDate, username, password);
estateAgentList.Add(estateAgent);
}
}
catch (SqlException e)
{
Console.WriteLine(e.Message);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(estateAgentList);
}
public BaseForm(EstateAgent estateAgent)
{
AutoScaleMode = AutoScaleMode.None;
DefaultEstateAgent = estateAgent;
InitializeComponent();
InitializeSystem();
pages = new Page[Enum.GetNames(typeof(PagesIndex)).Length];
pages[GetPageIndex(PagesIndex.Overview)] = new Page(
typeof(Overview), "Oversigt",
Classes.Menu.MenuAnchor.Left
);
pages[GetPageIndex(PagesIndex.Cases)] = new Page(
typeof(Cases), "Sager",
Classes.Menu.MenuAnchor.Left
);
pages[GetPageIndex(PagesIndex.Customers)] = new Page(
typeof(Customers), "Kunder",
Classes.Menu.MenuAnchor.Left
);
pages[GetPageIndex(PagesIndex.EstateAgents)] = new Page(
typeof(EstateAgents), "Mæglere",
Classes.Menu.MenuAnchor.Left
);
pages[GetPageIndex(PagesIndex.Partners)] = new Page(
typeof(Partners), "Partnere",
Classes.Menu.MenuAnchor.Left
);
pages[GetPageIndex(PagesIndex.OpenHouse)] = new Page(
typeof(OpenHousePage), "Åbent hus",
Classes.Menu.MenuAnchor.Left
);
InitializePages();
InitializeMenu();
}
/// <summary>
/// Laver udskriftfil med statistik for solgte ejendomme for en bestemt mægler og et bestemt år
/// </summary>
/// <param name="fileStream"></param>
public static string CreatePrintEstateAgent(int estateAgentId, int year)
{
var list = StatisticsController.Instance.ReadEstateAgentStatistics(estateAgentId, year);
EstateAgent agent = EstateAgentController.Instance.GetEstateAgent(estateAgentId);
string page = "";
string[] headerText = { "Statistik på mægler: " + agent.Name,
" ",
" ",
"Statistik af solgte ejendomme i databasen for en udvalgt mægler og",
"et valgt år vist som summen af salgspriser og antal solgte ejendomme" };
page += CreateHeader(headerText);
page += docGen.FixedMultiColumnstext(new[]
{
new docGen.Column("Årstal", 15),
new docGen.Column("Måned", 20),
new docGen.Column("Salgspris total", 25),
new docGen.Column("Antal ejendomme", 40)
});
page += docGen.FilledLine();
foreach (Statistics statLine in list)
{
page += CreateStatisticsLineEstateAgent(statLine);
}
page += docGen.FilledLine();
//Hvis vi vil udregne total for alle mæglere så skriv det ind her
page += docGen.EmptyLine();
page += docGen.CreateFooterLine();
return(page);
}
public NewEstateAgent(BaseForm baseForm, EstateAgent estateAgent)
{
CurrentEstateAgent = estateAgent;
InitializeComponent();
if (estateAgent != null)
{
stbName.Text = estateAgent.Name;
stbPhone.Text = estateAgent.Telephone;
stbEmail.Text = estateAgent.Email;
dafStartDate.SetDate(estateAgent.StartingDate);
if (estateAgent.TerminationDate != null)
{
dafTerminationDate.SetDate((DateTime)estateAgent.TerminationDate);
}
stbUsername.Text = estateAgent.Username;
stbPassword.Text = estateAgent.Password;
stbUsername.Enabled = false;
stbPassword.Enabled = false;
}
}
private void FinishSearch(EstateAgent estateAgent)
{
baseForm.CloseDropIn(this);
callback(estateAgent);
}
/// <summary>
/// Tilføjer en mægler til kataloget
/// </summary>
/// <param name="estateAgent"></param>
private void AddEstateAgent(EstateAgent estateAgent)
{
estateAgentCatalog.AddToCatalog(estateAgent);
}
private void OpenMainForm(EstateAgent estateAgent)
{
formShift = true;
FormHandler.ShowBaseForm(estateAgent);
Close(); //Lukker Login formen
}
private void Callback(EstateAgent estateAgent)
{
UpdateFields();
}
