public bool DeleteDealer(string dealerID)
{
lwg_Dealer dealerDeleted = dbContext.lwg_Dealer.Where(d => d.DealerID == dealerID).FirstOrDefault();
if (dealerDeleted != null)
{
dbContext.lwg_Dealer.Remove(dealerDeleted);
dbContext.SaveChanges();
return(true);
}
return(false);
}
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");
}
}
}
public bool AddDealer(lwg_Dealer _newDealer)
{
bool success = true;
try
{
_newDealer.AddressSearch = string.Format("{0}{1}{2}{3}{4}", _newDealer.AddressLine1.Trim(), string.IsNullOrEmpty(_newDealer.AddressLine2.Trim()) ? string.Empty : " " + _newDealer.AddressLine2.Trim()
, string.IsNullOrEmpty(_newDealer.City.Trim())?string.Empty:" " + _newDealer.City.Trim(), string.IsNullOrEmpty(_newDealer.State.Trim())?string.Empty:" " + _newDealer.State.Trim(), string.IsNullOrEmpty(_newDealer.Zip.Trim()) ? string.Empty : " " + _newDealer.Zip.Trim());
dbContext.lwg_Dealer.Add(_newDealer);
dbContext.SaveChanges();
}
catch (Exception ex)
{
LWGLog.WriteLog("Add Dealer", ex.Message);
success = false;
}
return(success);
}
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 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");
}
}
}
}
public bool UpdateDealer(lwg_Dealer _updateDealer, string newDealerID)
{
bool success = true;
try
{
lwg_Dealer updateDealer = dbContext.lwg_Dealer.Where(d => d.DealerID == _updateDealer.DealerID).FirstOrDefault();
if (updateDealer != null)
{
if (string.IsNullOrEmpty(newDealerID))
{
updateDealer.AddressLine1 = _updateDealer.AddressLine1;
updateDealer.AddressLine2 = _updateDealer.AddressLine2;
updateDealer.City = _updateDealer.City;
updateDealer.Contact = _updateDealer.Contact;
updateDealer.Fax = _updateDealer.Fax;
updateDealer.Name = _updateDealer.Name;
updateDealer.NewIssue = _updateDealer.NewIssue;
updateDealer.Phone = _updateDealer.Phone;
updateDealer.WebAddress = _updateDealer.WebAddress;
updateDealer.Zip = _updateDealer.Zip;
updateDealer.State = _updateDealer.State;
updateDealer.AddressSearch = string.Format("{0}{1}{2}{3}{4}", _updateDealer.AddressLine1.Trim(), string.IsNullOrEmpty(_updateDealer.AddressLine2.Trim()) ? string.Empty : " " + _updateDealer.AddressLine2.Trim()
, string.IsNullOrEmpty(_updateDealer.City.Trim()) ? string.Empty : " " + _updateDealer.City.Trim(), string.IsNullOrEmpty(_updateDealer.State.Trim()) ? string.Empty : " " + _updateDealer.State.Trim(), string.IsNullOrEmpty(_updateDealer.Zip.Trim()) ? string.Empty : " " + _updateDealer.Zip.Trim());
dbContext.SaveChanges();
}
else
{
lwg_Dealer newDealer = new lwg_Dealer();
newDealer.DealerID = newDealerID;
newDealer.AddressLine1 = _updateDealer.AddressLine1;
newDealer.AddressLine2 = _updateDealer.AddressLine2;
newDealer.City = _updateDealer.City;
newDealer.Contact = _updateDealer.Contact;
newDealer.Fax = _updateDealer.Fax;
newDealer.Name = _updateDealer.Name;
newDealer.NewIssue = _updateDealer.NewIssue;
newDealer.Phone = _updateDealer.Phone;
newDealer.WebAddress = _updateDealer.WebAddress;
newDealer.Zip = _updateDealer.Zip;
newDealer.State = _updateDealer.State;
newDealer.AddressSearch = string.Format("{0}{1}{2}{3}{4}", _updateDealer.AddressLine1.Trim(), string.IsNullOrEmpty(_updateDealer.AddressLine2.Trim()) ? string.Empty : " " + _updateDealer.AddressLine2.Trim()
, string.IsNullOrEmpty(_updateDealer.City.Trim()) ? string.Empty : " " + _updateDealer.City.Trim(), string.IsNullOrEmpty(_updateDealer.State.Trim()) ? string.Empty : " " + _updateDealer.State.Trim(), string.IsNullOrEmpty(_updateDealer.Zip.Trim()) ? string.Empty : " " + _updateDealer.Zip.Trim());
dbContext.lwg_Dealer.Remove(updateDealer); // remove old dealer
dbContext.lwg_Dealer.Add(newDealer); // add new dealer
dbContext.SaveChanges();
}
}
else
{
LWGLog.WriteLog("Update Dealer", string.Format("DealerID = {0} does not exist!", _updateDealer.DealerID));
success = false;
}
}
catch (Exception ex)
{
LWGLog.WriteLog("Update Dealer", ex.Message);
success = false;
}
return(success);
}
List <lwg_Dealer> ParseCSVFileToDealerList(string fullPath)
{
List <lwg_Dealer> dealerList = new List <lwg_Dealer>();
CsvReader csv = new CsvReader(new StreamReader(fullPath), true);
csv.MissingFieldAction = MissingFieldAction.ReplaceByNull;
int fieldCount = csv.FieldCount;
string[] headers = csv.GetFieldHeaders();
while (csv.ReadNextRecord())
{
lwg_Dealer dealer = new lwg_Dealer();
// Dealer ID
if (csv[0] != null)
{
dealer.DealerID = csv[0];
}
else
{
LWGLog.WriteLog("import dealer", "null of dealerId");
continue;
}
// Dealer Name
if (csv[1] != null)
{
dealer.Name = csv[1];
}
else
{
LWGLog.WriteLog("import dealer", string.Format("{0}: empty name", csv[0]));
continue;
}
// Address Line 1
if (csv[2] != null)
{
dealer.AddressLine1 = csv[2];
}
// Address Line 2
if (csv[3] != null)
{
dealer.AddressLine2 = csv[3];
}
// City
if (csv[4] != null)
{
dealer.City = csv[4];
}
// State
if (csv[5] != null)
{
dealer.State = csv[5];
}
// Zip
if (csv[6] != null)
{
dealer.Zip = csv[6];
}
// Phone
if (csv[7] != null)
{
dealer.Phone = csv[7];
}
// Fax
if (csv[8] != null)
{
dealer.Fax = csv[8];
}
// WebAddress
if (csv[9] != null)
{
dealer.WebAddress = csv[9];
}
// Contact
if (csv[10] != null)
{
dealer.Contact = csv[10];
}
// NewIssue
if (csv[11] != null)
{
dealer.NewIssue = csv[11];
}
dealerList.Add(dealer);
}
return(dealerList);
}
