public async Task <IHttpActionResult> PostGEST_Ordini_Teste(GEST_Ordini_Teste item) { try { AggiornaVersione(item.DeviceMail); if (!ExistOrdine(item.Id) && item.CloudState != 2) { item.NumeroOrdineDevice = GetNumeroOrdine(item.DeviceMail); item.NumeroOrdineGenerale = GetNumeroOrdineGenerale(); item.CloudState = 0; GEST_Ordini_Teste current = await InsertAsync(item); return(CreatedAtRoute("Tables", new { id = current.Id }, current)); } else { return(CreatedAtRoute("Tables", new { id = item.Id }, item)); } } catch (HttpResponseException re) { ControllerStatic.WriteErrorLog(mConnectionInfo, "GEST_Ordini_TesteController.PostGEST_Ordini_Teste", re, re.Response.ReasonPhrase); return(ResponseMessage(re.Response)); } catch (System.Exception e) { ControllerStatic.WriteErrorLog(mConnectionInfo, "GEST_Ordini_TesteController.PostGEST_Ordini_Teste", e, ""); } return(null); }
private int GetNumeroOrdineGenerale() { ConnectionInfo connectionInfo = ControllerStatic.GetDBSource(mCredentials); DBData db = new DBData(connectionInfo); int numeroOrdine = 1; string sql = string.Format("SELECT ISNULL(MAX(NumeroOrdineGenerale) + 1,0) As MaxOrdine FROM GEST_Ordini_Teste"); try { DataTable dt = db.ReadData(sql); if (dt.Rows.Count > 0) { numeroOrdine = (int)dt.Rows[0]["MaxOrdine"]; } } catch (Exception ex) { ControllerStatic.WriteErrorLog(connectionInfo, "GEST_Ordini_TesteController.GetNumeroOrdineGenerale", ex, sql); } finally { db.CloseConnection(); } return(numeroOrdine); }
// POST tables/GEST_Ordini_Righe public async Task <IHttpActionResult> PostGEST_Ordini_Righe(GEST_Ordini_Righe item) { try { if (!ExistOrdine(item.Id)) { item.CloudState = 0; GEST_Ordini_Righe current = await InsertAsync(item); return(CreatedAtRoute("Tables", new { id = current.Id }, current)); } else { return(CreatedAtRoute("Tables", new { id = item.Id }, item)); } } catch (HttpResponseException re) { ControllerStatic.WriteErrorLog(mConnectionInfo, "GEST_Ordini_RigheController", re, re.Response.ReasonPhrase); return(ResponseMessage(re.Response)); } catch (System.Exception e) { ControllerStatic.WriteErrorLog(mConnectionInfo, "GEST_Ordini_RigheController", e, ""); } return(null); }
protected virtual async Task InitializeBaseAsync(HttpControllerContext controllerContext) { base.Initialize(controllerContext); var claimsPrincipal = this.User as ClaimsPrincipal; mIsAutenticated = claimsPrincipal.Identity.IsAuthenticated; if (mIsAutenticated) { mCredentials = null; string sid = claimsPrincipal.FindFirst(ClaimTypes.NameIdentifier).Value; string provider = claimsPrincipal.FindFirst("http://schemas.microsoft.com/identity/claims/identityprovider").Value; switch (provider.ToLower()) { case "google": Task <GoogleCredentials> mAutenticateTask; mAutenticateTask = User.GetAppServiceIdentityAsync <GoogleCredentials>(controllerContext.Request); await RunSafe(mAutenticateTask); if (mAutenticateTask.IsCompleted) { mCredentials = mAutenticateTask.Result; mConnectionInfo = ControllerStatic.GetDBSource(mCredentials); } break; case "microsoftaccount": Task <MicrosoftAccountCredentials> mAutenticateTaskMicrosoft; mAutenticateTaskMicrosoft = User.GetAppServiceIdentityAsync <MicrosoftAccountCredentials>(controllerContext.Request); await RunSafe(mAutenticateTaskMicrosoft); if (mAutenticateTaskMicrosoft.IsCompleted) { mCredentials = mAutenticateTaskMicrosoft.Result; mConnectionInfo = ControllerStatic.GetDBSource(mCredentials); } break; case "facebook": Task <FacebookCredentials> mAutenticateTaskFacebook; mAutenticateTaskFacebook = User.GetAppServiceIdentityAsync <FacebookCredentials>(controllerContext.Request); await RunSafe(mAutenticateTaskFacebook); if (mAutenticateTaskFacebook.IsCompleted) { mCredentials = mAutenticateTaskFacebook.Result; mConnectionInfo = ControllerStatic.GetDBSource(mCredentials); } break; default: break; } } }
private string GetNumeroOrdine(string deviceMail) { ConnectionInfo connectionInfo = ControllerStatic.GetDBSource(mCredentials); DBData db = new DBData(connectionInfo); string sql = string.Empty; string numeroOrdine; string prefisso = string.Empty; string suffisso = string.Empty; try { sql = string.Format("SELECT IsNull(PrefissoNumerazione, '') As PrefissoNumerazione, IsNull(SuffissoNumerazione, '') As SuffissoNumerazione FROM DEVICE_ParametriDevice WHERE DeviceMail = '{0}'", deviceMail); DataTable dtParam = db.ReadData(sql); if (dtParam.Rows.Count > 0) { prefisso = (string)dtParam.Rows[0]["PrefissoNumerazione"]; suffisso = (string)dtParam.Rows[0]["SuffissoNumerazione"]; } sql = string.Format("SELECT ISNULL(MAX(CAST(SUBSTRING(NumeroOrdineDevice, {0}, 7) as int)),0) As MaxOrdine FROM GEST_Ordini_Teste WHERE DeviceMail = '{1}'", prefisso.Length + 1, deviceMail); DataTable dt = db.ReadData(sql); if (dt.Rows.Count > 0) { if (dt.Rows[0]["MaxOrdine"] != null) { numeroOrdine = ((int)dt.Rows[0]["MaxOrdine"] + 1).ToString().PadLeft(7, '0'); } else { numeroOrdine = "1".PadLeft(7, '0'); } } else { numeroOrdine = "1".PadLeft(7, '0'); } if (prefisso != "") { numeroOrdine = prefisso + numeroOrdine; } if (suffisso != "") { numeroOrdine = numeroOrdine + suffisso; } } catch (Exception ex) { ControllerStatic.WriteErrorLog(connectionInfo, "GEST_Ordini_TesteController.GetNumeroOrdine", ex, sql); return(""); } return(numeroOrdine); }
public Task <GEST_Ordini_Teste> PatchGEST_Ordini_Teste(string id, Delta <GEST_Ordini_Teste> patch) { try { return(UpdateAsync(id, patch)); } catch (System.Exception e) { ControllerStatic.WriteErrorLog(mConnectionInfo, "GEST_Ordini_TesteController.PatchGEST_Ordini_Teste", e, ""); } return(null); }
private void AggiornaVersione(string deviceMail) { ConnectionInfo connectionInfo = ControllerStatic.GetDBSource(mCredentials); DBData db = new DBData(connectionInfo); string sql = string.Empty; try { sql = string.Format("UPDATE DEVICE_ParametriDevice SET VersionCode = 11 WHERE DeviceMail = '{0}'", deviceMail); db.Execute(sql); } catch (Exception ex) { ControllerStatic.WriteErrorLog(connectionInfo, "GEST_Ordini_TesteController.AggiornaVersione", ex, sql); } finally { db.CloseConnection(); } }
public async Task <Authorization> Post(string idDevice) { ConnectionInfo connectionInfo = ControllerStatic.GetDBSource(mCredentials); Authorization authorizationModel = new Authorization(); if (connectionInfo.DBName != null && connectionInfo.DBName != "") { DBData db = new DBData(connectionInfo); string sql = "SELECT DeviceMail, IdAgente FROM DEVICE_ParametriDevice WHERE IdDevice = '" + idDevice + "'"; DataTable dt = db.ReadData(sql); db.CloseConnection(); string deviceMail = ""; int idAgente = 0; if (dt.Rows.Count > 0) { deviceMail = (string)dt.Rows[0]["DeviceMail"]; idAgente = (int)dt.Rows[0]["IdAgente"]; } authorizationModel.DBName = connectionInfo.DBName; authorizationModel.DeviceMail = deviceMail; authorizationModel.IdAgente = idAgente; authorizationModel.SuperUser = connectionInfo.SuperUser; authorizationModel.OAuthProvider = (short)mAuthProvider; authorizationModel.AccesDenied = false; if (idAgente == 0) { ControllerStatic.WriteErrorLog(connectionInfo, "Authorization.Post", idDevice); } } else { authorizationModel.AccesDenied = true; } return(authorizationModel); }
public IQueryable <DEVICE_ParametriDevice> GetAllGEST_ParametriDevice() { IQueryable <DEVICE_ParametriDevice> i = null; try { DEVICE_ParametriDevice firstElement; i = Query(); if (i.Count() > 0) { firstElement = i.First(); } return(i); } catch (System.Exception e) { ControllerStatic.WriteErrorLog(mConnectionInfo, "GEST_ParametriDeviceController", e, i.ToString()); } return(null); }
public IQueryable <GEST_Condizione_Pagamento> GetAllGEST_Condizione_Pagamento() { IQueryable <GEST_Condizione_Pagamento> i = null; try { GEST_Condizione_Pagamento firstElement; i = Query(); if (i.Count() > 0) { firstElement = i.First(); } return(i); } catch (System.Exception e) { ControllerStatic.WriteErrorLog(mConnectionInfo, "GEST_Condizione_PagamentoController", e, i.ToString()); } return(null); }
public IQueryable <GEST_Articoli_BarCode> GetAllGEST_Articoli_Barcode() { IQueryable <GEST_Articoli_BarCode> i = null; try { GEST_Articoli_BarCode firstElement; i = Query(); if (i.Count() > 0) { firstElement = i.First(); } return(i); } catch (System.Exception e) { ControllerStatic.WriteErrorLog(mConnectionInfo, "GEST_Articoli_BarcodeController", e, i.ToString()); } return(null); }
public IQueryable <GEST_Update_Immagini> GetAllGEST_Update_Immagini() { IQueryable <GEST_Update_Immagini> i = null; try { GEST_Update_Immagini firstElement; i = Query(); if (i.Count() > 0) { firstElement = i.First(); } return(i); } catch (System.Exception e) { ControllerStatic.WriteErrorLog(mConnectionInfo, "GEST_Update_ImmaginiController", e, i.ToString()); } return(null); }
public IQueryable <GEST_Clienti_Anagrafica_Indirizzi> GetAllGEST_Anagrafica_Indirizzi() { IQueryable <GEST_Clienti_Anagrafica_Indirizzi> i = null; try { GEST_Clienti_Anagrafica_Indirizzi firstElement; i = Query(); if (i.Count() > 0) { firstElement = i.First(); } return(i); } catch (System.Exception e) { ControllerStatic.WriteErrorLog(mConnectionInfo, "GEST_Clienti_Anagrafica_IndirizziController", e, i.ToString()); } return(null); }
public IQueryable <Permission> GetAllPermission() { IQueryable <Permission> i = null; try { Permission firstElement; i = Query(); if (i.Count() > 0) { firstElement = i.First(); } return(i); } catch (System.Exception e) { ControllerStatic.WriteErrorLog(mConnectionInfo, "PermissionController", e, i.ToString()); } return(null); }