protected void btnUploadDealer_Click(object sender, EventArgs e)
{
if (fDealerUpload.HasFile)
{
lblError.Text = "";
string extension = System.IO.Path.GetExtension(fDealerUpload.PostedFile.FileName);
if (extension.ToLower() == ".csv")
{
string fileName = "csv_" + DateTime.Now.Ticks + "_" + fDealerUpload.FileName;
string fileNamePath = Server.MapPath(LWGUtils.GetCSVPath()) + fileName;
fDealerUpload.SaveAs(fileNamePath);
List <lwg_Dealer> dealerList = ParseCSVFileToDealerList(fileNamePath);
DealerBiz dealerBiz = new DealerBiz();
dealerBiz.SaveDealerFromList(dealerList);
}
else
{
lblError.Text = "Invalid extension.";
}
}
else
{
lblError.Text = "Please choose upload file";
}
}
private void BindGrid()
{
string name = txtSearchName.Text.Trim();
string address = txtSearchAddress.Text.Trim();
string id = txtSearchID.Text.Trim();
dealerBiz = new DealerBiz();
gvDealer.DataSource = dealerBiz.GetAllDealersBySearch(id, name, address);
gvDealer.DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (dealerBiz == null)
{
dealerBiz = new DealerBiz();
}
if (dealerBiz.DeleteDealer(DealerID))
{
Response.Redirect("dealer.aspx");
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (dealerBiz == null)
{
dealerBiz = new DealerBiz();
}
if (dealerBiz.IsDealerExist(txtCustomerID.Text.Trim()))
{
lblAddNewError.Text = GetLocaleResourceString("Dealer.DealerIDExistMessage");
return;
}
lwg_Dealer newDealer = new lwg_Dealer();
newDealer.DealerID = txtCustomerID.Text.Trim();
newDealer.AddressLine1 = txtAddress1.Text.Trim();
newDealer.AddressLine2 = txtAddress2.Text.Trim();
newDealer.City = txtCity.Text.Trim();
newDealer.Contact = txtContact.Text.Trim();
newDealer.Fax = txtFax.Text.Trim();
newDealer.Name = txtName.Text.Trim();
newDealer.NewIssue = txtNewIssue.Text.Trim();
newDealer.Phone = txtPhone.Text.Trim();
if (ddlUSState.SelectedValue == "00")
{
newDealer.State = txtState.Text.Trim();
}
else
{
newDealer.State = ddlUSState.SelectedValue;
}
newDealer.WebAddress = txtWebAddress.Text.Trim();
newDealer.Zip = txtZip.Text.Trim();
newDealer.AddressSearch = string.Format("{0} {1} {2} {3} {4}", txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), txtCity.Text.Trim(), txtState.Text.Trim(), txtZip.Text.Trim());
if (dealerBiz.AddDealer(newDealer))
{
Response.Redirect("dealer.aspx");
//pnlAddNew.Visible = false;
//pnlAddNewMessage.Visible = true;
}
else
{
pnlAddNew.Visible = true;
pnlAddNewMessage.Visible = false;
lblAddNewError.Text = GetLocaleResourceString("Dealer.AddFailMessage");
}
}
}
protected void ListDealerByState(string State)
{
try
{
DealerBiz dealerBiz = new DealerBiz();
List <lwg_Dealer> dealers = dealerBiz.GetDealersByState(State);
int total = dealers.Count;
int countEachColumn = int.Parse((Math.Ceiling((double)(total / 3.0)).ToString()));
this.ltrDealers1.Text = this.CreateHtml(dealers.Take(countEachColumn).ToList(), State, true);
this.ltrDealers2.Text = this.CreateHtml(dealers.Skip(countEachColumn).Take(countEachColumn).ToList(), State, false);
this.ltrDealers3.Text = this.CreateHtml(dealers.Skip(countEachColumn * 2).Take(countEachColumn).ToList(), State, false);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void ListDealerByFirstLetter(string FirstLetter)
{
try
{
DealerBiz pb = new DealerBiz();
List <lwg_Dealer> dealers = pb.GetDealersByFirstLetter(FirstLetter);
int total = dealers.Count;
int countEachColumn = int.Parse((Math.Ceiling((double)(total / 2.5)).ToString()));
this.ltrDealers1.Text = this.CreateHtml(dealers.Take(countEachColumn).ToList(), FirstLetter, true);
this.ltrDealers2.Text = this.CreateHtml(dealers.Skip(countEachColumn).Take(countEachColumn).ToList(), FirstLetter, false);
this.ltrDealers3.Text = this.CreateHtml(dealers.Skip(countEachColumn * 2).Take(countEachColumn).ToList(), FirstLetter, false);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
private void LoadDetail()
{
lblError.Text = string.Empty;
lblSuccess.Text = string.Empty;
if (Session["DealerUpdateSuccess"] != null)
{
lblSuccess.Text = Session["DealerUpdateSuccess"].ToString();
Session.Remove("DealerUpdateSuccess");
}
dealerBiz = new DealerBiz();
lwg_Dealer dealer = dealerBiz.GetDealerByDealerID(DealerID);
if (dealer != null)
{
txtDealerID.Text = dealer.DealerID;
txtAddress1.Text = dealer.AddressLine1;
txtAddress2.Text = dealer.AddressLine2;
txtCity.Text = dealer.City;
txtContact.Text = dealer.Contact;
txtFax.Text = dealer.Fax;
txtPhone.Text = dealer.Phone;
if (ddlUSState.Items.FindByValue(dealer.State) != null)
{
ddlUSState.Items.FindByValue(dealer.State).Selected = true;
txtState.Text = string.Empty;
txtState.Visible = false;
}
else
{
ddlUSState.Items.FindByValue("00").Selected = true;
txtState.Text = dealer.State;
}
txtWebAddress.Text = dealer.WebAddress;
txtZip.Text = dealer.Zip;
txtNewIssue.Text = dealer.NewIssue;
txtName.Text = dealer.Name;
}
else
{
Response.Redirect("Dealer.aspx");
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
dealerBiz = new DealerBiz();
foreach (GridViewRow row in gvDealer.Rows)
{
var cbDealer = row.FindControl("cbDealer") as CheckBox;
var hfDealerId = row.FindControl("hfDealerId") as HiddenField;
bool isChecked = cbDealer.Checked;
if (isChecked)
{
dealerBiz.DeleteDealer(hfDealerId.Value);
}
}
BindGrid();
}
catch (Exception ex)
{
ProcessException(ex);
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (dealerBiz == null)
{
dealerBiz = new DealerBiz();
}
lwg_Dealer dealer = dealerBiz.GetDealerByDealerID(DealerID);
lblError.Text = string.Empty;
lblSuccess.Text = string.Empty;
bool updateNewID = false;
if (txtDealerID.Text.Trim() != DealerID && dealerBiz.IsDealerExist(txtDealerID.Text.Trim()))
{
lblError.Text = GetLocaleResourceString("Dealer.DealerIDExistMessage");
return;
}
else
if (txtDealerID.Text.Trim() != DealerID && !dealerBiz.IsDealerExist(txtDealerID.Text.Trim())) // new id
{
updateNewID = true;
}
if (dealer != null)
{
dealer.AddressLine1 = txtAddress1.Text.Trim();
dealer.AddressLine2 = txtAddress2.Text.Trim();
dealer.City = txtCity.Text.Trim();
dealer.Contact = txtContact.Text.Trim();
dealer.Fax = txtFax.Text.Trim();
dealer.Name = txtName.Text.Trim();
dealer.NewIssue = txtNewIssue.Text.Trim();
dealer.Phone = txtPhone.Text.Trim();
if (ddlUSState.SelectedValue == "00")
{
dealer.State = txtState.Text.Trim();
}
else
{
dealer.State = ddlUSState.SelectedValue;
}
dealer.WebAddress = txtWebAddress.Text.Trim();
dealer.Zip = txtZip.Text.Trim();
dealer.AddressSearch = string.Format("{0} {1} {2} {3} {4}", txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), txtCity.Text.Trim(), txtState.Text.Trim(), txtZip.Text.Trim());
bool updateSuccess;
if (updateNewID)
{
updateSuccess = dealerBiz.UpdateDealer(dealer, txtDealerID.Text.Trim());
}
else
{
updateSuccess = dealerBiz.UpdateDealer(dealer, string.Empty);
}
if (updateSuccess)
{
if (updateNewID)
{
Session["DealerUpdateSuccess"] = GetLocaleResourceString("Dealer.UpdateSuccessMessage");
Response.Redirect(string.Format("dealerdetails.aspx?dealerid={0}", txtDealerID.Text.Trim()));
}
else
{
lblSuccess.Text = GetLocaleResourceString("Dealer.UpdateSuccessMessage");
}
}
else
{
lblError.Text = GetLocaleResourceString("Dealer.UpdateFailMessage");
}
}
}
}
private void ListDealers(DealerSortType sortType)
{
try
{
String[] htmlStr = new String[3];
DealerBiz dealerBiz = new DealerBiz();
int total = 0;
lblOutOfUS.Visible = false;
// List composers by 3 columns
int currentControlIndex = 0; // the current column index that appending composers.
int countAppended = 0; // the number of composers the current column had appended.
if (sortType == DealerSortType.Name)
{
#region sort by firtletter of name
List <lwg_Dealer> dealers = dealerBiz.GetAllDealers();
total = dealers.Count;
if (total == 0)
{
Response.Write("There is no dealer yet.");
}
int countEachColumn = 0;
countEachColumn = int.Parse((Math.Ceiling((double)(total / columnRatio)).ToString()));
int maxGroupCount = MaxFirstLetterGroup(dealers); // The max group items count.
if (maxGroupCount > countEachColumn)
{
countEachColumn = maxGroupCount;
}
for (int i = 65; i < 91; i++)
{
string firstLetter = Chr(i);
List <lwg_Dealer> subDealers = FilterDealerByFirstLetter(dealers, firstLetter);
int subCount = subDealers.Count;
if (subCount > 0)
{
if (subCount >= countEachColumn)
{
if (currentControlIndex >= 1 && currentControlIndex <= 2)
{
currentControlIndex += 1;
}
htmlStr[currentControlIndex] += CreateHtml(subDealers, firstLetter, true);
countAppended = countEachColumn;
}
else if (subCount + 1 > countEachColumn - countAppended)
{
if (currentControlIndex < 2)
{
currentControlIndex += 1;
}
// Generate html
htmlStr[currentControlIndex] += CreateHtml(subDealers, firstLetter, true);
countAppended = subCount + 1;
}
else
{
htmlStr[currentControlIndex] += CreateHtml(subDealers, firstLetter, true);
countAppended += subCount + 1;
}
}
}
this.ltrDealers1.Text = htmlStr[0];
this.ltrDealers2.Text = htmlStr[1];
this.ltrDealers3.Text = htmlStr[2];
#endregion
}
else
{
#region sort by state
lblOutOfUS.Visible = true;
#region US Dealers
List <lwg_Dealer> dealers = dealerBiz.GetAllUSDealers();
total = dealers.Count;
if (total == 0)
{
Response.Write("There is no dealer yet.");
}
int countEachColumn = 0;
countEachColumn = int.Parse((Math.Ceiling((double)(total / columnRatio)).ToString()));
int maxGroupCount = MaxStateGroup(dealers); // The max group items count.
if (maxGroupCount > countEachColumn)
{
countEachColumn = maxGroupCount;
}
List <string> stateList = dealerBiz.GetAllStateOfUS();
foreach (string state in stateList)
{
List <lwg_Dealer> subDealers = FilterDealerByState(dealers, state);
int subCount = subDealers.Count;
if (subCount > 0)
{
if (subCount >= countEachColumn)
{
if (currentControlIndex >= 1 && currentControlIndex <= 2)
{
currentControlIndex += 1;
}
htmlStr[currentControlIndex] += CreateHtml(subDealers, state, true);
countAppended = countEachColumn;
}
else if (subCount + 1 > countEachColumn - countAppended + 5)
{
if (currentControlIndex < 2)
{
currentControlIndex += 1;
}
// Generate html
htmlStr[currentControlIndex] += CreateHtml(subDealers, state, true);
countAppended = subCount + 1;
}
else
{
htmlStr[currentControlIndex] += CreateHtml(subDealers, state, true);
countAppended += subCount + 1;
}
}
}
this.ltrDealers1.Text = htmlStr[0];
this.ltrDealers2.Text = htmlStr[1];
this.ltrDealers3.Text = htmlStr[2];
#endregion
#region Out of US Dealers
dealers = dealerBiz.GetAllOutOfUSDealers();
total = dealers.Count;
if (total == 0)
{
return;
}
htmlStr = new String[3];
countEachColumn = 0;
countAppended = 0;
currentControlIndex = 0;
countEachColumn = int.Parse((Math.Ceiling((double)(total / columnRatio)).ToString()));
stateList = dealerBiz.GetAllStateOutOfUS();
foreach (string state in stateList)
{
List <lwg_Dealer> subDealers = FilterDealerByState(dealers, state);
int subCount = subDealers.Count;
if (subCount > 0)
{
if (subCount >= countEachColumn)
{
if (currentControlIndex >= 1 && currentControlIndex <= 2)
{
currentControlIndex += 1;
}
htmlStr[currentControlIndex] += CreateHtml(subDealers, state, true);
countAppended = countEachColumn;
}
else if (subCount + 1 > countEachColumn - countAppended + 5)
{
if (currentControlIndex < 2)
{
currentControlIndex += 1;
}
// Generate html
htmlStr[currentControlIndex] += CreateHtml(subDealers, state, true);
countAppended = subCount + 1;
}
else
{
htmlStr[currentControlIndex] += CreateHtml(subDealers, state, true);
countAppended += subCount + 1;
}
}
}
this.ltrDealers4.Text = htmlStr[0];
this.ltrDealers5.Text = htmlStr[1];
this.ltrDealers6.Text = htmlStr[2];
#endregion
#endregion
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadSortType();
if (!string.IsNullOrEmpty(Request.QueryString["Filter"]))
{
string alpha = "";
alpha = Request.QueryString["Filter"];
hdfalpha.Value = alpha;
string FirstLetter = Request.QueryString["Filter"].ToUpper();
int FirstLetterASCII = Asc(FirstLetter);
if (FirstLetterASCII >= 65 && FirstLetterASCII <= 90)
{
ListDealerByFirstLetter(FirstLetter);
ddlSortType.ClearSelection();
ddlSortType.Items.FindByText("Name").Selected = true;
divAlphabet.Visible = true;
divState.Visible = false;
return;
}
}
if (!string.IsNullOrEmpty(Request.QueryString["State"]))
{
string state = string.Empty;
state = Request.QueryString["State"].ToUpper();
DealerBiz dealerBiz = new DealerBiz();
if (dealerBiz.IsExistState(state))
{
ListDealerByState(state);
ddlSortType.ClearSelection();
ddlSortType.Items.FindByText("State").Selected = true;
divState.Visible = true;
divAlphabet.Visible = false;
ltrStateMenu.Text = CreateSelectionStateMenu(dealerBiz.GetAllStateOfUS(), state, false);
ltrOutofUsState.Text = CreateSelectionStateMenu(dealerBiz.GetAllStateOutOfUS(), state, true);
return;
}
else
if (state.ToLower() == allStatesOfUS)
{
ListDealers(DealerSortType.State);
ddlSortType.ClearSelection();
ddlSortType.Items.FindByText("State").Selected = true;
divState.Visible = true;
divAlphabet.Visible = false;
ltrStateMenu.Text = CreateSelectionStateMenu(dealerBiz.GetAllStateOfUS(), state.ToLower(), false);
ltrOutofUsState.Text = CreateSelectionStateMenu(dealerBiz.GetAllStateOutOfUS(), state.ToLower(), true);
return;
}
}
// default load all dealer
ListDealers(DealerSortType.Name);
divAlphabet.Visible = true;
divState.Visible = false;
}
}
