public void EditBattery(string id, BatteryModel model) { int Id = int.Parse(id); var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("GyrodataTracker"))) { var p = new DynamicParameters(); p.Add("@Id", Id); p.Add("@BoxNumber", model.BoxNumber); p.Add("@BatteryCondition", model.BatteryCondition); p.Add("@SerialOne", model.SerialOne); p.Add("@SerialTwo", model.SerialTwo); p.Add("@SerialThr", model.SerialThr); p.Add("@CCD", model.CCD); p.Add("@Invoice", model.Invoice); p.Add("@BatteryStatus", model.BatteryStatus); p.Add("@Arrived", model.Arrived); p.Add("@Container", model.Container); p.Add("@Comment", model.Comment); connection.Execute("spBattery_Update", p, commandType: CommandType.StoredProcedure); } } } }
public List <BatteryModel> GetSelectedBatteries(string serial, string where) { List <BatteryModel> batteryList = new List <BatteryModel>(); var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { using (IDbConnection connection = new SqlConnection(GlobalConfig.CnnString("GyrodataTracker"))) { if (connection.State == ConnectionState.Closed) { connection.Open(); } var p = new DynamicParameters(); p.Add("@SearchWhat", serial); p.Add("@SearchWhere", where); return(connection.Query <BatteryModel>("spGetCustomBatteryData", p, commandType: CommandType.StoredProcedure).ToList()); } } return(null); } }
public int AddNewItem(ItemModel model) { var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("GyrodataTracker"))) { var p = new DynamicParameters(); p.Add("@Item", model.Item); p.Add("@Asset", model.Asset); p.Add("@Arrived", model.Arrived); p.Add("@Invoice", model.Invoice); p.Add("@CCD", model.CCD); p.Add("@NameRus", model.NameRus); p.Add("@PositionCCD", model.PositionCCD); p.Add("@ItemStatus", model.ItemStatus); p.Add("@Box", model.Box); p.Add("@Container", model.Container); p.Add("@Comment", model.Comment); p.Add("@ItemImage", model.ItemImage); p.Add("@Id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); connection.Execute("dbo.spItems_Insert", p, commandType: CommandType.StoredProcedure); model.Id = p.Get <int>("@Id"); } } } return(model.Id); }
public void EditItem(string Id, ItemModel model) { int id = int.Parse(Id); var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("GyrodataTracker"))) { var p = new DynamicParameters(); p.Add("@Id", id); p.Add("@ItemItem", model.Item); p.Add("@ItemAsset", model.Asset); p.Add("@ItemArrived", model.Arrived); p.Add("@ItemInvoice", model.Invoice); p.Add("@ItemCCD", model.CCD); p.Add("@ItemNameRus", model.NameRus); p.Add("@PositionCCD", model.PositionCCD); p.Add("@ItemStatus", model.ItemStatus); p.Add("@ItemBox", model.Box); p.Add("@Container", model.Container); p.Add("@Comment", model.Comment); p.Add("@ItemImage", model.ItemImage); connection.Execute("dbo.spUpdate_Item", p, commandType: CommandType.StoredProcedure); } } } }
// END LOADING DATA FOR JOB CREATION ******* // Loading Custom Jobs based on what and where public List <JobModel> GetCustomJobData(string what, string where) { var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("GyrodataTracker"))) { if (connection.State == ConnectionState.Closed) { connection.Open(); } var p = new DynamicParameters(); p.Add("@SearchWhat", what); p.Add("@SearchWhere", where); return(connection.Query <JobModel>("spGetCustomJobData", p, commandType: CommandType.StoredProcedure).ToList()); // TODO - remove further //return connection.Query<JobModel>("spGetCustomJobsDataANDROID", p, commandType: CommandType.StoredProcedure).ToList(); } } return(null); } }
public int AddBattery(BatteryModel model) { var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { using (IDbConnection connection = new SqlConnection(GlobalConfig.CnnString("GyrodataTracker"))) { var p = new DynamicParameters(); p.Add("@BoxNumber", model.BoxNumber); p.Add("@BatteryCondition", model.BatteryCondition); p.Add("@SerialOne", model.SerialOne); p.Add("@SerialTwo", model.SerialTwo); p.Add("@SerialThr", model.SerialThr); p.Add("@CCD", model.CCD); p.Add("@Invoice", model.Invoice); p.Add("@BatteryStatus", model.BatteryStatus); p.Add("@Arrived", model.Arrived); p.Add("@Container", model.Container); p.Add("@Comment", model.Comment); p.Add("@Id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); connection.Execute("dbo.spBatteries_Insert", p, commandType: CommandType.StoredProcedure); model.Id = p.Get <int>("@Id"); } } } return(model.Id); }
public List <JobModel> GetJobsInvolvedIn(string id) { var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { using (IDbConnection connection = new SqlConnection(GlobalConfig.CnnString("GyrodataTracker"))) { if (connection.State == ConnectionState.Closed) { connection.Open(); } var p = new DynamicParameters(); p.Add("@ItemId", id); return(connection.Query <JobModel>("spGetJobsInvolvedInData", p, commandType: CommandType.StoredProcedure).ToList()); } } return(null); } }
public string Test() { var token = HttpContext.Current.Request.Headers["Authorization"]; token = token.Substring(7); ITokenValidator validator = new DatabaseTokenValidator(); return(validator.IsValid(token) ? "Your token worked!" : "Your token failed!"); }
public string Test() { var token = HttpContext.Current.Request.Headers["Token"]; using (var dbContext = new BasicTokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); return(validator.IsValid(token) ? "Your token worked!" : "Your token failed!"); } }
public List <ReflashRequest> GetReflashRequests(int userId, string token) { ITokenValidator validator = new DatabaseTokenValidator(); if (validator.IsValid(token)) { return(new VtecTeamDBManager().GetReflashRequests(userId)); } throw new FaultException("Срок рабочей сессии истек, преезапустите программу"); }
public bool UpdateReflashHistory(ReflashHistory history, string token) { ITokenValidator validator = new DatabaseTokenValidator(); if (validator.IsValid(token)) { return(new VtecTeamDBManager().UpdateReflashHistory(history)); } throw new FaultException("Срок рабочей сессии истек, преезапустите программу"); }
public byte[] GetReflashFile(int reflashId, int userId, string token) { ITokenValidator validator = new DatabaseTokenValidator(); if (validator.IsValid(token)) { return(new VtecTeamDBManager().GetReflashFile(reflashId, userId)); } throw new FaultException("Срок рабочей сессии истек, преезапустите программу"); }
public bool SendRequest(ReflashRequest reflashRequest, string token) { ITokenValidator validator = new DatabaseTokenValidator(); if (validator.IsValid(token)) { return(new VtecTeamDBManager().SaveRequest(reflashRequest)); } throw new FaultException("Срок рабочей сессии истек, преезапустите программу"); }
public List <News> GetNews(string token) { ITokenValidator validator = new DatabaseTokenValidator(); if (validator.IsValid(token)) { return(new VtecTeamDBManager().GetNews()); } throw new FaultException("Срок рабочей сессии истек, преезапустите программу"); }
public List <ReflashInformation> GetInformationListOfReflashBinaries(string ecuBinary, string token) { ITokenValidator validator = new DatabaseTokenValidator(); if (validator.IsValid(token)) { return(new VtecTeamDBManager().GetInformationListOfReflashBinaries(ecuBinary)); } throw new FaultException("Срок рабочей сессии истек, преезапустите программу"); }
public bool UpdateUserPersonalData(User user, string token) { ITokenValidator validator = new DatabaseTokenValidator(); if (validator.IsValid(token)) { return(new VtecTeamDBManager().UpdateUserPersonalData(user)); } throw new FaultException("Срок рабочей сессии истек, преезапустите программу"); }
public SaveEntityResult SendComment(Comment comment, string token) { ITokenValidator validator = new DatabaseTokenValidator(); if (validator.IsValid(token)) { return(new VtecTeamDBManager().SendComment(comment)); } throw new FaultException("Срок рабочей сессии истек, преезапустите программу"); }
public bool TestToken(string token) { //var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; //var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); return(validator.IsValid(token) ? true : false); } }
private static void ValidateToken(string token) { using (var dbContext = new BasicTokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (!validator.IsValid(token)) { throw new WebFaultException(HttpStatusCode.Forbidden); } // Add User ids to the header so the service has them if needed WebOperationContext.Current?.IncomingRequest.Headers.Add("User", validator.Token.User.Username); WebOperationContext.Current?.IncomingRequest.Headers.Add("UserId", validator.Token.User.Id.ToString()); } }
public List <string> GetItemsStoring() { var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { using (IDbConnection connection = new SqlConnection(GlobalConfig.CnnString("GyrodataTracker"))) { return(connection.Query <string>("spGetItemsStoring", commandType: CommandType.StoredProcedure).ToList()); } } return(null); } }
// Add New Job public int AddNewJob(JobModel model) { var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("GyrodataTracker"))) { var p = new DynamicParameters(); p.Add("@JobNumber", model.JobNumber); p.Add("@Client", model.ClientName); p.Add("@GDPAsset", model.GDP); p.Add("@ModemAsset", model.Modem); p.Add("@ModemVersion", model.ModemVersion); p.Add("@BullplugAsset", model.Bullplug); p.Add("@CirculationHours", model.CirculationHours); p.Add("@Battery", model.Battery); p.Add("@MaxTemp", model.MaxTemp); p.Add("@EngineerOne", model.EngineerOne); p.Add("@EngineerTwo", model.EngineerTwo); p.Add("@EngineerOneArrived", model.eng_one_arrived); p.Add("@EngineerTwoArrived", model.eng_two_arrived); p.Add("@EngineerOneLeft", model.eng_one_left); p.Add("@EngineerTwoLeft", model.eng_two_left); p.Add("@Container", model.Container); p.Add("@ContainerArrived", model.ContainerArrived); p.Add("@ContainerLeft", model.ContainerLeft); p.Add("@Rig", model.Rig); p.Add("@Issues", model.Issues); p.Add("@Comment", model.Comment); p.Add("@Id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); connection.Execute("dbo.spJob_Insert", p, commandType: CommandType.StoredProcedure); model.Id = p.Get <int>("@Id"); } } } return(model.Id); }
public void EditJob(string Id, JobModel model) { int id = int.Parse(Id); var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("GyrodataTracker"))) { var p = new DynamicParameters(); p.Add("@Id", id); p.Add("@JobNumber", model.JobNumber); p.Add("@Client", model.ClientName); p.Add("@gdp", model.GDP); p.Add("@modem", model.Modem); p.Add("@ModemVersion", model.ModemVersion); p.Add("@bbp", model.Bullplug); p.Add("@newJobCirculation", model.CirculationHours); p.Add("@Battery", model.Battery); p.Add("@MaxTemp", model.MaxTemp); p.Add("@EngineerOne", model.EngineerOne); p.Add("@EngineerTwo", model.EngineerTwo); p.Add("@EngineerOneArrived", model.eng_one_arrived); p.Add("@EngineerTwoArrived", model.eng_two_arrived); p.Add("@EngineerOneLeft", model.eng_one_left); p.Add("@EngineerTwoLeft", model.eng_two_left); p.Add("@Container", model.Container); p.Add("@ContainerArrived", model.ContainerArrived); p.Add("@ContainerLeft", model.ContainerLeft); p.Add("@Rig", model.Rig); p.Add("@Issues", model.Issues); p.Add("@Comment", model.Comment); connection.Execute("dbo.spUpdate_Job", p, commandType: CommandType.StoredProcedure); } } } }
private static void ValidateToken(string token) { System.Diagnostics.Debug.WriteLine("Validate token cu valoarea : " + token); if (token != "signup") //daca token include signup fac exceptie la regula validarii pentru noii utilizatori { using (var dbContext = new UserTokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (!validator.IsValid(token)) { throw new WebFaultException(HttpStatusCode.Forbidden); } // Add User ids to the header so the service has them if needed WebOperationContext.Current.IncomingRequest.Headers.Add("User", validator.Token.User.Username); WebOperationContext.Current.IncomingRequest.Headers.Add("UserId", validator.Token.User.Id.ToString()); WebOperationContext.Current.OutgoingResponse.Headers.Add("User", validator.Token.User.Username.ToString()); WebOperationContext.Current.OutgoingResponse.Headers.Add("UserId", validator.Token.User.Id.ToString()); WebOperationContext.Current.OutgoingResponse.Headers.Add("Role", validator.Token.User.Role.ToString()); } } }
public List <List <string> > GetAllDataForJobCreate() { List <List <string> > initialJobData = new List <List <string> >(); var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { initialJobData.Add(GetClientsData()); initialJobData.Add(GetGdpData()); initialJobData.Add(GetModemData()); initialJobData.Add(GetBbpData()); initialJobData.Add(GetEngineerData()); initialJobData.Add(GetBatteriesData()); } } return(initialJobData); }
//LARAVEL public List <ItemModel> GetSelectedItem_lrl(int id) { var headers = OperationContext.Current.IncomingMessageProperties["httpRequest"]; var token = ((HttpRequestMessageProperty)headers).Headers["Token"]; using (var dbContext = new TokenDbContext()) { ITokenValidator validator = new DatabaseTokenValidator(dbContext); if (validator.IsValid(token) == true) { using (IDbConnection connection = new SqlConnection(GlobalConfig.CnnString("GyrodataTracker"))) { var p = new DynamicParameters(); p.Add("@Id", id); return(connection.Query <ItemModel>("spGetSelectedItemData_LRL", p, commandType: CommandType.StoredProcedure).ToList()); } } return(null); } }