/// <summary>
/// Construct the Final object that needs to be sent to the API.
/// </summary>
public void ConstructResponse()
{
//Get DataSetId
var dataSetId = ApiHandler.GetDataSetId().Result;
// Get the Vehicles for this Dataset
var vehicleIdList = ApiHandler.GetVehicleIdList(dataSetId).Result;
if (vehicleIdList != null)
{
//Fire the threads and run parallel.
Parallel.ForEach(vehicleIdList, vehicle => { GetDealerVehiclesInfo(vehicle, dataSetId, _dealerVehicles); });
//Send the Answer
try
{
var dealers = new Dealers {
dealers = _dealerVehicles
};
var answerResult = ApiHandler.PostAnswer(dataSetId, dealers).Result;
Console.WriteLine(answerResult);
}
catch (Exception ex)
{
throw ex;
}
}
}
private void Edit_Executed(object sender, ExecutedRoutedEventArgs e)
{
if (Dealer.Exists((long)(Dealers.SelectedItem as TextBlock).Tag))
{
DealerWindow dealerWindow = new DealerWindow(Dealer.FromDataRow(Dealer.Select((long)(Dealers.SelectedItem as TextBlock).Tag)));
if ((bool)dealerWindow.ShowDialog(this))
{
if (Dealer.Exists((long)(Dealers.SelectedItem as TextBlock).Tag))
{
if (BusinessEntity.Exists(dealerWindow.Dealer.BusinessEntityId) &&
Entities.Activity.Exists(dealerWindow.Dealer.ActivityId) &&
Entities.ActivityDirection.Exists(dealerWindow.Dealer.ActivityDirectionId))
{
long selectedDealerId = (long)(Dealers.SelectedItem as TextBlock).Tag;
dealerWindow.Dealer.Update();
UpdateDealers();
Dealers.SelectItem(Dealers.Items.FirstOrDefault <TextBlock>(x => (long)x.Tag == selectedDealerId));
}
else
{
ShowErrorWindow(1);
}
}
else
{
ShowErrorWindow(2);
}
}
}
else
{
ShowErrorWindow(2);
}
}
/// <summary>
/// 添加关键字处理类
/// </summary>
/// <param name="dealer"></param>
public void AddKeywordDealer(KeywordDealer dealer)
{
if (dealer == null)
{
throw new ArgumentNullException("dealer");
}
dealer.SetPlatform(Origin.Platform);
if (dealer is NotMatchDealer)
{
NoMatchDealer = dealer;
return;
}
var keywords = dealer.GetKeywords();
if (keywords == null)
{
return;
}
foreach (var item in keywords)
{
if (string.IsNullOrEmpty(item))
{
continue;
}
if (!Dealers.TryAdd(item, dealer))
{
throw new ArgumentException(string.Format("重复关键字处理: {0}", item));
}
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
Instance = this;
ActiveWindow = this;
UpdateDealers();
Dealers.SelectItem();
}
public ActionResult Sil(int id)
{
Dealers bayiler = (from p in islemler.Dealers
where p.ID == id
select p).FirstOrDefault();
return(View(bayiler));
}
public async Task <Dealers> DeleteDealer(Dealers dealer)
{
var url = URLBuilder.GetURL(Controllers.REAGENT, EndPoint.DEALER_DELETE);
return(await requestProvider.DeleteAsync(url, dealer, new Dictionary <string, string> {
["id"] = dealer.Id.ToString()
}));
}
public ActionResult Yeni(Dealers bayiler)
{
islemler.Dealers.Add(bayiler);
islemler.SaveChanges();
RedirectToAction("ListEducation");
return(RedirectToAction("ListDealers"));
}
public Dealers getBayi()
{
Dealers bayi = (from p in islemler.Dealers
where p.ID == 17
select p).FirstOrDefault();
return(bayi);
}
public ActionResult Detay(int id)
{
Dealers edu = (from p in islemler.Dealers
where p.ID == id
select p).FirstOrDefault();
ViewBag.ID = 1;
return(View(edu));
}
public ActionResult Guncelle(int id)
{
ViewBag.Id = 1;
Dealers bayiler = (from p in islemler.Dealers
where p.ID == id
select p).FirstOrDefault();
return(View(bayiler));
}
private void ComboBox_DropDownClosed(object sender, EventArgs e)
{
ComboBox comboBox = sender as ComboBox;
if ((long)comboBox.Tag != (long)(comboBox.SelectedItem as TextBlock).Tag)
{
UpdateDealers();
Dealers.SelectItem();
}
}
public ActionResult SilmeIslemi(int id)
{
Dealers silinecekEgitim = (from p in islemler.Dealers
where p.ID == id
select p).FirstOrDefault();
int egitimId = silinecekEgitim.ID;
islemler.Dealers.Remove(silinecekEgitim);
islemler.SaveChanges();
return(RedirectToAction("ListDealers"));
}
public static async Task <string> PostAnswer(string datasetId, Dealers dealers)
{
var apiEndPoint = string.Format("api/{0}/answer", datasetId);
var content = new StringContent(JsonConvert.SerializeObject(dealers), Encoding.UTF8, "application/json");
var response = await ApiHelper <FinalResponse> .PostAnswerResponse(apiEndPoint, content);
if (response != null)
{
return(string.Format("Answer Message: {0} TotalMillisecons: {1} IsSuccess: {2}", response.message, response.totalMilliseconds.ToString(), response.success.ToString()));
}
throw new Exception("Did not recieve Response.");
}
private void getContent(int id)
{
int currentPage = Request["page"] == null ? 1 : int.Parse(Request["page"]);
string connectstring = WebConfigurationManager.ConnectionStrings["tayanaConnectionString"].ToString();
SqlConnection connect = new SqlConnection(connectstring);
string sqlsearch = " where countryID = @countryID";
string sqlstring = $@"with newsList as
(SELECT row_number() over(order by country.id asc) as rownumber, area.countryID, country.country, area.area, dealer.areaID, dealer.photo, dealer.dealer, dealer.id as dealerID
FROM area INNER JOIN
country ON area.countryID = country.id INNER JOIN
dealer ON area.id = dealer.areaID{sqlsearch})
select* from newsList";
string sqlpage = " where rownumber >= @start and rownumber <= @end";
SqlCommand getsql = new SqlCommand(sqlstring + sqlpage, connect);
getsql.Parameters.AddWithValue("@countryID", id);
getsql.Parameters.Add("@start", SqlDbType.Int);
getsql.Parameters["@start"].Value = ((currentPage - 1) * PageSize) + 1;
getsql.Parameters.Add("@end", SqlDbType.Int);
getsql.Parameters["@end"].Value = currentPage * PageSize;
SqlDataAdapter adapter = new SqlDataAdapter(getsql);
DataTable table = new DataTable();
adapter.Fill(table);
Dealers.DataSource = table;
Dealers.DataBind();
//產分頁
string page = @"area INNER JOIN
country ON area.countryID = country.id INNER JOIN
dealer ON area.id = dealer.areaID";
string pagecount = " where country.id=@id ";
SqlCommand totalcommand = new SqlCommand($@"select count(*) from {page} " + pagecount, connect);
totalcommand.Parameters.AddWithValue("@id", id);
SqlDataAdapter totalAdapter = new SqlDataAdapter(totalcommand);
DataTable totalTable = new DataTable();
totalAdapter.Fill((totalTable));
int total = Convert.ToInt32(totalTable.Rows[0][0]);
Pagination.totalitems = total;
Pagination.limit = PageSize;
Pagination.targetpage = "dealers.aspx";
Pagination.showPageControls();
}
public Dealers getDealer(int DealerId)
{
Database.Dealer entity = new Database.Dealer();
entity = dbcontext.Dealers.Find(DealerId);
var config = new MapperConfiguration(cfg => cfg.CreateMap <Database.Dealer, Dealers>());
var mapper = new Mapper(config);
Dealers dealer = mapper.Map <Dealers>(entity);
return(dealer);
}
public bool DeleteDealers(int dealersId)
{
Dealers dealers = context.Dealers.Find(dealersId);
if (dealers == null)
{
return(false);
}
context.Dealers.Remove(dealers);
context.SaveChanges();
return(true);
}
public void UpdateDealer(Dealers dealer)
{
var dealerFromDb = _dealersRepository.Get(dealer.Id);
if (dealerFromDb != null)
{
_util.CopyProperties(dealer, dealerFromDb);
_dealersRepository.Update(dealerFromDb);
}
else
{
throw new Exception("This dealer does not exist");
}
}
public ActionResult Maintenance(Int32?DealerId)
{
if (DealerId.HasValue)
{
ApplicationDBContext db = new ApplicationDBContext();
Dealers Dealer = db.Offices.OfType <Dealers>().Where(d => d.Id == DealerId).FirstOrDefault();
ViewBag.DealerId = DealerId;
return(View(Dealer));
}
else
{
ViewBag.DealerId = "0";
return(View(new Dealers()));
}
}
public bool SaveDealers(Dealers dealers)
{
Dealers entry = context.Dealers.Find(dealers.Id);
if (entry == null)
{
context.Dealers.Add(dealers);
}
else
{
context.Entry(entry).CurrentValues.SetValues(dealers);
}
context.SaveChanges();
return(true);
}
public JsonResult Create(Dealers dealer)
{
string message = "";
try
{
if (ModelState.IsValid)
{
db.Dealers.Add(dealer);
db.SaveChanges();
message = "Data Saved Successfully";
}
}
catch (Exception)
{
message = "Error Occured";
}
return(Json(message, JsonRequestBehavior.AllowGet));
}
public ResultEntity <bool> AddDealer(AddDealerDto addDealerDto)
{
//内存中组织对象
var dealerid = Guid.NewGuid();
var dealercontact = new List <Contact>();
for (int i = 0; i < addDealerDto.ContactName.Count; i++)
{
var dealercontactmodel = new Contact().CreateContact(dealerid,
addDealerDto.ContactName[i],
addDealerDto.ContactTel[i],
addDealerDto.ContactSheng[i],
addDealerDto.ContactShi[i],
addDealerDto.ContactQu[i],
addDealerDto.ContactJiedao[i],
addDealerDto.ContactIsDefault[i]
);
dealercontact.Add(dealercontactmodel);
}
var dealer = new Dealers(_dealerRepository).RegisterDealers(dealerid, addDealerDto.Name, addDealerDto.Tel, addDealerDto.EleMoney, dealercontact, addDealerDto.Parentid);
var login = new Login().CreateLogin(dealer.Tel, dealerid);
//实际持续化到数据库中
try
{
using (_repository)
{
_dealerRepository.CreateDealer(dealer);
if (addDealerDto.Parentid != null)
{
_dealerRepository.SubParentEleMoney((Guid)addDealerDto.Parentid, addDealerDto.EleMoney);
}
_dealerRepository.AddParentSubCount(addDealerDto.Parentid);
_loginRepository.CreateLogin(login);
_repository.Commit();
}
return(GetResultEntity(true));
}
catch (Exception ex)
{
throw ex;
}
}
public List <Dealers> getAllDealers()
{
var entities = dbcontext.Dealers.ToList();
List <Dealers> dealers = new List <Dealers>();
var config = new MapperConfiguration(cfg => cfg.CreateMap <Database.Dealer, Dealers>());
var mapper = new Mapper(config);
if (entities != null)
{
foreach (var item in entities)
{
Dealers dealer = new Dealers();
dealer = mapper.Map <Dealers>(item);
dealers.Add(dealer);
}
}
return(dealers);
}
private void Add_Executed(object sender, ExecutedRoutedEventArgs e)
{
DealerWindow dealerWindow = new DealerWindow();
if ((bool)dealerWindow.ShowDialog(this))
{
if (BusinessEntity.Exists(dealerWindow.Dealer.BusinessEntityId) &&
Entities.Activity.Exists(dealerWindow.Dealer.ActivityId) &&
Entities.ActivityDirection.Exists(dealerWindow.Dealer.ActivityDirectionId))
{
long insertedDealerId = dealerWindow.Dealer.Insert();
UpdateDealers();
Dealers.SelectItem(Dealers.Items.FirstOrDefault <TextBlock>(x => (long)x.Tag == insertedDealerId));
}
else
{
ShowErrorWindow(0);
}
}
}
public ActionResult UpdateDealer(Dealers dealer)
{
if (dealer != null)
{
try
{
_reagentService.UpdateDealer(dealer);
}
catch (Exception e)
{
Program.Logger.Error(e);
return(Ok(GetResponse(ResponseType.FAIL, ResponseStatusCode.FAIL, GetError(ErrorCodes.dataNotFound, "Failed", "Error occurred while updating the dealer details"))));
}
return(Ok(GetResponse(ResponseType.ACK, ResponseStatusCode.SUCCESS)));
}
else
{
return(BadRequest(GetResponse(ResponseType.ERROR, ResponseStatusCode.ERROR, GetError(ErrorCodes.invalidData, "Invalid input", "Please enter proper dealer details"))));
}
}
public ActionResult Guncelle(Dealers bayiler)
{
Dealers seciliBayi = (from p in islemler.Dealers
where p.ID == bayiler.ID
select p).FirstOrDefault();
seciliBayi.DealerName = bayiler.DealerName;
seciliBayi.AccountName = bayiler.AccountName;
seciliBayi.BankName = bayiler.BankName;
seciliBayi.CityID = bayiler.CityID;
seciliBayi.CountryID = bayiler.CountryID;
seciliBayi.DealerAddress = bayiler.DealerAddress;
seciliBayi.DealerLoginDate = bayiler.DealerLoginDate;
seciliBayi.DealerLoginIP = bayiler.DealerLoginIP;
seciliBayi.DealerMail = bayiler.DealerMail;
seciliBayi.DealerPass = bayiler.DealerPass;
seciliBayi.DealerPhone = bayiler.DealerPhone;
seciliBayi.DealerPicture = bayiler.DealerPicture;
seciliBayi.DealerType = bayiler.DealerType;
seciliBayi.DealerUser = bayiler.DealerUser;
seciliBayi.Domain = bayiler.Domain;
seciliBayi.GKOD = bayiler.GKOD;
seciliBayi.IBAN = bayiler.IBAN;
seciliBayi.ID = bayiler.ID;
seciliBayi.Logo = bayiler.Logo;
seciliBayi.MailTo = bayiler.MailTo;
seciliBayi.Percentage = bayiler.Percentage;
seciliBayi.Permissions = bayiler.Permissions;
seciliBayi.Status = bayiler.Status;
seciliBayi.TaxNo = bayiler.TaxNo;
seciliBayi.UpDealer = bayiler.UpDealer;
seciliBayi.VLanguage = bayiler.VLanguage;
seciliBayi.BankName = bayiler.BankName;
seciliBayi.WebSite = bayiler.WebSite;
islemler.SaveChanges();
return(RedirectToAction("ListDealers"));
}
public ActionResult Maintenance(FormCollection formCollection)
{
ApplicationDBContext db = new ApplicationDBContext();
if (formCollection["DealerId"] == "0")
{
Dealers Dealers = new Dealers();
//Dealers.JoinDate = formCollection["JoinDate"];
//Dealers.RecommendedBy = formCollection["RecommendedBy"];
Dealers.DistributorId = Int32.Parse(formCollection["Distributor"]); // Send always 1 for now.. before insert 1 record with id 1 in zone table
Dealers.ContactPerson = formCollection["Firstname"];
//Dealers.Lastname = formCollection["Lastname"];
Dealers.Name = formCollection["Companyname"];
Dealers.Address.Address1 = formCollection["Address1"];
Dealers.Address.Address2 = formCollection["Address2"];
Dealers.Address.City = formCollection["City"];
Dealers.Address.Zip = formCollection["Zip"];
Dealers.Address.State = formCollection["State"];
Dealers.Address.Country = formCollection["Country "];
Dealers.Contact1.Mobile = formCollection["Mobilenumber1"];
Dealers.Contact2.Mobile = formCollection["Mobilenumber2"];
Dealers.Contact1.Phone = formCollection["Phonenumber1"];
Dealers.Contact2.Phone = formCollection["Phonenumber2"];
Dealers.Contact1.Email = formCollection["Email"];
Dealers.Location = formCollection["Location"];
//Dealers.StrengthFF = formCollection["StrengthFF"];
//Dealers.Peeksaleperiod = formCollection["Peeksaleperiod"];
//Dealers.Popularfestivals = formCollection["Popularfestivals"];
//Dealers.Commands = formCollection["Commands"];
//Dealers.Username = formCollection["Username"];
//Dealers.Password = formCollection["Password"];
db.Offices.AddObject(Dealers);
return(View("Index"));
}
else
{
return(View());
}
}
public ResultEntity <bool> AddDealer(AddDealerDTO adddealerdto)
{
var dealerid = Guid.NewGuid();
var dealercontacts = new List <Contact>();
for (int i = 0; i < adddealerdto.ContactNames.Count; i++)
{
var dealercontact = new Contact().CreateContact(dealerid, adddealerdto.ContactNames[i],
adddealerdto.ContactTels[i], adddealerdto.ContactProvinces[i],
adddealerdto.ContactCities[i], adddealerdto.ContactZeors[i], adddealerdto.ContactStreets[i],
adddealerdto.IsDefaultContact[i]);
dealercontacts.Add(dealercontact);
}
var dealer = new Dealers(idealerrepository).RegisterDealer(dealerid, adddealerdto.Name,
adddealerdto.Tel, adddealerdto.EleMoney, dealercontacts, adddealerdto.Parentid);
var login = new Login().CreateLogin(dealer.Tel, dealerid);
try
{
using (irepository)
{
idealerrepository.CreateDealer(dealer);
if (adddealerdto.Parentid != null)
{
idealerrepository.SubParentEleMoney(Guid.Parse(adddealerdto.Parentid.ToString()),
adddealerdto.EleMoney);
}
idealerrepository.AddParentSubCount(adddealerdto.Parentid);
iloginrepository.CreateLogin(login);
irepository.Commit();
}
return(GetResultEntity(true));
}
catch (Exception error)
{
throw error;
}
}
public string UpdateDealer(Dealers dealer)
{
try
{
var entity = dbcontext.Dealers.Find(dealer.DealerId);
if (entity != null)
{
entity.Name = dealer.Name;
entity.IsActive = dealer.IsActive;
dbcontext.SaveChanges();
return("Updated");
}
return("null");
}
catch (Exception ex)
{
return(ex.Message);
}
}
private void Delete_Executed(object sender, ExecutedRoutedEventArgs e)
{
if (Dealer.Exists((long)(Dealers.SelectedItem as TextBlock).Tag))
{
if ((bool)new ConfirmationWindow().ShowDialog(this))
{
if (Dealer.Exists((long)(Dealers.SelectedItem as TextBlock).Tag))
{
Dealer.Delete((long)(Dealers.SelectedItem as TextBlock).Tag);
UpdateDealers();
Dealers.SelectItem();
}
else
{
ShowErrorWindow(3);
}
}
}
else
{
ShowErrorWindow(3);
}
}
public string CreateDealer(Dealers dealer)
{
try
{
if (dealer != null)
{
Database.Dealer entity = new Database.Dealer();
var config = new MapperConfiguration(cfg => cfg.CreateMap <Dealers, Database.Dealer>());
var mapper = new Mapper(config);
entity = mapper.Map <Database.Dealer>(dealer);
dbcontext.SaveChanges();
return("created");
}
return("null");
}
catch (Exception ex)
{
return(ex.Message);
}
}
