private void btnOK_Click(object sender, EventArgs e)
{
var cities = GetSelectedCity();
if (cities.Any())
{
DeleteCurrentCities();
SaveSelectedCity(cities);
var selectedCity = (PostClCity)cbCityList.SelectedItem;
var context = new CLDMSEntities();
var account =
context.Accounts.FirstOrDefault(o => o.AccountId == GlobalVar.CurrentAccount.AccountId);
if (account != null)
{
account.FirstCity = selectedCity.CityId;
account.LastUpdated = DateTime.Now;
context.SaveChanges();
ReOrderCityList(selectedCity.CityId);
_frmMain.AfterLogging();
}
Close();
}
else
{
MessageBox.Show("Please choose at least one city in the list", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void IniteStatelist()
{
var context = new CLDMSEntities();
var dtDealerCityAccount =
context.SelectedCities.Where(x => x.AccountId == GlobalVar.CurrentAccount.AccountId).ToList();
IQueryable <IGrouping <string, City> > statelist =
context.Cities.OrderBy(j => j.State).GroupBy(i => i.State);
foreach (var state in statelist)
{
var treeNode = new TreeNode(state.Key,
state.OrderBy(i => i.CityName)
.Select(
city =>
new TreeNode(city.CityName)
{
Tag = city.CityID,
Checked =
dtDealerCityAccount.FirstOrDefault(
i => i.CityId == city.CityID) != null
})
.ToArray());
StateTreeview.Nodes.Add(treeNode);
GridviewHelper.HideCheckBox(StateTreeview, treeNode);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (ValidateEmpty() && ValidateSamePassword())
{
var context = new CLDMSEntities();
var account =
context.Accounts.FirstOrDefault(x => x.AccountId == GlobalVar.CurrentAccount.AccountId);
account.AccountPassword = txtNewPass.Text;
account.LastUpdated = DateTime.Now;
account.IsFirstLogOn = false;
account.Active = true;
context.SaveChanges();
frmMain.txtPassword.Text = txtNewPass.Text;
Close();
var cForm = CreditCardAuthorizeForm.Instance(frmMain);
cForm.Show();
cForm.Activate();
}
}
public static int GetDailyUse()
{
var context = new CLDMSEntities();
return(context.Trackings.Count(x => x.AccountId == GlobalVar.CurrentAccount.AccountId &&
x.AddedDate.Value.Year == DateTime.Now.Year &&
x.AddedDate.Value.Month == DateTime.Now.Month &&
x.AddedDate.Value.Day == DateTime.Now.Day));
}
private void CombineWithCurrentData(AppraisalViewFormModel result, string VIN)
{
var context = new CLDMSEntities();
var item = context.Inventories.FirstOrDefault(i => i.VINNumber.ToLower().Equals(VIN.ToLower()));
if (result != null)
{
CheckInDatabase(result, item);
}
}
private void CombineWithCurrentData(AppraisalViewFormModel result, int listingID)
{
var context = new CLDMSEntities();
var item = context.Inventories.FirstOrDefault(i => i.ListingID == listingID);
if (result != null)
{
CheckInDatabase(result, item);
}
}
public static IEnumerable <UsState> GetAllStates()
{
var context = new CLDMSEntities();
return(context.UsaZipCodes.Select(x => new UsState()
{
State = x.StateName,
StateAbbr = x.StateAbbr,
}
).Distinct().OrderBy(x => x.State).ToList());
}
void editWorker_DoWork(object sender, DoWorkEventArgs e)
{
var context = new CLDMSEntities();
var item = context.Inventories.FirstOrDefault(i => i.ListingID == listingID);
var result = _decodeType.Equals(DecodeType.VIN) ? VinDecodeHelper.DecodeProcessingByVin(item.VINNumber) : VinDecodeHelper.GetVehicleInformationFromYearMakeModel(int.Parse(item.ModelYear), item.Make, item.Model);
CombineWithCurrentData(result, listingID);
BindingFormControl(result);
if (result != null)
{
txtVin.Text = result.VinNumber;
}
lblMessage.Text = "Edit inventory";
Isbusy = false;
}
private static void SaveSelectedCity(IEnumerable <int> cities)
{
var context = new CLDMSEntities();
foreach (int city in cities)
{
context.SelectedCities.Add(new SelectedCity()
{
AccountId = GlobalVar.CurrentAccount.AccountId,
CityId = city,
DateStamp = DateTime.Now,
DealerId = GlobalVar.CurrentAccount.DealerId
});
}
context.SaveChanges();
}
private void btnSave_Click(object sender, EventArgs e)
{
this._frmMain.txtEndingSentence.Text = this.htmlEditorControl.InnerHtml;
var context = new CLDMSEntities();
var dealer = context.Dealers.First(o => o.DealerId == GlobalVar.CurrentDealer.DealerId);
dealer.EndingSentence = String.IsNullOrEmpty(this.htmlEditorControl.InnerHtml) ? "" : this.htmlEditorControl.InnerHtml.Trim();
context.SaveChanges();
GlobalVar.CurrentDealer.EndingSentence = dealer.EndingSentence;
this.Close();
}
private void SaveToDB()
{
var context = new CLDMSEntities();
var item = context.Inventories.FirstOrDefault(i => i.ListingID == listingID);
if (item != null)
{
LoadData(item);
context.SaveChanges();
}
else
{
var inventory = new Inventory();
LoadData(inventory);
context.Inventories.Add(inventory);
context.SaveChanges();
}
}
public static PostClPackgae GetDataFeedPackage()
{
using (var context = new CLDMSEntities())
{
return(context.Packages.Where(x => x.MonthlyPrice == 0).Select(x => new PostClPackgae()
{
PackageId = x.PackageId,
MonthlyPrice = x.MonthlyPrice.Value,
PackageName = x.PackageName,
Period = x.Period,
QuickBookPackageId = x.QuickBookPackageId.Value,
QuickBookPackageName = x.QuickBookPackageName,
TotalCharge = x.TotalCharge.Value,
}
).First());
}
}
public static IEnumerable <PostClPackgae> GetAllPackages()
{
using (var context = new CLDMSEntities())
{
return(context.Packages.Where(x => x.MonthlyPrice > 0).Select(x => new PostClPackgae()
{
PackageId = x.PackageId,
MonthlyPrice = x.MonthlyPrice.Value,
PackageName = x.PackageName,
Period = x.Period,
QuickBookPackageId = x.QuickBookPackageId.Value,
QuickBookPackageName = x.QuickBookPackageName,
TotalCharge = x.TotalCharge.Value,
}
).ToList());
}
}
private void DeleteCurrentCities()
{
var context = new CLDMSEntities();
var item =
context.SelectedCities.Where(
i =>
i.AccountId == GlobalVar.CurrentAccount.AccountId &&
i.DealerId == GlobalVar.CurrentAccount.DealerId);
foreach (var city in item)
{
context.SelectedCities.Remove(city);
}
if (item.Any())
{
context.SaveChanges();
}
}
public static ZipCodeCity LookUpZipCode(int zipCode)
{
var context = new CLDMSEntities();
if (context.UsaZipCodes.Any(x => x.UsaZipCodeId == zipCode))
{
var findResult = context.UsaZipCodes.FirstOrDefault(x => x.UsaZipCodeId == zipCode);
return(new ZipCodeCity
{
City = findResult.CityName,
State = findResult.StateName,
StateAbbr = findResult.StateAbbr
});
}
else
{
return(new ZipCodeCity());
}
}
private void btnSubmitRequest_Click(object sender, EventArgs e)
{
var context = new CLDMSEntities();
var account = context.Accounts.First(o => o.AccountId == GlobalVar.CurrentAccount.AccountId);
account.APIUsername = String.IsNullOrEmpty(txtUserName.Text) ? "" : txtUserName.Text.Trim();
account.APIPassword = String.IsNullOrEmpty(txtPassword.Text) ? "" : txtPassword.Text.Trim();
account.APIAccountId = String.IsNullOrEmpty(txtAccountId.Text) ? "" : txtAccountId.Text.Trim();
account.LastUpdated = DateTime.Now;
context.SaveChanges();
GlobalVar.CurrentAccount.APIUsername = account.APIUsername;
GlobalVar.CurrentAccount.APIPassword = account.APIPassword;
GlobalVar.CurrentAccount.APIAccountId = account.APIAccountId;
this.Close();
}
private void btnSend_Click(object sender, EventArgs e)
{
if (dateTimePickerFrom.Value > dateTimePickerEnd.Value)
{
MessageBox.Show(
"Date Range is not valid",
"Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
var context = new CLDMSEntities();
var dateTo = new DateTime(dateTimePickerFrom.Value.Year, dateTimePickerFrom.Value.Month, dateTimePickerFrom.Value.Day);
var dateEnd =
new DateTime(dateTimePickerEnd.Value.Year, dateTimePickerEnd.Value.Month,
dateTimePickerEnd.Value.Day).AddDays(1);
var fullCityList = context.Cities.ToList();
var fullAdsList = new List <TrackingAds>();
var selectedCity = (ShortCity)cbCity.SelectedItem;
if (selectedCity.CityId == 0)
{
foreach (
var tmp in
context.Trackings.Where(
a => a.AccountId == GlobalVar.CurrentAccount.AccountId && a.AddedDate >= dateTo && a.AddedDate <= dateEnd))
{
var index = 1;
var record = new TrackingAds()
{
Index = index++,
CityName = fullCityList.FirstOrDefault(x => x.CityID == tmp.CityId).CityName,
CraigslistUrl = tmp.AdsUrl,
PostingId = tmp.CLPostingId.GetValueOrDefault(),
CreatedDate = tmp.AddedDate.GetValueOrDefault(),
ExpirationDate = tmp.AddedDate.GetValueOrDefault().AddDays(30)
};
fullAdsList.Add(record);
}
}
else
{
foreach (
var tmp in
context.Trackings.Where(
a => a.AccountId == GlobalVar.CurrentAccount.AccountId && a.CityId == selectedCity.CityId && a.AddedDate >= dateTo && a.AddedDate <= dateEnd))
{
var index = 1;
var record = new TrackingAds()
{
Index = index++,
CityName = fullCityList.FirstOrDefault(x => x.CityID == tmp.CityId).CityName,
CraigslistUrl = tmp.AdsUrl,
PostingId = tmp.CLPostingId.GetValueOrDefault(),
CreatedDate = tmp.AddedDate.GetValueOrDefault(),
ExpirationDate = tmp.AddedDate.GetValueOrDefault().AddDays(30)
};
fullAdsList.Add(record);
}
}
var csvWriterDealer = new CsvExport <TrackingAds>(fullAdsList.OrderBy(x => x.CreatedDate).ToList());
string pathDownload = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
string fileName = "trackingads" + "_" + DateTime.Now.ToString("MMddyy") +
DateTime.Now.Millisecond +
".csv";
string fullFilePathForDealer = pathDownload + fileName;
csvWriterDealer.ExportToFileWithHeader(fullFilePathForDealer);
EmailHelper.SendExcelMail(fileName, csvWriterDealer.ExportToBytes());
MessageBox.Show("Hi " + GlobalVar.CurrentAccount.FirstName + " " + GlobalVar.CurrentAccount.LastName +
". You will receive the report in your inbox shortly.", "Info", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception)
{
MessageBox.Show(
"There is an error when opening a report. Please send the report to your email instead.");
}
}
}
private void btnView_Click_1(object sender, EventArgs e)
{
if (dateTimePickerFrom.Value > dateTimePickerEnd.Value)
{
MessageBox.Show(
"Date Range is not valid",
"Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
var context = new CLDMSEntities();
var dateTo = new DateTime(dateTimePickerFrom.Value.Year, dateTimePickerFrom.Value.Month, dateTimePickerFrom.Value.Day);
var dateEnd =
new DateTime(dateTimePickerEnd.Value.Year, dateTimePickerEnd.Value.Month,
dateTimePickerEnd.Value.Day).AddDays(1);
var fullCityList = context.Cities.ToList();
var fullAdsList = new List <TrackingAds>();
var selectedCity = (ShortCity)cbCity.SelectedItem;
if (selectedCity.CityId == 0)
{
foreach (
var tmp in
context.Trackings.Where(
a => a.AccountId == GlobalVar.CurrentAccount.AccountId && a.AddedDate >= dateTo && a.AddedDate <= dateEnd))
{
var index = 1;
var record = new TrackingAds()
{
Index = index++,
CityName = fullCityList.FirstOrDefault(x => x.CityID == tmp.CityId).CityName,
CraigslistUrl = tmp.AdsUrl,
PostingId = tmp.CLPostingId.GetValueOrDefault(),
CreatedDate = tmp.AddedDate.GetValueOrDefault(),
ExpirationDate = tmp.AddedDate.GetValueOrDefault().AddDays(30)
};
fullAdsList.Add(record);
}
}
else
{
foreach (
var tmp in
context.Trackings.Where(
a => a.AccountId == GlobalVar.CurrentAccount.AccountId && a.CityId == selectedCity.CityId && a.AddedDate >= dateTo && a.AddedDate <= dateEnd))
{
var index = 1;
var record = new TrackingAds()
{
Index = index++,
CityName = fullCityList.FirstOrDefault(x => x.CityID == tmp.CityId).CityName,
CraigslistUrl = tmp.AdsUrl,
PostingId = tmp.CLPostingId.GetValueOrDefault(),
CreatedDate = tmp.AddedDate.GetValueOrDefault(),
ExpirationDate = tmp.AddedDate.GetValueOrDefault().AddDays(30)
};
fullAdsList.Add(record);
}
}
var csvWriterDealer = new CsvExport <TrackingAds>(fullAdsList.OrderBy(x => x.CreatedDate).ToList());
string pathDownload = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
string fullFilePathForDealer = pathDownload + "/trackingads" + "_" + DateTime.Now.ToString("MMddyy") +
DateTime.Now.Millisecond +
".csv";
csvWriterDealer.ExportToFileWithHeader(fullFilePathForDealer);
//var xlApp = new Excel.ApplicationClass();
//object missing = System.Reflection.Missing.Value;
//xlApp.Workbooks.OpenText
// (
// fullFilePathForDealer,
// Excel.XlPlatform.xlWindows, //Origin
// 1, // Start Row
// Excel.XlTextParsingType.xlDelimited, //Datatype
// Excel.XlTextQualifier.xlTextQualifierNone, //TextQualifier
// false, // Consecutive Deliminators
// false, // tab
// false, // semicolon
// true, //COMMA
// false, // space
// false, // other
// missing, // Other Char
// missing, // FieldInfo
// missing, //TextVisualLayout
// missing, // DecimalSeparator
// missing, // ThousandsSeparator
// missing, // TrialingMionusNumbers
// missing //Local
// );
//xlApp.Visible = true;
}
catch (Exception)
{
MessageBox.Show(
"There is an error when opening a report. Please send the report to your email instead.");
}
}
}
