public async Task <IHttpActionResult> GetUsersCase()
{
var messages = new Messages();
ObjectDto <List <UserCasesViewModel> > result = new ObjectDto <List <UserCasesViewModel> >();
var startdate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time")).AddDays(-7);
var enddate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"));
using (var con = new ApplicationDbContext())
{
var casesDto = await(from uc in con.UserCases
join pu in con.PUserProfile on uc.UserId equals pu.UserId
where uc.CreatedDate >= startdate && uc.CreatedDate <= enddate
select new { pu, uc }).ToListAsync();
var cases = casesDto.Select(p => new UserCasesViewModel(p.uc, p.pu)).OrderByDescending(x => x.Date).ToList();
if (cases == null || cases.Count() == 0)
{
messages.Message = "No record found";
result.messages.Add(messages);
}
else
{
result.Object = cases;
result.valid = true;
}
}
return(Ok(result));
}
public async Task <IHttpActionResult> UpdateMarkup(MarkupDto markup)
{
var messages = new Messages();
ObjectDto <MarkupDto> result = new ObjectDto <MarkupDto>();
markup.LastModifiedDate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"));
db.Entry(markup).State = EntityState.Modified;
try
{
if ((await db.SaveChangesAsync()) > 0)
{
result.Object = markup;
result.valid = true;
messages.Message = "Markup updated successfully";
messages.Type = Toaster.SUCCESS.ToString();
result.messages.Add(messages);
}
else
{
messages.Message = "Internal Server Error";
result.messages.Add(messages);
}
}
catch (Exception e)
{
messages.Message = e.Message;
result.messages.Add(messages);
}
return(Ok(result));
}
public async Task <IHttpActionResult> AddMarkup(MarkupDto model)
{
var messages = new Messages();
ObjectDto <MarkupDto> result = new ObjectDto <MarkupDto>();
try
{
var userId = User.Identity.GetUserId();
model.UserId = userId;
model.CreatedDate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"));
model.LastModifiedDate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"));
db.Markups.Add(model);
if ((await db.SaveChangesAsync()) > 0)
{
result.Object = model;
result.valid = true;
messages.Message = "Markup added successfully";
messages.Type = Toaster.SUCCESS.ToString();
result.messages.Add(messages);
}
else
{
messages.Message = "Internal Server Error";
result.messages.Add(messages);
}
}
catch (Exception e)
{
messages.Message = e.Message;
result.messages.Add(messages);
}
return(Ok(result));
}
public async Task <IHttpActionResult> GetMyCases()
{
var messages = new Messages();
ObjectDto <List <UserCasesViewModel> > result = new ObjectDto <List <UserCasesViewModel> >();
var UId = User.Identity.GetUserId();
using (var con = new ApplicationDbContext())
{
var casesDto = await con.UserCases.Where(x => x.UserId == UId).ToListAsync();
if (casesDto == null || casesDto.Count() == 0)
{
messages.Message = "No record found";
result.messages.Add(messages);
}
else
{
var passbook = casesDto.Select(p => new UserCasesViewModel(p)).OrderByDescending(x => x.Date).ToList();
result.Object = passbook;
result.valid = true;
}
}
return(Ok(result));
}
public static void SubscribeObjectChange(int projectId, int sceneId)
{
LogManager.GetCurrentClassLogger()
.Info($"subscribe object change to location {sceneId}, project {projectId}");
IModel channel = GetChanel();
string queueName = ExchangeDeclareIfNotExist(ExchangeNames.SceneObjectChanged, "topic", true);
string key = $"project.{projectId}.scene.{sceneId}";
channel.QueueBind(queueName,
ExchangeNames.SceneObjectChanged,
key);
EventingBasicConsumer consumer = new EventingBasicConsumer(channel);
consumer.Received += (model, ea) =>
{
LogManager.GetCurrentClassLogger().Info("Object was changed");
var body = ea.Body;
string jsonData = Encoding.UTF8.GetString(body);
ObjectDto objectDto = jsonData.JsonDeserialize <ObjectDto>();
ProjectDataListener.Instance.UpdateObject(objectDto);
};
string tag = channel.BasicConsume(queueName, true, consumer);
if (!SubscribeObjectsChangesTags.ContainsKey(sceneId))
{
SubscribeObjectsChangesTags.Add(sceneId, string.Empty);
}
SubscribeObjectsChangesTags[sceneId] = tag;
}
public async Task <IHttpActionResult> GetParentBanks()
{
var messages = new Messages();
ObjectDto <List <PBanksDto> > result = new ObjectDto <List <PBanksDto> >();
var userId = User.Identity.GetUserId();
using (var con = new ApplicationDbContext())
{
var userObj = await con.PUserProfile.FindAsync(userId);
var parentUserId = con.PUserProfile.FirstOrDefault(x => x.Id == userObj.ParentId).UserId;
var banks = con.Banks.Where(x => x.UserId == parentUserId).ToList();
if (banks == null || banks.Count() == 0)
{
messages.Message = "No record found";
result.messages.Add(messages);
}
else
{
result.valid = true;
result.Object = banks;
}
return(Ok(result));
}
}
private static void CreateSpawnEntity(ObjectDto o, int locationId, int?parentId = null)
{
bool embedded = false;
PrefabObject prefabObject = WorldData.WorldStructure.Objects.GetById(o.ObjectId);
if (prefabObject != null)
{
embedded = prefabObject.Embedded;
}
SpawnInitParams param = new SpawnInitParams
{
IdLocation = locationId,
IdInstance = o.InstanceId,
IdObject = o.ObjectId,
IdServer = 0,
Name = o.InstanceId.ToString(),
ParentId = parentId
};
if (o.Data != null)
{
param.Transforms = o.Data.Transform;
}
Spawner.Instance.SpawnAsset(param);
}
public async Task <IHttpActionResult> GetBalanceRequests()
{
var messages = new Messages();
ObjectDto <List <PBalanceRequestDto> > result = new ObjectDto <List <PBalanceRequestDto> >();
try
{
using (var db = new ApplicationDbContext())
{
var userId = User.Identity.GetUserId();
var requests = await db.BalanceRequests.Where(x => x.UserId == userId).ToListAsync();
if (requests == null || requests.Count() == 0)
{
messages.Message = "No record found";
result.messages.Add(messages);
}
else
{
result.valid = true;
result.Object = requests.OrderByDescending(x => x.LastModifiedDate).ToList();
}
}
}
catch (Exception e)
{
messages.Message = e.Message + " " + e.InnerException;
result.messages.Add(messages);
}
return(Ok(result));
}
public async Task <IHttpActionResult> GetUsers()
{
var messages = new Messages();
ObjectDto <List <PUserProfileDto> > data = new ObjectDto <List <PUserProfileDto> >();
try
{
var UId = User.Identity.GetUserId();
using (var con = new ApplicationDbContext())
{
var userObj = await con.PUserProfile.FindAsync(UId);
var children = await con.PUserProfile.Where(x => x.ParentId == userObj.Id).ToListAsync();
if (children != null && children.Count() > 0)
{
data.Object = children;
data.valid = true;
}
else
{
messages.Message = "No record found";
data.messages.Add(messages);
}
}
}
catch (Exception e)
{
messages.Message = e.Message + " " + e.InnerException;
data.messages.Add(messages);
}
return(Ok(data));
}
public async Task <IHttpActionResult> GetAllUsers(string role)
{
var messages = new Messages();
ObjectDto <List <UsersReport> > data = new ObjectDto <List <UsersReport> >();
try
{
using (var con = new ApplicationDbContext())
{
var roles = con.Roles.FirstOrDefault(x => x.Name.ToUpper() == role.ToUpper());
var users = roles.Users.Select(x => x.UserId);
var userDto = await con.PUserProfile.Where(p => users.Any(x => x == p.UserId))
.ToListAsync();
if (userDto != null && userDto.Count() > 0)
{
var userList = userDto.Select(k => new UsersReport(k, con.PUserProfile.FirstOrDefault(x => x.Id == k.ParentId).Agency)).OrderBy(f => f.Name).ToList();
data.Object = userList;
data.valid = true;
}
else
{
messages.Message = "No record found";
data.messages.Add(messages);
}
}
}
catch (Exception e)
{
messages.Message = e.Message + " " + e.InnerException;
data.messages.Add(messages);
}
return(Ok(data));
}
public async Task <IHttpActionResult> SetPassword(SetPasswordBindingModel model)
{
var messages = new Messages();
ObjectDto <object> data = new ObjectDto <object>();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
IdentityResult result = await UserManager.AddPasswordAsync(User.Identity.GetUserId(), model.NewPassword);
if (!result.Succeeded)
{
foreach (string error in result.Errors)
{
messages.Message = "*" + error;
}
data.messages.Add(messages);
}
else
{
data.valid = true;
}
return(Ok(data));
}
public void UpdateObject(ObjectDto objectDto)
{
GameEntity entityObject = GameStateData.GetEntity(objectDto.InstanceId);
entityObject.name.Value = objectDto.Name;
OnUpdateObject?.Invoke(entityObject, objectDto);
}
public async Task <IHttpActionResult> GetRegistrationPlans()
{
ObjectDto <List <PUserRegistrationPlansDto> > result = new ObjectDto <List <PUserRegistrationPlansDto> >();
try
{
using (var context = new ApplicationDbContext())
{
result.Object = await context.PUserRegistrationPlans.ToListAsync();
if (result.Object == null || result.Object.Count == 0)
{
var messages = new Messages();
messages.Message = "No Plan Found";
result.messages.Add(messages);
}
else
{
result.valid = true;
}
}
}
catch (Exception e)
{
var messages = new Messages();
messages.Message = e.Message;
result.messages.Add(messages);
}
return(Ok(result));
}
public override ObjectDto OnPrincipalObjectUpdated(ObjectDto updatedPrincipalObj, string optionalArg)
{
// Do whatever you need to do here to manage this change.
// Do NOT attempt to save this object, else it will result in undefined behaviour; just manage
// the change in the object and that's it. The library will ensure that the object is auto-saved.
// Avoid doing any disk/network io here.
if (updatedPrincipalObj is ProductDto)
{
ProductDto productDto = updatedPrincipalObj as ProductDto;
ProductCombo.Remove(productDto, quietly: true);
ProductCombo.Add(productDto, quietly: true);
DisplayPrice = SalePrice = 0;
foreach (var product in ProductCombo)
{
decimal productVal = product.BaseCost + product.BaseCost * product.TaxComponent / 100;
decimal markedup = productVal + (productVal / 100 * 10); // Add a 10% markup
decimal discounted = markedup - (productVal / 100 * 5); // subtract a 5% discount
DisplayPrice += markedup;
SalePrice += discounted;
}
}
return(this);
}
public ObjectDto Post([FromBody] ObjectDto dto)
{
var newObject = dto.GetEntity(repository);
repository.Save(newObject);
return(new ObjectDto(newObject));
}
public override ObjectDto OnPrincipalObjectUpdated(ObjectDto updatedPrincipalObj, string optionalArg)
{
// Do whatever you need to do here to manage this change.
// Do NOT attempt to save this object, else it will result in undefined behaviour; just manage
// the change in the object and that's it. The library will ensure that the object is auto-saved.
// Avoid doing any disk/network io here.
return(this);
}
public IActionResult Upload2(IFormFile file, [FromForm] ObjectDto dto)
{
using (var stream = new MemoryStream())
{
file.CopyToAsync(stream);
var base64String = Convert.ToBase64String(stream.ToArray());
}
return(Ok("Arquivo recebido"));
}
public async Task <IHttpActionResult> UpdateProfile(PUserProfileDto model)
{
var messages = new Messages();
ObjectDto <string> result = new ObjectDto <string>();
if (String.IsNullOrEmpty(model.PanCard) || String.IsNullOrEmpty(model.LastName) || String.IsNullOrEmpty(model.FirstName) ||
String.IsNullOrEmpty(model.Country) || String.IsNullOrEmpty(model.State) || String.IsNullOrEmpty(model.City))
{
messages.Message = "*All fields are required";
result.messages.Add(messages);
}
else
{
try
{
model.LastModifiedDate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"));
using (var context = new ApplicationDbContext())
{
var user = await context.PUserProfile.FindAsync(model.UserId);
user.BirthDate = model.BirthDate;
user.City = model.City;
user.Country = model.Country;
user.FirstName = model.FirstName;
user.Gender = model.Gender;
user.LastName = model.LastName;
user.PanCard = model.PanCard;
user.State = model.State;
user.GST = model.GST;
context.Entry(user).State = EntityState.Modified;
int i = await context.SaveChangesAsync();
if (i == 0)
{
messages.Message = "Internal Server Error";
result.messages.Add(messages);
}
else
{
messages.Message = "Your profile has updated successfully";
messages.Type = Toaster.SUCCESS.ToString();
result.messages.Add(messages);
result.valid = true;
}
}
}
catch (Exception e)
{
messages.Message = e.Message + " " + e.GetBaseException();
result.messages.Add(messages);
}
}
return(Ok(result));
}
private async Task <ObjectDto <dynamic> > GetURL(string json, string methodName, string requestType)
{
ObjectDto <dynamic> result = new ObjectDto <dynamic>();
try
{
var payUrl = System.Configuration.ConfigurationManager.AppSettings.Get("PaymentUrl");
var key = System.Configuration.ConfigurationManager.AppSettings.Get("X-Api-Key");
var token = System.Configuration.ConfigurationManager.AppSettings.Get("X-Auth-Token");
string url = payUrl + methodName + "/";
Uri uri = new Uri(url);
WebRequest webRequest = WebRequest.Create(uri);
webRequest.Headers.Add("X-Api-Key", key);
webRequest.Headers.Add("X-Auth-Token", token);
webRequest.ContentType = "application/json";
webRequest.Method = requestType;
if (!String.IsNullOrEmpty(json))
{
byte[] postBytes = Encoding.UTF8.GetBytes(json);
Stream requestStream = await webRequest.GetRequestStreamAsync();
requestStream.Write(postBytes, 0, postBytes.Length);
requestStream.Close();
}
using (WebResponse response = await webRequest.GetResponseAsync())
{
using (StreamReader rd = new StreamReader(response.GetResponseStream()))
{
var soapResult = rd.ReadToEnd();
dynamic data = JsonConvert.DeserializeObject(soapResult);
if (data["success"] == false)
{
var messages = new Messages();
result.messages.Add(messages);
}
else
{
result.valid = true;
result.Object = data;
}
}
}
}
catch (Exception e)
{
var messages = new Messages();
messages.Message = e.Message;
result.messages.Add(messages);
}
return(result);
}
public async Task <IHttpActionResult> ChangePassword(ChangePasswordBindingModel model)
{
var messages = new Messages();
ObjectDto <object> data = new ObjectDto <object>();
if (!ModelState.IsValid)
{
foreach (var modelError in ModelState)
{
if (modelError.Value.Errors.Count > 0)
{
foreach (var errors in modelError.Value.Errors)
{
messages.Message = errors.ErrorMessage;
data.messages.Add(messages);
}
}
}
}
else
{
try
{
IdentityResult result = await UserManager.ChangePasswordAsync(User.Identity.GetUserId(), model.OldPassword,
model.NewPassword);
if (!result.Succeeded)
{
foreach (var error in result.Errors)
{
messages.Message = "*" + error;
}
data.messages.Add(messages);
}
else
{
data.valid = true;
messages.Type = "SUCCESS";
messages.Message = "Your password has been reset";
data.messages.Add(messages);
}
}
catch (Exception e)
{
messages.Message = e.Message;
data.messages.Add(messages);
}
}
return(Ok(data));
}
public IActionResult GetObject(Guid id)
{
Object objectFromRepo = _objectRepository.GetById(id);
IEnumerable <User> usersFromRepo = objectFromRepo.ObjectUsers.Select(od => od.User);
IEnumerable <UserDto> users = Mapper.Map <IEnumerable <User>, IEnumerable <UserDto> >(usersFromRepo);
ObjectDto obj = Mapper.Map <ObjectDto>(objectFromRepo);
obj.Departments = objectFromRepo.ObjectDepartments.Select(od => od.Department);
obj.Users = users;
obj.Path = GetPathToObject(id);
return(Ok(obj));
}
public async Task <IHttpActionResult> DeleteBalanceRequest(int id)
{
var messages = new Messages();
ObjectDto <string> result = new ObjectDto <string>();
using (var db = new ApplicationDbContext())
{
var balReq = await db.BalanceRequests.FindAsync(id);
if (balReq == null)
{
messages.Message = "No record found";
result.messages.Add(messages);
}
else
{
if (balReq.Status == (int)BalanceRequestFlag.Inprogress)
{
try
{
db.BalanceRequests.Remove(balReq);
if ((await db.SaveChangesAsync()) > 0)
{
result.valid = true;
messages.Message = "Your request for balance has been deleted successfully";
messages.Type = Toaster.SUCCESS.ToString();
result.messages.Add(messages);
}
else
{
messages.Message = "Internal Server Error";
result.messages.Add(messages);
}
}
catch (Exception e)
{
messages.Message = e.Message;
result.messages.Add(messages);
}
}
else
{
messages.Message = "Unable to delete the processed balance request";
result.messages.Add(messages);
}
}
}
return(Ok(result));
}
public int AddObject(ObjectDto object1)
{
var result = _connection
.QuerySingle <int>("Object_Add",
new
{
name = object1.Name,
material = object1.Material,
surface = object1.Surface,
specifications = object1.Specifications
},
commandType: System.Data.CommandType.StoredProcedure);
return(result);
}
public ObjectDto Put(int id, [FromBody] ObjectDto dto)
{
var entity = repository.Get <MaintenanceObject>(id);
var context = UserPrincipal.Current;
var user = query.FindUserByLogin(context.SamAccountName);
if (entity.IsUserHavePermission(user))
{
dto.Merge(entity, repository);
repository.Save(entity);
return(new ObjectDto(entity));
}
throw new TypeAccessException("У вас нет доступа для редактирования данных оборудования");
}
public override ObjectDto OnPrincipalObjectUpdated(ObjectDto updatedPrincipalObj, string optionalArg)
{
// Do whatever you need to do here to manage this change.
// Do NOT attempt to save this object, else it will result in undefined behaviour; just manage
// the change in the object and that's it. The library will ensure that the object is auto-saved.
// Avoid doing any disk/network io here.
if (updatedPrincipalObj is CategoryDto)
{
CategoryDto categoryDto = updatedPrincipalObj as CategoryDto;
TaxComponent = BaseCost * categoryDto.TaxRate / 100;
}
return(this);
}
public override ObjectDto OnPrincipalObjectUpdated(ObjectDto updatedPrincipalObj, string optionalArg)
{
// Do whatever you need to do here to manage this change.
// Do NOT attempt to save this object, else it will result in undefined behaviour; just manage
// the change in the object and that's it. The library will ensure that the object is auto-saved.
// Avoid doing any disk/network io here.
if (updatedPrincipalObj is CatalogEntryDto)
{
CatalogEntryDto catalogEntryDto = updatedPrincipalObj as CatalogEntryDto;
CatalogItems.Remove(catalogEntryDto, quietly: true);
CatalogItems.Add(catalogEntryDto, quietly: true);
}
return(this);
}
private async Task <ObjectDto <List <BalanceRequestViewModel> > > GetBalanceRequestsForAdmin()
{
var messages = new Messages();
ObjectDto <List <BalanceRequestViewModel> > result = new ObjectDto <List <BalanceRequestViewModel> >();
try
{
using (var db = new ApplicationDbContext())
{
var userId = User.Identity.GetUserId();
var pUserId = await db.PUserProfile.FindAsync(userId);
var childUsers = await db.PUserProfile.ToListAsync();
var MDs = childUsers.Where(x => x.ParentId == pUserId.Id).ToList();
var ids = MDs.Select(k => k.UserId).ToList();
var PbankList = await db.Banks.Where(x => x.UserId == userId).ToListAsync();
var childRequestsDto = await db.BalanceRequests.Where(x => ids.Contains(x.UserId) ||
x.Purpose == (int)BalanceRequestPurpose.From_Rail_To_Agent_Account ||
x.Purpose == (int)BalanceRequestPurpose.From_Agent_Account_To_Rail).ToListAsync();
var childRequests = childRequestsDto.Select(x => new BalanceRequestViewModel(x,
childUsers.FirstOrDefault(s => s.UserId == x.UserId)?.Agency,
PbankList.FirstOrDefault(s => s.Id == x.PBankId)?.Name));
if (childRequests == null || childRequests.Count() == 0)
{
messages.Message = "No record found";
result.messages.Add(messages);
}
else
{
result.valid = true;
result.Object = childRequests.OrderByDescending(x => x.CreatedDate).ToList();
}
}
}
catch (Exception e)
{
messages.Message = e.Message + " " + e.GetBaseException();
result.messages.Add(messages);
}
return(result);
}
public async Task <IHttpActionResult> GetFlightOperators()
{
var messages = new Messages();
ObjectDto <List <OperatorsDto> > result = new ObjectDto <List <OperatorsDto> >();
var fOperators = await db.Operators.Where(x => x.ServiceType == (int)ServiceType.Flight_Domestic).ToListAsync();
if (fOperators == null || fOperators.Count() == 0)
{
messages.Message = "No record found";
result.messages.Add(messages);
}
else
{
result.valid = true;
result.Object = fOperators;
}
return(Ok(result));
}
public async Task <IHttpActionResult> SubmitCase(UserCasesDto model)
{
var messages = new Messages();
ObjectDto <string> result = new ObjectDto <string>();
model.UserId = User.Identity.GetUserId();
model.Status = (int)UserCasesStatus.Inprogress;
model.CreatedDate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"));
model.LastModifiedDate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"));
//var UEmail = User.Identity.GetUserName();
model.Remarks = "Partner: " + model.Remarks;
using (var con = new ApplicationDbContext())
{
var isValidCase = await con.PFlights.FindAsync(model.TransactionId);
if (isValidCase != null && isValidCase.UserId == model.UserId)
{
con.UserCases.Add(model);
if ((await con.SaveChangesAsync()) > 0)
{
messages.Message = "Thank you for contacting us.Our support team will contact you shortly.";
messages.Type = Toaster.SUCCESS.ToString();
result.messages.Add(messages);
result.valid = true;
}
else
{
messages.Message = "Unable to submit your case.Kindly try again after sometime.";
result.messages.Add(messages);
result.valid = false;
}
}
else
{
messages.Message = "Unable to create a case of invalid trasaction.";
result.messages.Add(messages);
result.valid = false;
}
}
return(Ok(result));
}
public async Task <IHttpActionResult> GetMarkups()
{
var messages = new Messages();
ObjectDto <List <MarkupDto> > result = new ObjectDto <List <MarkupDto> >();
var userId = User.Identity.GetUserId();
var markups = await db.Markups.Where(x => x.UserId == userId).ToListAsync();
if (markups == null || markups.Count() == 0)
{
messages.Message = "No record found";
result.messages.Add(messages);
}
else
{
result.valid = true;
result.Object = markups;
}
return(Ok(result));
}
