public ActionResult CreateMobileAccessoriesAd([Bind(Include = "Id,category,postedBy,title,description,time")] Ad ad)
{
if (ModelState.IsValid)
{
if (Request.IsAuthenticated)
{
FileName[] fileNames = JsonConvert.DeserializeObject <FileName[]>(Request["files"]);
MobileAd mobileAd = new MobileAd();
mobileAd.color = Request["color"];
IdStatus idstatus = SaveMobileBrandModel();
mobileAd.mobileId = idstatus.id;
ad.status = idstatus.status;
ad = electronicController.MyAd(ad, "Save", "MobileAccessories");
electronicController.PostAdByCompanyPage(ad.Id);
//tags
electronicController.SaveTags(Request["tags"], ad);
mobileAd.Id = ad.Id;
db.MobileAds.Add(mobileAd);
db.SaveChanges();
electronicController.ReplaceAdImages(ad, fileNames);
//location
electronicController.MyAdLocation(Request["city"], Request["popularPlace"], Request["exectLocation"], ad, "Save");
return(RedirectToAction("Details", "Electronics", new { id = ad.Id, title = ElectronicsController.URLFriendly(ad.title) }));
}
return(RedirectToAction("Register", "Account"));
}
return(View("Create", ad));
}
public ActionResult Update([Bind(Include = "Id,category,subcategory,postedBy,title,description,time")] Ad ad)
{
if (ModelState.IsValid)
{
if (Request.IsAuthenticated)
{
var ab = Request["postedBy"];
var iddd = User.Identity.GetUserId();
if (Request["postedBy"] == User.Identity.GetUserId())
{
FileName[] fileNames = JsonConvert.DeserializeObject <FileName[]>(Request["files"]);
MobileAd mobileAd = new MobileAd();
mobileAd.sims = Request["sims"];
mobileAd.color = Request["color"];
IdStatus idstatus = SaveMobileBrandModel();
mobileAd.mobileId = idstatus.id;
ad.status = idstatus.status;
ad = electronicController.MyAd(ad, "Update");
//tags
electronicController.SaveTags(Request["tags"], ad, "update");
string brand = Request["brand"];
string model = Request["model"];
var mobileModel = db.MobileModels.FirstOrDefault(x => x.Mobile.brand == brand && x.model == model);
mobileAd.mobileId = mobileModel.Id;
electronicController.PostAdByCompanyPage(ad.Id, true);
mobileAd.Id = ad.Id;
//check if mobilead is not saved.
var mobdata = db.MobileAds.Any(x => x.Ad.Id.Equals(ad.Id));
if (mobdata)
{
db.Entry(mobileAd).State = EntityState.Modified;
}
else
{
db.MobileAds.Add(mobileAd);
}
//ad.MobileAds.Add(mobileAd);
try
{
db.SaveChanges();
}
catch (Exception e)
{
string sss = e.ToString();
}
//location
electronicController.MyAdLocation(Request["city"], Request["popularPlace"], Request["exectLocation"], ad, "Update");
electronicController.ReplaceAdImages(ad, fileNames);
return(RedirectToAction("Details", "Electronics", new { id = ad.Id, title = ElectronicsController.URLFriendly(ad.title) }));
}
}
return(RedirectToAction("Register", "Account"));
}
return(View("Edit", ad));
}
public async Task <string> saveBikeAd(Ad ad, bool update = false)
{
// ad.category = "Vehicles";
// ad.subcategory = "Cars";
BikeAd mobileAd = new BikeAd();
if (Request["year"] != "" && Request["year"] != null)
{
mobileAd.year = short.Parse(Request["year"]);
}
if (Request["kmDriven"] != null && Request["kmDriven"] != "")
{
mobileAd.kmDriven = int.Parse(Request["kmDriven"]);
}
mobileAd.adId = ad.Id;
if (Request["noOfOwners"] != null && Request["noOfOwners"] != "")
{
mobileAd.noOfOwners = short.Parse(Request["noOfOwners"]);
}
if (Request["registeredCity"] != null && Request["registeredCity"] != "")
{
var city = Request["registeredCity"];
mobileAd.registeredCity = await SaveCity(city);
}
IdStatus idstatus = SaveBikesBrandModel(ad);
mobileAd.bikeModel = idstatus.id;
if (update)
{
db.Entry(mobileAd).State = EntityState.Modified;
}
else
{
db.BikeAds.Add(mobileAd);
}
try
{
await db.SaveChangesAsync();
}
catch (DbEntityValidationException e)
{
string s = e.ToString();
List <string> errorMessages = new List <string>();
foreach (DbEntityValidationResult validationResult in e.EntityValidationErrors)
{
string entityName = validationResult.Entry.Entity.GetType().Name;
foreach (DbValidationError error in validationResult.ValidationErrors)
{
errorMessages.Add(entityName + "." + error.PropertyName + ": " + error.ErrorMessage);
}
}
}
return(idstatus.status);
}
public ActionResult Create([Bind(Include = "Id,category,subcategory,postedBy,title,description,time")] Ad ad)
{
if (ModelState.IsValid)
{
if (Request.IsAuthenticated)
{
//string tempId = Request["tempId"];
FileName[] fileNames = JsonConvert.DeserializeObject <FileName[]>(Request["files"]);
MobileAd mobileAd = new MobileAd();
mobileAd.sims = Request["sims"];
mobileAd.color = Request["color"];
IdStatus idstatus = SaveMobileBrandModel();
mobileAd.mobileId = idstatus.id;
ad.status = idstatus.status;
ad = electronicController.MyAd(ad, "Save", "Mobiles");
electronicController.PostAdByCompanyPage(ad.Id);
//images
try
{
db.SaveChanges();
}
catch (Exception e)
{
string sbs = e.ToString();
}
//tags
electronicController.SaveTags(Request["tags"], ad);
// FileUploadHandler(ad);
mobileAd.Id = ad.Id;
db.MobileAds.Add(mobileAd);
//ad.MobileAd.a(mobileAd);
try
{
db.SaveChanges();
}
catch (Exception e)
{
string sbs = e.ToString();
}
// ReplaceAdImages(ad.Id,tempId,fileNames);
electronicController.ReplaceAdImages(ad, fileNames);
//location
electronicController.MyAdLocation(Request["city"], Request["popularPlace"], Request["exectLocation"], ad, "Save");
return(RedirectToAction("Details", "Electronics", new { id = ad.Id, title = ElectronicsController.URLFriendly(ad.title) }));
}
return(RedirectToAction("Register", "Account"));
}
return(View("Create", ad));
//ViewBag.postedBy = new SelectList(db.AspNetUsers, "Id", "Email", ad.postedBy);
//return View(ad);
}
public IdStatus SaveBikesBrandModel(Ad ad)
{
IdStatus idStatus = new IdStatus();
idStatus.status = "a";
var company = System.Web.HttpContext.Current.Request["brand"];
var model = System.Web.HttpContext.Current.Request["model"];
if (company != null && company != "")
{
company = company.Trim();
model = model.Trim();
}
if (true) //company != null
{
bool isOldBrand = db.BikeBrands.Any(x => x.brand.Equals(company));
if (!isOldBrand)
{
BikeBrand mob = new BikeBrand();
mob.brand = company;
mob.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
mob.time = DateTime.UtcNow;
if (company == null || company == "")
{
mob.status = "a";
}
else
{
mob.status = "p";
}
db.BikeBrands.Add(mob);
db.SaveChanges();
BikeModel mod = new BikeModel();
mod.model = model;
mod.brandId = mob.Id;
mod.time = DateTime.UtcNow;
if (model == null || model == "")
{
mod.status = "a";
}
else
{
mod.status = "p";
}
mod.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
db.BikeModels.Add(mod);
db.SaveChanges();
//ad.status = "p";
idStatus.status = "p";
}
else
{
bool isOldModel = db.BikeModels.Any(x => x.model.Equals(model));
if (!isOldModel)
{
idStatus.status = "p";
//ad.status = "p";
var brandId = db.BikeBrands.FirstOrDefault(x => x.brand.Equals(company));
BikeModel mod = new BikeModel();
mod.brandId = brandId.Id;
mod.model = model;
if (model == null || model == "")
{
mod.status = "a";
}
else
{
mod.status = "p";
}
mod.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
mod.time = DateTime.UtcNow;
db.BikeModels.Add(mod);
try
{
db.SaveChanges();
}
catch (Exception e)
{
string s = e.ToString();
}
}
}
var mobileModel = db.BikeModels.FirstOrDefault(x => x.BikeBrand.brand == company && x.model == model);
idStatus.id = mobileModel.Id;
return(idStatus);
}
}
private static void Initialize(IdStatus item, DataRow dataRow)
{
item.Id = (Guid)dataRow["Id"];
item.Status = (SecurityTradingStatus)(int)dataRow["Status"];
}
protected async override void OnCreate(Bundle bundle)
{
base.OnCreate(bundle);
activity = this;
var db = new SQLiteAsyncConnection(dbPath);
await db.ExecuteAsync("DELETE FROM Cesv");
await db.ExecuteAsync("DELETE FROM Status");
var dadosConfiguracao = db.Table <Configuracao>();
var dadosToken = db.Table <Token>();
var configuracao = await dadosConfiguracao.FirstOrDefaultAsync();
var TokenAtual = await dadosToken.Where(x => x.data_att_token >= DateTime.Now).FirstOrDefaultAsync();
string url = "http://" + configuracao.endereco + "/Api/GerenciamentoPatio/GetCesvByStatus?ArmazemId=" + TokenAtual.armazemId;
System.Uri myUri = new System.Uri(url);
HttpWebRequest myWebRequest = (HttpWebRequest)HttpWebRequest.Create(myUri);
var myHttpWebRequest = (HttpWebRequest)myWebRequest;
myHttpWebRequest.PreAuthenticate = true;
myHttpWebRequest.Headers.Add("Authorization", "Bearer " + TokenAtual.access_token);
myHttpWebRequest.Accept = "application/json";
var myWebResponse = myWebRequest.GetResponse();
var responseStream = myWebResponse.GetResponseStream();
var myStreamReader = new StreamReader(responseStream, Encoding.Default);
var json = myStreamReader.ReadToEnd();
responseStream.Close();
myWebResponse.Close();
var teste = JsonConvert.DeserializeObject <List <ModelStatus> >(json);
foreach (var item in teste.OrderBy(x => x.denominacao))
{
ListaStatus.Add(string.Concat(item.denominacao, " (", item.ListaCesv.Where(x => x.armazemId == TokenAtual.armazemId).Count(), ")"));
IdStatus.Add(Convert.ToInt32(item.statusId));
foreach (var subitem in item.ListaCesv)
{
subitem.id = Convert.ToInt32(subitem.cesvId);
subitem.statusInicioId = subitem.statusInicioId;
/*
* item.cesvId = item.cesvId;
* item.dataAgendamentoEntrada = item.dataAgendamentoEntrada;
* item.nome = item.nome;
* item.nomeCliente = item.nomeCliente;
* item.nomeTransportadora = item.nomeTransportadora;
* item.numero = item.numero;
* item.placa = item.placa;
* item.statusDestino = item.statusDestino;
* item.statusInicio = item.statusInicio;
* item.telefone = item.telefone;
* item.tipoVeiculo = item.tipoVeiculo;
*/
await db.InsertOrReplaceAsync(subitem);
}
Status statusTemp = new Status();
statusTemp.cor = item.cor;
statusTemp.denominacao = item.denominacao;
statusTemp.statusId = item.statusId;
statusTemp.id = Convert.ToInt32(item.statusId);
await db.InsertOrReplaceAsync(statusTemp);
}
ListAdapter = new ArrayAdapter <string>(this, Resource.Layout.VeiculosSituacao, ListaStatus);
ListView.TextFilterEnabled = true;
ListView.ItemClick += delegate(object sender, AdapterView.ItemClickEventArgs args)
{
TokenAtual.statusId = IdStatus[args.Position].ToString();
db.InsertOrReplaceAsync(TokenAtual);
StartActivity(typeof(VeiculosSituacaoOprActivity));
};
}
public IdStatus SaveMobileBrandModel()
{
string adStatus = "a";
var company = System.Web.HttpContext.Current.Request["brand"];
var model = System.Web.HttpContext.Current.Request["model"];
if (company != null && company != "")
{
company = company.Trim();
model = model.Trim();
}
if (true) //company != null
{
bool isOldBrand = db.Mobiles.Any(x => x.brand.Equals(company));
if (!isOldBrand)
{
if (company != null && company != "" && company != "undefined")
{
adStatus = "p";
Mobile mob = new Mobile();
mob.brand = company;
mob.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
mob.time = DateTime.UtcNow;
mob.status = "p";
db.Mobiles.Add(mob);
db.SaveChanges();
if (model != null && model != "" && model != "undefined")
{
MobileModel mod = new MobileModel();
mod.model = model;
mod.brandId = mob.Id;
mod.time = DateTime.UtcNow;
mod.status = "p";
mod.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
db.MobileModels.Add(mod);
db.SaveChanges();
}
}
}
else
{
bool isOldModel = db.MobileModels.Any(x => x.model.Equals(model));
if (!isOldModel)
{
if (model != "" && model != null && model != "undefined")
{
adStatus = "p";
var brandId = db.Mobiles.FirstOrDefault(x => x.brand.Equals(company));
MobileModel mod = new MobileModel();
mod.brandId = brandId.Id;
mod.model = model;
mod.status = "p";
mod.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
mod.time = DateTime.UtcNow;
db.MobileModels.Add(mod);
db.SaveChanges();
}
}
}
var mobileModel = db.MobileModels.FirstOrDefault(x => x.Mobile.brand == company && x.model == model);
IdStatus idstatus = new IdStatus();
idstatus.id = mobileModel.Id;
idstatus.status = adStatus;
return(idstatus);
}
}
private static void Initialize(IdStatus item, DataRow dataRow)
{
item.Id = (Guid)dataRow["Id"];
item.Status = (SecurityTradingStatus)(int)dataRow["Status"];
}
public override int GetHashCode()
{
return(Code.GetHashCode() ^ NumericCode.GetHashCode() ^ Alpha3Code.GetHashCode() ^ Fips10Code.GetHashCode() ^ Type.GetHashCode() ^ IdStatus.GetHashCode() ^ CurrencyCode.GetHashCode() ^ ParentCode.GetHashCode() ^ ParentGroupCodes.GetHashCode() ^ LanguageCodes.GetHashCode() ^ LanguageAltCodes.GetHashCode());
}
public override int GetHashCode()
{
return(Code.GetHashCode() ^ IdStatus.GetHashCode() ^ LanguageCodes.GetHashCode() ^ LanguageAltCodes.GetHashCode());
}
public override int GetHashCode()
{
return(Code.GetHashCode() ^ IdStatus.GetHashCode() ^ ParentCode.GetHashCode());
}
public IdStatus SaveMobileBrandModel()
{
string adStatus = "a";
var company = System.Web.HttpContext.Current.Request["brand"];
var model = System.Web.HttpContext.Current.Request["model"];
if (company != null && company != "")
{
company = company.Trim();
model = model.Trim();
}
if (true) //company != null
{
var allBrands = (db.Mobiles.Select(x => x.brand)).AsEnumerable(); //getBrands
bool isNewBrand = true;
foreach (var brand in allBrands)
{
if (brand == company)
{
isNewBrand = false;
}
}
if (isNewBrand)
{
Mobile mob = new Mobile();
mob.brand = company;
mob.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
mob.time = DateTime.UtcNow;
if (company == null || company == "")
{
mob.status = "a";
}
else
{
mob.status = "p";
}
db.Mobiles.Add(mob);
db.SaveChanges();
MobileModel mod = new MobileModel();
mod.model = model;
mod.brandId = mob.Id;
mod.time = DateTime.UtcNow;
if (model == null || model == "")
{
mod.status = "a";
}
else
{
mod.status = "p";
}
mod.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
db.MobileModels.Add(mod);
db.SaveChanges();
adStatus = "p";
}
else
{
var allModels = db.MobileModels.Where(x => x.Mobile.brand == company).Select(x => x.model);
bool isNewModel = true;
foreach (var myModel in allModels)
{
if (myModel == model)
{
isNewModel = false;
}
}
if (isNewModel)
{
adStatus = "p";
var brandId = db.Mobiles.FirstOrDefault(x => x.brand.Equals(company));
MobileModel mod = new MobileModel();
mod.brandId = brandId.Id;
mod.model = model;
if (model == null || model == "")
{
mod.status = "a";
}
else
{
mod.status = "p";
}
mod.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
mod.time = DateTime.UtcNow;
db.MobileModels.Add(mod);
try
{
db.SaveChanges();
}
catch (Exception e)
{
string s = e.ToString();
}
}
}
var mobileModel = db.MobileModels.FirstOrDefault(x => x.Mobile.brand == company && x.model == model);
IdStatus idstatus = new IdStatus();
idstatus.id = mobileModel.Id;
idstatus.status = adStatus;
return(idstatus);
}
}
