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 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 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 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);
}
}
// 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 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);
}
}
}
}
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 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 List <ReflashInformation> GetInformationListOfReflashBinaries(string ecuBinary, string token)
{
ITokenValidator validator = new DatabaseTokenValidator();
if (validator.IsValid(token))
{
return(new VtecTeamDBManager().GetInformationListOfReflashBinaries(ecuBinary));
}
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 List <News> GetNews(string token)
{
ITokenValidator validator = new DatabaseTokenValidator();
if (validator.IsValid(token))
{
return(new VtecTeamDBManager().GetNews());
}
throw new FaultException("Срок рабочей сессии истек, преезапустите программу");
}
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 bool SendRequest(ReflashRequest reflashRequest, string token)
{
ITokenValidator validator = new DatabaseTokenValidator();
if (validator.IsValid(token))
{
return(new VtecTeamDBManager().SaveRequest(reflashRequest));
}
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 List <ReflashRequest> GetReflashRequests(int userId, string token)
{
ITokenValidator validator = new DatabaseTokenValidator();
if (validator.IsValid(token))
{
return(new VtecTeamDBManager().GetReflashRequests(userId));
}
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 UpdateUserPersonalData(User user, string token)
{
ITokenValidator validator = new DatabaseTokenValidator();
if (validator.IsValid(token))
{
return(new VtecTeamDBManager().UpdateUserPersonalData(user));
}
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 void IsExpired29Minutes59Second()
{
// Arrange
var token = new Token {
CreateDate = DateTime.Now.AddSeconds(-1799)
};
var validator = new DatabaseTokenValidator(null);
// Act
var actual = validator.IsExpired(token);
// Assert
Assert.IsFalse(actual);
}
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());
}
}
}
//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);
}
}
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);
}
