public ActionResult GetCovid19Data()
{
var covid19 = new Covid19ViewModel();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("https://api.covid19api.com/");
try
{
var response =
client.GetAsync("summary?fbclid=IwAR0OKbr_6W79uEpZ5HExsnOie2NdJCu7hSev_JQgYV4SM5KiM9A5LVCTyDs").Result;
if (response.IsSuccessStatusCode)
{
covid19 = response.Content.ReadAsAsync <Covid19ViewModel>().Result; // install-package Microsoft.AspNet.WebApi.Client is needed for ReadAsAsync<>
}
else
{
ViewBag.Message = " server error";
}
}
catch (Exception ex)
{
GlobalViewModel globalViewModel = new GlobalViewModel();
globalViewModel.TotalDeaths = 0;
globalViewModel.NewConfirmed = 0;
globalViewModel.NewDeaths = 0;
covid19.Global = globalViewModel;
Console.WriteLine("Missing data..");
}
}
return(PartialView("_GetCovid19Data", covid19));
}
public UserCardWindow(bool createMode, bool editMode, bool viewMode)
{
InitializeComponent();
VM = App.Current.Resources["GlobalViewModel"] as GlobalViewModel;
VM._userCardViewModel.CreateMode = createMode;
VM._userCardViewModel.EditMode = editMode;
VM._userCardViewModel.ViewMode = viewMode;
VM._userCardViewModel.Acronym = " ";
VM._userCardViewModel.Name = " ";
VM._userCardViewModel.Surname = " ";
VM._userCardViewModel.Password = "******";
VM._userCardViewModel.PESEL = " ";
VM._userCardViewModel.eMail = " ";
VM._userCardViewModel.City = " ";
VM._userCardViewModel.Province = " ";
VM._userCardViewModel.PostalCode = " ";
VM._userCardViewModel.ConfigAuthorization = false;
VM._userCardViewModel.DatabaseManagerAuthorization = false;
VM._userCardViewModel.DeletingOtherUsersRecords = false;
VM._userCardViewModel.EditingOtherUsersRecords = false;
VM._userCardViewModel.HouseNumber = " ";
VM._userCardViewModel.StreetName = " ";
VM._userCardViewModel.StreetNumber = " ";
VM._userCardViewModel.ViewOtherUsersRecords = false;
VM._userCardViewModel.UsersListAuthorization = false;
VM._userCardViewModel.IncomesAndExpensesListAuthorization = false;
VM._userCardViewModel.Gender = 1;
VM._userCardViewModel.IsAdmin = false;
}
public IncomesAndExpensesRecord(int ID, bool EditMode)
{
InitializeComponent();
VM = App.Current.Resources["GlobalViewModel"] as GlobalViewModel;
VM._incomesAndExpensesRecordViewModel.Edycja(ID, EditMode);
}
public override void OnActionExecuting(ActionExecutedContext filterContext)
{
GlobalViewModel model = null;
var viewResult = filterContext.Result as ViewResultBase;
if (viewResult != null)
{
// The action returned a ViewResult or PartialViewResult
// so we could attempt to read the model that was passed
model = viewResult.Model as GlobalViewModel;
}
if (model == null)
{
var jsonResult = filterContext.Result as JsonResult;
if (jsonResult != null)
{
// The action returned a JsonResult
// so we could attempt to read the model that was passed
model = jsonResult.Data as GlobalViewModel;
}
}
if (model != null)
{
// We've managed to read the model
// Now we can set its NewMessages property
model.NewMessages = GetNewMessages();
}
}
public JsonResult EditMark([FromBody] GlobalViewModel model)
{
Result <TcpExample.Domain.DBModel.Mark> result = new Result <TcpExample.Domain.DBModel.Mark>();
if (model.MarkCode != null && model.MarkCode.Length == 1 && model.MarkName != null && model.MarkName.Length > 0)
{
var mark = _markService.GetMark(model.MarkCode);
if (mark.Data != null)
{
mark.Data.Name = model.MarkName;
var addResult = _markService.EditMark(mark.Data);
return(new JsonResult(addResult));
}
else
{
result.Success = false;
result.Message = "This mark is not exists !!";
}
}
else
{
result.Success = false;
result.Message = "Invalid data !!";
}
return(new JsonResult(result));
}
public JsonResult EditDevice([FromBody] GlobalViewModel model)
{
Result <TcpExample.Domain.DBModel.Device> result = new Result <TcpExample.Domain.DBModel.Device>();
long serialnumber;
if (
model.MarkCode != null && model.MarkCode.Length == 1 &&
model.SerialNumber != null && long.TryParse(model.SerialNumber, out serialnumber) && serialnumber > 0 &&
model.IpAddress != null && model.IpAddress.Length > 0 &&
model.Port != null && model.Port.Length > 0)
{
var device = _deviceService.GetDevice(model.MarkCode, serialnumber);
if (device.Data != null)
{
device.Data.IpAddress = model.IpAddress;
device.Data.Port = model.Port;
var addResult = _deviceService.EditDevice(device.Data);
return(new JsonResult(addResult));
}
else
{
result.Success = false;
result.Message = "This mark is not exists !!";
}
}
else
{
result.Success = false;
result.Message = "Invalid data !!";
}
return(new JsonResult(result));
}
public JsonResult DeleteDevice([FromBody] GlobalViewModel model)
{
Result result = new Result();
long serialnumber;
if (long.TryParse(model.SerialNumber, out serialnumber))
{
var device = _deviceService.GetDevice(model.MarkCode, serialnumber);
if (device.Success)
{
var deleteResult = _deviceService.RemoveDevice(device.Data);
if (deleteResult.Success)
{
result.Success = true;
}
else
{
result.Success = false;
result.Message = deleteResult.Message;
}
}
else
{
result.Success = false;
result.Message = "Device is not exists";
}
}
else
{
result.Success = false;
result.Message = "Invalid data";
}
return(new JsonResult(result));
}
public JsonResult DeleteMark([FromBody] GlobalViewModel model)
{
Result result = new Result();
var mark = _markService.GetMark(model.MarkCode);
if (mark.Success)
{
if (mark.Data.Devices.Where(a => a.IsDeleted == false).Count() > 0)
{
result.Success = false;
result.Message = "This mark have some Devices! You first must delete devices";
}
else
{
var deleteResult = _markService.RemoveMark(mark.Data);
if (deleteResult.Success)
{
result.Success = true;
}
else
{
result.Success = false;
result.Message = deleteResult.Message;
}
}
}
else
{
result.Success = false;
result.Message = "Mark is not exists";
}
return(new JsonResult(result));
}
public void EnviarEmailCliente(GlobalViewModel dados)
{
SmtpClient client = new SmtpClient
{
Host = "smtp.live.com",
EnableSsl = true,
Credentials = new System.Net.NetworkCredential(EMAIL_ACESSO, EMAIL_SENHA)
};
MailMessage mail = new MailMessage
{
From = new MailAddress("*****@*****.**", "Não Responda: Sistema de agendamento de manutenções")
};
mail.To.Add(new MailAddress(dados.Cliente.EMail));
mail.Subject = "Agendamento cliente " + dados.Cliente.Nome;
mail.Body = " Olá!! Está confirmado a manutenção de seu veículo para " + dados.Servico.DataManutencao.Day + "/" + dados.Servico.DataManutencao.Month + "/" + dados.Servico.DataManutencao.Year + ". O endereço da oficina é: " +
"Rua Valdemar Martins, 1110 - Parque Peruche, São Paulo. Link do Google Maps: " + MAPA;
mail.IsBodyHtml = true;
mail.Priority = MailPriority.High;
try
{
client.Send(mail);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
mail = null;
}
}
public static void AddDocuments()
{
_globalVM = new GlobalViewModel(VM);
_configVM = new ConfigurationViewModel(VM);
_clearConfigButton.Command = new RelayCommand(_configVM.ClearConfig, ReturnTrue);
_loadXmlConfigButton.Command = new RelayCommand(_configVM.LoadXmlConfig, _configVM.ReturnTrue);
_saveXmlConfigButton.Command = new RelayCommand(_configVM.SaveXmlConfig, _configVM.ReturnTrue);
_loadIniConfigButton.Command = new RelayCommand(_configVM.LoadIniConfig, _configVM.ReturnTrue);
_saveIniConfigButton.Command = new RelayCommand(_configVM.SaveIniConfig, _configVM.ReturnTrue);
_dbVM = new DatabaseViewModel(VM);
_httpVM = new HttpServerViewModel(VM);
_tcpVM = new TcpServerViewModel(VM);
_reportingVM = new ReportingViewModel(VM);
_propertyVM = new PropertyViewModel(VM);
VM.Documents.Add(_globalVM);
VM.Documents.Add(_configVM);
VM.Documents.Add(_dbVM);
VM.Documents.Add(_httpVM);
VM.Documents.Add(_tcpVM);
VM.Documents.Add(_reportingVM);
VM.Tools.Add(_propertyVM);
}
public ActionResult SaveData(GlobalViewModel dados)
{
int result = _appService.VerificarDataManutencao(dados.Servico.DataManutencao);
if (result == CAPACIDADE_MAXIMA)
{
_lista.AgendaCheia = true;
return(View("Index", _lista));
}
else
{
if (dados.Servico.DataManutencao.DayOfWeek == DayOfWeek.Sunday)
{
_lista.Domingo = true;
return(View("Index", _lista));
}
_lista.AgendaVazia = true;
_appService.AgendarManutencao(dados);
_appService.EnviarEmail(dados);
_appService.EnviarEmailCliente(dados);
return(View("Index", _lista));
}
}
private GlobalViewModel getModel(string SEOUrl)
{
var model = new GlobalViewModel();
Uri baseUri = Url.RequestContext.HttpContext.Request.Url;
string baseUrl = baseUri.LocalPath.Length <= 1 ? baseUri.AbsoluteUri : (baseUri.AbsoluteUri.Replace(baseUri.LocalPath, "") + "/");
UrlMapper = new UrlMapper(Unit, new Uri(baseUrl), SEOUrl);
if (!UrlMapper.IsValide)
{
throw new Exception();
}
model.SiteSetting = Unit.SiteSettingRepository.GetByID(_Globals.Instance.CurrentSiteSettingId);
FillModelWithSiteInfo(model);
FillModelWithNavInfo(model, UrlMapper.Site.Url);
//
if (UrlMapper.Widget != null && UrlMapper.Widget.GetType().Name == "WidgetPageHeader")
{
WidgetPageHeader wHead = (UrlMapper.Widget as WidgetPageHeader);
var ws = UrlMapper.Site.Widgets.Where(w => w.Id != wHead.Id);
wHead.FirstNonHeaderUrl = ws.Count() == 0 ? "/" : UrlMapper.GetVersion(ws.First()).Url;
wHead.FirstNonHeaderUrl = Regex.Replace("/" + UrlMapper.SiteUrl + "/" + wHead.FirstNonHeaderUrl + "/", @"[/]+", "/");
}
model.IsPreview = UrlMapper.IsPreview;
return(model);
}
public JsonResult AddMark([FromBody] GlobalViewModel model)
{
Result <TcpExample.Domain.DBModel.Mark> result = new Result <TcpExample.Domain.DBModel.Mark>();
if (model.MarkCode != null && model.MarkCode.Length == 1 && model.MarkName != null && model.MarkName.Length > 0)
{
var mark = _markService.GetMark(model.MarkCode);
if (mark.Data == null)
{
TcpExample.Domain.DBModel.Mark newMark = new Domain.DBModel.Mark()
{
Code = model.MarkCode,
Name = model.MarkName
};
var addResult = _markService.AddMark(newMark);
return(new JsonResult(addResult));
}
else
{
result.Success = false;
result.Message = "This code is exists !!";
}
}
else
{
result.Success = false;
result.Message = "Invalid data !!";
}
return(new JsonResult(result));
}
// infiniteContent
public ActionResult GetWidgetByFullUrl(string SEOUrl = null)
{
SEOUrl = Regex.Replace("/" + SEOUrl.ToLower() + "/", @"[/]+", "/");
GlobalViewModel homeModel = null;
try
{
homeModel = this.getModel(SEOUrl);
}
catch (Exception)
{
return(Content(string.Empty));
}
ActionResult actionResult = null;
if ((actionResult = RedirectIfSiteSecured(UrlMapper.Site)) != null)
{
throw new Exception("access denied");
}
WidgetViewModel widgetModel = new WidgetViewModel();
widgetModel.Widget = UrlMapper.Widget == null?UrlMapper.GetVersion(homeModel.Site.Widgets.Where(wm => UrlMapper.GetVersion(wm) != null).First()) : UrlMapper.Widget;
widgetModel.IsNavPoint = homeModel.Site.WidgetNavigations.Contains(widgetModel.Widget.Id);
widgetModel.SiteId = homeModel.Site.Id;
widgetModel.SocialUrl = UrlMapper.FlatUrl;
return(PartialView("_Widget", widgetModel));
}
private void FillModelWithSiteInfo(GlobalViewModel model)
{
model.Site = UrlMapper.Site;
model.SEOSiteUrl = model.Site.Url;
model.SEOSiteUrl = UrlMapper.SiteUrl;
model.SEODeepUrl = UrlMapper.DeepUrl;
model.RequestedWidgetId = UrlMapper.Widget == null ? Guid.Empty : UrlMapper.Widget.Id;
}
private void FillModelWithNavInfo(GlobalViewModel model, string SEOUrl)
{
model.Sites = Unit.SiteManagerRepository.Get(s => s.SiteSettingId == _Globals.Instance.CurrentSiteSettingId).Where(sm => UrlMapper.GetVersion(sm) != null).Select(sm => UrlMapper.GetVersion(sm)).ToList();
foreach (var site in model.Sites)
{
site.OnLoad(Unit);
}
}
public void EnviarEmail(GlobalViewModel dados)
{
SmtpClient client = new SmtpClient
{
Host = "smtp.live.com",
EnableSsl = true,
Credentials = new System.Net.NetworkCredential(EMAIL_ACESSO, EMAIL_SENHA)
};
MailMessage mail = new MailMessage
{
From = new MailAddress("*****@*****.**", "Sistema de agendamento de manutenções")
};
mail.To.Add(new MailAddress("*****@*****.**"));
mail.Subject = "Agendamento cliente " + dados.Cliente.Nome;
mail.Body = " Olá!! Abaixo segue dados do cliente que agendou manutenção de seu carango : <br/><br/>" +
"Dados do cliente :<br/> Nome: " + dados.Cliente.Nome +
"<br/> Email : " + dados.Cliente.EMail +
"<br/> Telefone : " + dados.Cliente.Telefone +
"<br/> Marca Veiculo : " + dados.Veiculo.Marca.ToString() +
"<br/> Modelo Veiculo : " + dados.Veiculo.Modelo.ToString() +
"<br/> Ano Veiculo : " + dados.Veiculo.AnoVeiculo.ToString() +
"<br/> Data de manutenção solicitada : " + dados.Servico.DataManutencao.Day + "/" + dados.Servico.DataManutencao.Month + "/" + dados.Servico.DataManutencao.Year +
"<br/> Serviços a serem feitos : <br />";
if (dados.Servico.Completo == true)
{
mail.Body += "- Serviço completo <br/>";
}
if (dados.Servico.Mecanica == true)
{
mail.Body += "- Serviço de mecânica <br />";
}
if (dados.Servico.Suspensao == true)
{
mail.Body += "- Serviço de suspensão <br />";
}
if (dados.Servico.Freio == true)
{
mail.Body += "- Serviço de freio";
}
mail.IsBodyHtml = true;
mail.Priority = MailPriority.High;
try
{
client.Send(mail);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
mail = null;
}
}
public IActionResult Index()
{
GlobalViewModel globalViewModel = new GlobalViewModel()
{
AggregateStatisticsViewModel = new AggregateStatisticsViewModel(_service, _config),
NavViewModel = new NavViewModel(_service)
};
return(View("AggregateStatistics", globalViewModel));
}
public IncomesAndExpensesRecord(bool _createMode, bool _editMode, bool _viewMode)
{
InitializeComponent();
VM = App.Current.Resources["GlobalViewModel"] as GlobalViewModel;
VM._incomesAndExpensesRecordViewModel.CreateMode = _createMode;
VM._incomesAndExpensesRecordViewModel.EditMode = _editMode;
VM._incomesAndExpensesRecordViewModel.ViewMode = _viewMode;
VM._incomesAndExpensesRecordViewModel.UserId = VM._incomesAndExpensesRecordViewModel.GetUserId();
VM._incomesAndExpensesRecordViewModel.AdditionalBenefits = 0.00m;
VM._incomesAndExpensesRecordViewModel.Alcohol = 0.00m;
VM._incomesAndExpensesRecordViewModel.AllegroSales = 0.00m;
VM._incomesAndExpensesRecordViewModel.Bonus = 0.00m;
VM._incomesAndExpensesRecordViewModel.BreakfastIngredients = 0.00m;
VM._incomesAndExpensesRecordViewModel.BusTickets = 0.00m;
VM._incomesAndExpensesRecordViewModel.Cinema = 0.00m;
VM._incomesAndExpensesRecordViewModel.ComputerProgramming = 0.00m;
VM._incomesAndExpensesRecordViewModel.DanceCourse = 0.00m;
VM._incomesAndExpensesRecordViewModel.DinnerIngredients = 0.00m;
VM._incomesAndExpensesRecordViewModel.EBaySales = 0.00m;
VM._incomesAndExpensesRecordViewModel.FlatRepairs = 0.00m;
VM._incomesAndExpensesRecordViewModel.Fruit = 0.00m;
VM._incomesAndExpensesRecordViewModel.Gas = 0.00m;
VM._incomesAndExpensesRecordViewModel.Inheritance = 0.00m;
VM._incomesAndExpensesRecordViewModel.Internet = 0.00m;
VM._incomesAndExpensesRecordViewModel.JunkFood = 0.00m;
VM._incomesAndExpensesRecordViewModel.Lottery = 0.00m;
VM._incomesAndExpensesRecordViewModel.MiniaturesSales = 0.00m;
VM._incomesAndExpensesRecordViewModel.MoneyFromFamily = 0.00m;
VM._incomesAndExpensesRecordViewModel.MonthlyPublicTransportTicket = 0.00m;
VM._incomesAndExpensesRecordViewModel.Multisport = 0.00m;
VM._incomesAndExpensesRecordViewModel.OtherBeverages = 0.00m;
VM._incomesAndExpensesRecordViewModel.OtherCommissionIncomes = 0.00m;
VM._incomesAndExpensesRecordViewModel.OtherFlatExpenses = 0.00m;
VM._incomesAndExpensesRecordViewModel.OtherIncomes = 0.00m;
VM._incomesAndExpensesRecordViewModel.OtherPartyExpenses = 0.00m;
VM._incomesAndExpensesRecordViewModel.OtherPresentsIncomes = 0.00m;
VM._incomesAndExpensesRecordViewModel.OtherSalesIncomes = 0.00m;
VM._incomesAndExpensesRecordViewModel.Painting = 0.00m;
VM._incomesAndExpensesRecordViewModel.Presents = 0.00m;
VM._incomesAndExpensesRecordViewModel.Rent = 0.00m;
VM._incomesAndExpensesRecordViewModel.ReportDate = DateTime.Now;
VM._incomesAndExpensesRecordViewModel.Salary = 0.00m;
VM._incomesAndExpensesRecordViewModel.Service = 0.00m;
VM._incomesAndExpensesRecordViewModel.Supplements = 0.00m;
VM._incomesAndExpensesRecordViewModel.Sweets = 0.00m;
VM._incomesAndExpensesRecordViewModel.Telephone = 0.00m;
VM._incomesAndExpensesRecordViewModel.Theatre = 0.00m;
VM._incomesAndExpensesRecordViewModel.Training = 0.00m;
VM._incomesAndExpensesRecordViewModel.TrainTickets = 0.00m;
VM._incomesAndExpensesRecordViewModel.Vegetables = 0.00m;
VM._incomesAndExpensesRecordViewModel.Water = 0.00m;
}
public HttpResponseMessage Get()
{
var config = this.config.GlobalConfiguration;
var vm = new GlobalViewModel
{
Name = config.AuthorizationServerName,
Logo = config.AuthorizationServerLogoUrl,
Issuer = config.Issuer
};
return(Request.CreateResponse(HttpStatusCode.OK, vm));
}
public CustomersViewModel(GlobalViewModel globalViewModel, ICustomerStore customerStore)
{
this.GlobalViewModel = globalViewModel;
_customerStore = customerStore;
_customerObserver = new Observer<IEnumerable<Customer>>(null, null, OnNextCustomers);
_customerStore.Subscribe(_customerObserver);
this.Customers = new ObservableCollection<CustomerViewModel>();
this.RefreshCommand = new DelegateCommand(Refresh);
}
public void Execute(object parameter)
{
OpenFileDialog dialog = new OpenFileDialog
{
Filter = "Pointcloud file (*.pcd) |*.pcd| All files (*.*) | *.*",
Multiselect = false
};
if (dialog.ShowDialog() == DialogResult.OK)
{
GlobalViewModel model = (GlobalViewModel)_viewModel;
model.FileName = dialog.FileName;
}
}
public ActionResult Customers()
{
GlobalViewModel globalModel = new GlobalViewModel();
//List<GenderViewModel> genders = new List<GenderViewModel>();
//List<LanguageViewModel> languages = new List<LanguageViewModel>();
try
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand("SELECT * FROM Gender", myConnection);
SqlDataReader myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
GenderViewModel gender = new GenderViewModel();
gender.ID = myReader["GenderID"].ToString();
gender.Description = myReader["GenderDescription"].ToString();
//genders.Add(gender);
globalModel.genders.Add(gender);
}
myConnection.Close();
myConnection.Open();
SqlCommand myNewCommand = new SqlCommand("SELECT * FROM Preferred_Language", myConnection);
SqlDataReader myNewReader = myNewCommand.ExecuteReader();
while (myNewReader.Read())
{
LanguageViewModel language = new LanguageViewModel();
language.ID = myNewReader["LanguageID"].ToString();
language.Name = myNewReader["LanguageName"].ToString();
//languages.Add(language);
globalModel.languages.Add(language);
}
}
catch (Exception err)
{
ViewBag.Message = err.Message;
}
finally
{
myConnection.Close();
}
return(View(globalModel));
}
public HomeController(IAppServiceHandler appServiceHandler, GlobalViewModel lista)
{
_appService = appServiceHandler;
lista = new GlobalViewModel()
{
VeiculoMarca = _appService.PopularMarca(),
VeiculoModelo = _appService.PopularModelo(),
VeiculoAno = _appService.PopularAno(),
AgendaCheia = lista.AgendaCheia,
AgendaVazia = lista.AgendaVazia
};
_lista = lista;
}
public IActionResult Edit(GlobalViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var query = _dbContext.SystemSetting.FirstOrDefault(x => x.ClobalUuid == model.ClobalUuid);
query.ClobalName = model.ClobalName;
query.GlobalLogo = model.GlobalLogo;
query.Globalurl = model.Globalurl;
query.AddTime = DateTime.Now;
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public UserCardWindow(int ID, bool editMode)
{
InitializeComponent();
VM = App.Current.Resources["GlobalViewModel"] as GlobalViewModel;
var _pass = (from p in VM._dataContext.Users
where p.Id == ID
select p.Password).SingleOrDefault();
haslo.Password = _pass;
VM._userCardViewModel.WypelnijListeWojewodztw();
VM._userCardViewModel.EdycjaUzytkownika(ID, editMode);
}
public HttpResponseMessage Put(GlobalViewModel model)
{
if (!ModelState.IsValid)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState.GetErrors()));
}
var config = this.config.GlobalConfiguration;
this.config.GlobalConfiguration.AuthorizationServerName = model.Name;
this.config.GlobalConfiguration.AuthorizationServerLogoUrl = model.Logo;
this.config.GlobalConfiguration.Issuer = model.Issuer;
this.config.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
public void AgendarManutencao(GlobalViewModel dados)
{
try
{
MySqlCommand Comm;
DatabaseConnection = conexaoBanco();
Comm = DatabaseConnection.CreateCommand();
Comm.CommandText = "USE CARSERVICE";
Comm.ExecuteNonQuery();
Comm.CommandText = "INSERT INTO CLIENTE (NOME, EMAIL, TELEFONE) VALUES (@NOME, @EMAIL, @TELEFONE)";
Comm.Parameters.AddWithValue("@NOME", dados.Cliente.Nome);
Comm.Parameters.AddWithValue("@EMAIL", dados.Cliente.EMail);
Comm.Parameters.AddWithValue("@TELEFONE", dados.Cliente.Telefone);
Comm.ExecuteNonQuery();
Comm.CommandText = "INSERT INTO VEICULO (VEICULO_MARCA, VEICULO_MODELO, VEICULO_ANO) VALUES (@VEICULO_MARCA, @VEICULO_MODELO, @VEICULO_ANO)";
Comm.Parameters.AddWithValue("@VEICULO_MARCA", dados.Veiculo.Marca);
Comm.Parameters.AddWithValue("@VEICULO_MODELO", dados.Veiculo.Modelo);
Comm.Parameters.AddWithValue("@VEICULO_ANO", dados.Veiculo.AnoVeiculo);
Comm.ExecuteNonQuery();
Comm.CommandText = "INSERT INTO SERVICO (SERVICO_COMPLETO, SERVICO_MECANICA, SERVICO_SUSPENSAO, SERVICO_FREIO, MANUTENCAO_DATA) VALUES (@SERVICO_COMPLETO, @SERVICO_MECANICA, @SERVICO_SUSPENSAO, @SERVICO_FREIO, @MANUTENCAO_DATA)";
Comm.Parameters.AddWithValue("@SERVICO_COMPLETO", dados.Servico.Completo);
Comm.Parameters.AddWithValue("@SERVICO_MECANICA", dados.Servico.Mecanica);
Comm.Parameters.AddWithValue("@SERVICO_SUSPENSAO", dados.Servico.Suspensao);
Comm.Parameters.AddWithValue("@SERVICO_FREIO", dados.Servico.Freio);
Comm.Parameters.AddWithValue("@MANUTENCAO_DATA", dados.Servico.DataManutencao);
Comm.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (DatabaseConnection.State == ConnectionState.Open)
{
DatabaseConnection.Dispose();
}
}
}
public IActionResult Index(CmsIdViewModel cmsIdViewModel)
{
GlobalViewModel globalViewModel = new GlobalViewModel()
{
StatisticsViewModel = new StatisticsViewModel(_service, cmsIdViewModel.CmsId, _config),
NavViewModel = new NavViewModel(_service),
GraphControlsViewModel = new GraphControlsViewModel()
{
DisplayRecommendedMediaLimit = _config.Value.DisplayRecommendedMediaLimit,
RecommendedMediaLimitValue = _config.Value.RecommendedMediaLimitValue
}
};
if (_config.Value.DisplayRecommendedMediaLimit)
{
return(View("Index", globalViewModel));
}
return(View("IndexNoMediaLimit", globalViewModel));
}
//START
public ActionResult Index(string SEOUrl = "/")
{
SEOUrl = Regex.Replace("/" + SEOUrl.ToLower() + "/", @"[/]+", "/");
GlobalViewModel model = null;
try
{
model = getModel(SEOUrl);
}
catch (Exception)
{
try
{
ActionResult actionResult = null;
if ((actionResult = RedirectIfRequired(SEOUrl)) != null)
{
return(actionResult);
}
}
catch (Exception)
{
if (SEOUrl == "/")
{
return(new HttpNotFoundResult("Sorry, page not found!"));
}
return(this.Index("/"));
}
}
{
ActionResult actionResult = null;
if ((actionResult = RedirectIfSiteSecured(UrlMapper.Site)) != null)
{
return(actionResult);
}
}
return(View(model));
}
public JsonResult AddDevice([FromBody] GlobalViewModel model)
{
Result <TcpExample.Domain.DBModel.Device> result = new Result <TcpExample.Domain.DBModel.Device>();
long serialnumber;
if (
model.MarkCode != null && model.MarkCode.Length == 1 &&
model.SerialNumber != null && long.TryParse(model.SerialNumber, out serialnumber) && serialnumber > 0 &&
model.IpAddress != null && model.IpAddress.Length > 0 &&
model.Port != null && model.Port.Length > 0)
{
var mark = _markService.GetMark(model.MarkCode);
if (mark.Data != null)
{
TcpExample.Domain.DBModel.Device newDevice = new Domain.DBModel.Device()
{
SerialNumber = serialnumber,
MarkCode = model.MarkCode,
IpAddress = model.IpAddress,
Port = model.Port
};
var addResult = _deviceService.AddDevice(newDevice);
return(new JsonResult(addResult));
}
else
{
result.Success = false;
result.Message = "Slected MArk is not exists !!";
}
}
else
{
result.Success = false;
result.Message = "Invalid data !!";
}
return(new JsonResult(result));
}
