public async void GetRealtorTest()
{
Realtor actual = (await _controller.GetRealtor(2)).Value;
Assert.NotNull(actual);
Assert.Equal("Petr", actual.Firstname);
}
private void UpdateButton_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(firstNameTextbox.Text) || string.IsNullOrEmpty(lastNameTextbox.Text) ||
string.IsNullOrEmpty(patronymicTextbox.Text))
{
MessageBox.Show("Все поля должны быть заполнены: Фамилия, Имя, Отчество.");
return;
}
if (_realtor == null)
{
Realtor realtor = new Realtor
{
LastName = lastNameTextbox.Text,
FirstName = firstNameTextbox.Text,
Patronymic = patronymicTextbox.Text,
CommissionShare = string.IsNullOrWhiteSpace(commissionTextbox.Text) ? 0 : Convert.ToInt32(commissionTextbox.Text)
};
RealtorRepository.Create(realtor);
}
else
{
_realtor.LastName = string.IsNullOrWhiteSpace(lastNameTextbox.Text) ? null : lastNameTextbox.Text;
_realtor.FirstName = string.IsNullOrWhiteSpace(firstNameTextbox.Text) ? null : firstNameTextbox.Text;
_realtor.Patronymic = string.IsNullOrWhiteSpace(patronymicTextbox.Text) ? null : patronymicTextbox.Text;
_realtor.CommissionShare = string.IsNullOrWhiteSpace(commissionTextbox.Text) ? 0 : int.Parse(commissionTextbox.Text);
RealtorRepository.Update(_realtor);
}
MessageBox.Show("Действие успешно совершено.");
MainFrameHolder.MainFrame.Navigate(new RealtorPage());
}
static void Main(string[] args)
{
Realtor realtor = new Realtor("Graygray");
House house = new House();
realtor.ShowHouse(house);
}
public async Task <IActionResult> Edit(int id, [Bind("RealtorID,UserID,CompanyID,Name,Title,Description,Phone,Email,Website,City,State,Zip,Address,Status")] Realtor realtor)
{
if (id != realtor.RealtorID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(realtor);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RealtorExists(realtor.RealtorID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
ViewData["CompanyID"] = new SelectList(_context.Company, "CompanyID", "CompanyID", realtor.CompanyID);
return(View(realtor));
}
static public async Task <Realtor> SameName(Realtor realtor)
{
var realtors = await App.Database.GetRealtorsAsync();
int nameCount = 1;
bool result = realtor.Name.Any(x => char.IsNumber(x));
while (result)
{
realtor.Name = realtor.Name.Substring(1, realtor.Name.Length - 1);
result = realtor.Name.Any(x => char.IsNumber(x));
}
foreach (var r in realtors)
{
if (r.Name.Contains(realtor.Name.TrimStart()))
{
nameCount++;
}
}
realtor.Name = nameCount + " " + realtor.Name.TrimStart();
return(realtor);
}
public async Task <IActionResult> Edit(int id, [Bind("RealtorId,LicenseNumber,FirstName,LastName,CompanyName,EmailAddress,PhoneNumber,IdentityUserId")] Realtor realtor)
{
if (id != realtor.RealtorId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(realtor);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RealtorExists(realtor.RealtorId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(realtor));
}
public async Task <IActionResult> CreateRealtor([FromBody] Realtor realtor)
{
_context.Realtor.Add(realtor);
await _context.SaveChangesAsync();
return(Ok());
}
private void button_Save_Realtor_Click(object sender, RoutedEventArgs e)
{
if (Check())
{
try
{
if (_realtor.id == 0)
{
_realtor.Name = textBoxName.Text;
_realtor.Surname = textBoxSurname.Text;
_realtor.Patronymic = textBoxPatronymic.Text;
_realtor.ShareOfCommission = int.Parse(textBoxShareOfCommission.Text);
demEntities.Realtor.Add(_realtor);
MessageBox.Show("Риэлтор добавлен");
}
else
{
Realtor tempRealtor = demEntities.Realtor.FirstOrDefault(re => re.id == _realtor.id);
tempRealtor.ShareOfCommission = int.Parse(textBoxShareOfCommission.Text);
tempRealtor.Name = textBoxName.Text;
tempRealtor.Surname = textBoxSurname.Text;
tempRealtor.Patronymic = textBoxPatronymic.Text;
MessageBox.Show("Риэлтор изменен");
}
demEntities.SaveChanges();
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
if (Check())
{
try
{
if (_realtor.Id == 0)
{
_realtor.Surname = Surname.Text;
_realtor.Name = Name.Text;
_realtor.MiddleName = MiddleName.Text;
_realtor.ShareOfTheCommission = int.Parse(ShareOfTheCommission.Text);
coFatckEntities.Realtor.Add(_realtor);
}
else
{
Realtor tempRealtor = coFatckEntities.Realtor.FirstOrDefault(u => u.Id == _realtor.Id);
tempRealtor.Surname = Surname.Text;
tempRealtor.Name = Name.Text;
tempRealtor.MiddleName = MiddleName.Text;
tempRealtor.ShareOfTheCommission = int.Parse(ShareOfTheCommission.Text);
}
coFatckEntities.SaveChanges();
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
}
}
public bool AuthenticateUser(Realtor realtor)
{
//TODO: Once authenticated, persist authentication through the application
//Get proper user, decrypt password and validate whether passwords are the same
if (sqlConn.State == System.Data.ConnectionState.Open)
{
string query = "select * from Realtors where Username = '******'";
SqlCommand cmd = new SqlCommand(query, sqlConn);
SqlDataReader reader = cmd.ExecuteReader();
bool returnVal = false;
while (reader.Read())
{
if (realtor.password == Decryptdata((string)reader["Password"]))
{
returnVal = true;
}
else
{
returnVal = false;
}
}
return(returnVal);
}
else
{
return(false);
}
}
public async Task <IActionResult> EditRealtor(EditRealtorViewModel model)
{
if (ModelState.IsValid)
{
var realtor = await _realtorRepo.GetRealtor(model.Id);
realtor.Name = model.Name;
realtor.Description = model.Description;
realtor.Email = model.Email;
realtor.Phone = model.Phone;
realtor.IsMvp = model.IsMvp;
if (model.Image != null)
{
if (model.ExistingImage != null)
{
string filePath = Path.Combine(_hostEnvironment.WebRootPath, "images", "realtors", model.ExistingImage);
System.IO.File.Delete(filePath);
}
;
realtor.Image = UploadedFile(model.Image);
}
;
Realtor updatedRealtor = _realtorRepo.Update(realtor);
return(RedirectToAction("Index"));
}
;
return(View());
}
public Realtor Update(Realtor realtorChanges)
{
var realtor = context.Realtors.Attach(realtorChanges);
realtor.State = Microsoft.EntityFrameworkCore.EntityState.Modified;
context.SaveChanges();
return(realtorChanges);
}
public async void DeleteRealtorTest()
{
Realtor expected = (await _controller.DeleteRealtor(1)).Value;
Realtor actual = (await _controller.GetRealtor(expected.Id)).Value;
Assert.NotNull(expected);
Assert.Null(actual);
}
public static void Create(Realtor realtor)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
context.Realtor.Add(realtor);
context.SaveChanges();
}
}
public ActionResult DeleteConfirmed(int id)
{
Realtor realtor = db.Realtors.Find(id);
db.Realtors.Remove(realtor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void Delete(Realtor realtor)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
context.Entry(realtor).State = EntityState.Deleted;
context.SaveChanges();
}
}
public static void Update(Realtor realtor)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
context.Realtor.Attach(realtor);
context.Entry(realtor).State = EntityState.Modified;
context.SaveChanges();
}
}
public AddRedactForRealtor(Realtor realtor)
{
InitializeComponent();
Surname.Text = realtor.Surname;
Name.Text = realtor.Name;
MiddleName.Text = realtor.MiddleName;
ShareOfTheCommission.Text = realtor.ShareOfTheCommission.ToString();
_realtor.Id = realtor.Id;
}
private void Button_Click_3(object sender, RoutedEventArgs e)
{
if (Realtors.SelectedItems.Count > 0)
{
Realtor realtors = (Realtor)Realtors.SelectedItems[0];
AddRedactForRealtor redactForRealtor = new AddRedactForRealtor(realtors);
redactForRealtor.Show();
}
}
public EditRealtorWindow(Realtor realtor)
{
InitializeComponent();
textBoxName.Text = realtor.Name;
textBoxPatronymic.Text = realtor.Patronymic;
textBoxShareOfCommission.Text = realtor.ShareOfCommission.ToString();
textBoxSurname.Text = realtor.Surname;
_realtor.id = realtor.id;
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
if (Realtors.SelectedItems.Count > 0)
{
Realtor realtors = (Realtor)Realtors.SelectedItems[0];
coFatckEntities.Realtor.Remove(realtors);
coFatckEntities.SaveChanges();
}
}
private void button_Edit_Realtor_Click(object sender, RoutedEventArgs e)
{
if (dataGrid.SelectedItems.Count > 0)
{
Realtor realtor = (Realtor)dataGrid.SelectedItems[0];
EditRealtorWindow editRealtorWindow = new EditRealtorWindow(realtor);
editRealtorWindow.Show();
}
}
public ActionResult Edit([Bind(Include = "ID,FirstName,LastName,Phone,Email")] Realtor realtor)
{
if (ModelState.IsValid)
{
db.Entry(realtor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(realtor));
}
public IActionResult Create([FromBody] Realtor item)
{
if (item == null)
{
return(BadRequest());
}
_context.Realtors.Add(item);
_context.SaveChanges();
return(CreatedAtRoute("GetRealtor", new { id = item.Id }, item));
}
public async Task <IActionResult> Get(int id)
{
Realtor realtor = await db.Realtors.FirstOrDefaultAsync(x => x.Id == id);
if (realtor == null)
{
return(NotFound());
}
return(new ObjectResult(realtor));
}
public IActionResult Get(long id)
{
Realtor realtor = db.Realtors.FirstOrDefault(x => x.Id == id);
if (realtor == null)
{
return(NotFound());
}
return(new ObjectResult(realtor));
}
public ActionResult Create([Bind(Include = "ID,FirstName,LastName,Phone,Email")] Realtor realtor)
{
if (ModelState.IsValid)
{
db.Realtors.Add(realtor);
db.SaveChanges();
return(RedirectToAction("Create", "Inspections"));
}
return(View(realtor));
}
public IActionResult Post([FromBody] Realtor realtor)
{
if (realtor == null)
{
return(BadRequest());
}
realtor.DateTime = DateTime.Now;
db.Add(realtor);
db.SaveChanges();
return(Ok(realtor));
}
public AddEditRealtorPage(Realtor selectedRealtor)
{
if (selectedRealtor != null)
{
_currentRealtor = demoExamDBEntities.Realtors.Find(selectedRealtor.Id);
}
DataContext = _currentRealtor;
InitializeComponent();
}
public void AddRealtor(Realtor realtor)
{
Connect(@"C:\BD\RealtorEstateAgancy.sqlite");
connection.Open();
command = new SQLiteCommand("insert into Realtor(fio, login, password, telephoneNumber) values ("
+ "'" + realtor.fio + "', " +
"'" + realtor.login + "', " +
"'" + realtor.password + "', " +
"'" + realtor.telephoneNumber + "');", connection);
command.ExecuteNonQuery();
connection.Close();
}