//фільтрування диллерів по місту
private void ComboxCity_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBoxDealer.Items.Clear();
DealerDTO dealerDTO = new DealerDTO();
string cityName = ComboBoxCity.SelectedItem.ToString();
var listDealerByCity = dealerDTO.GetListDealerByCity(cityName).ToArray();
ComboBoxDealer.Enabled = true;
ComboBoxDealer.Items.AddRange(listDealerByCity);
}
//додати нового диллера до бази даних
private void Add_NewDealer_Click(object sender, EventArgs e)
{
string addDealer = textBoxAddDealer.Text.Trim();
if (addDealer != "")
{
DealerDTO newDealer = new DealerDTO();
string message = newDealer.AddDealer(сomboxAddCity.SelectedItem.ToString(), addDealer);
MessageBox.Show(message);
}
else
{
MessageBox.Show("Потрібно написати назву Дилера!");
}
this.CleareAllComponent();
this.FillAlComponent();
}
/// <summary>
/// Crea una nueva Categoría desde un Datareader.
/// </summary>
/// <param name="dr">Objeto DataReader.</param>
/// <returns>Retorna un objeto Categoria.</returns>
private static DealerDTO LoadDealerDTO(IDataReader dr)
{
var Dealer = new DealerDTO
{
Id = GetDataValue <int>(dr, "Id"),
FirstName = GetDataValue <string>(dr, "FirstName"),
LastName = GetDataValue <string>(dr, "LastName"),
CategoryId = GetDataValue <int>(dr, "CategoryId"),
CategoryName = GetDataValue <string>(dr, "CategoryName"),
CountryId = GetDataValue <int>(dr, "CountryId"),
CountryName = GetDataValue <string>(dr, "CountryName"),
Description = GetDataValue <string>(dr, "Description"),
TotalProducts = GetDataValue <int>(dr, "TotalProducts"),
Rowid = GetDataValue <Guid>(dr, "Rowid"),
CreatedOn = GetDataValue <DateTime>(dr, "CreatedOn"),
CreatedBy = GetDataValue <int>(dr, "CreatedBy"),
ChangedOn = GetDataValue <DateTime>(dr, "ChangedOn"),
ChangedBy = GetDataValue <int>(dr, "ChangedBy")
};
return(Dealer);
}
private void ButtonRemoveDealer_Click(object sender, EventArgs e)
{
if (comboBoxRemoveCity.SelectedItem != null)
{
if (comboBoxRemoveDealer.SelectedItem != null)
{
string messageToRemove = "Дійсно видалити Дилера " + comboBoxRemoveCity.SelectedItem.ToString() + " - " + comboBoxRemoveDealer.SelectedItem.ToString() + " ?";
string caption = "Видалення з бази данних!";
DialogResult result = MessageBox.Show(messageToRemove, caption,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
DealerDTO newDealer = new DealerDTO();
string message = newDealer.RemoveDealer(comboBoxRemoveCity.SelectedItem.ToString(), comboBoxRemoveDealer.SelectedItem.ToString());
MessageBox.Show(message);
this.CleareAllComponent();
this.FillAlComponent();
comboBoxRemoveDealer.Enabled = false;
}
else
{
MessageBox.Show("Ви відмінили операцію видалення!");
}
this.CleareAllComponent();
this.FillAlComponent();
}
else
{
MessageBox.Show("Потрібно вибрати Дилера!");
}
}
else
{
MessageBox.Show("Потрібно вибрати Місто!");
this.CleareAllComponent();
this.FillAlComponent();
}
}
/// <summary>
/// to convert to DealerDto
/// </summary>
/// <param name="memberobj"></param>
/// <returns></returns>
public static DealerDTO MergeUserToDealerDto(User memberobj)
{
var dto = new DealerDTO()
{
CmsId = memberobj.SyncUID,
CmsFirstName = memberobj.FirstName,
CmsLastName = memberobj.LastName,
CmsUserName = memberobj.UserName,
Postcode = memberobj.ZipCode,
Email = memberobj.Email,
Active = (memberobj.IsLockedOut != null &&
(memberobj.IsLockedOut == false && memberobj.IsDeleted == false ? true : false)),
Status = BoolValue.TRUE, // Status = memberobj.IsApproved ? BoolValue.TRUE : BoolValue.FALSE,
// LastEditDate = memberobj.UpdatedDate.HasValue ? memberobj.UpdatedDate.Value : default(DateTime),
UserType = CmsUserType.DEALER
//addtional proerties are there but this will be used on further.
};
Dealer = dto;
Agent = null; //only for agent not to dealer
return(dto);
}
