public async Task <Response <bool> > DeleteUser(Guid?IdUser, Guid?IdOwner, Guid?IdAdmin, string Name)
{
Response <bool> response = new Response <bool>();
try
{
using (var dc = new RentAppEntities())
{
var queryFilter = dc.spDelUser(IdUser);
if (queryFilter == -1)
{
response.Count = 1;
response.Message = null;
response.Result = true;
//0=usuario, 1= propietario, 2=administrador
}
else
{
response.Count = 0;
response.Message = "No se puede eliminar el usuario";
response.Result = false;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = false;
return(response);
}
}
public async Task <Response <bool> > InsertUser(UserInsVM user)
{
Response <bool> response = new Response <bool>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spInsUser(user.IdOwner, user.IdAdmin, user.Name, user.Address, user.Phone, user.User, user.Password, user.Icon, user.IconString);
if (query == -1)
{
response.Count = 1;
response.Message = null;
response.Result = true;
}
else
{
response.Count = 0;
response.Message = "No se puedo insertar el usuario";
response.Result = false;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = false;
return(response);
}
}
public async Task <Response <bool> > UpdateUser(UserUpdVM user)
{
Response <bool> response = new Response <bool>();
try
{
using (var dc = new RentAppEntities())
{
var queryFilter = dc.spUpdUser(user.UserId, user.IdOwner, user.IdAdmin, user.Name, user.Address, user.Phone, user.User, user.Password, user.Icon, user.IconString, user.Status);
if (queryFilter == -1)
{
response.Count = 1;
response.Message = null;
response.Result = true;
}
else
{
response.Count = 0;
response.Message = "No se pudo actualizar";
response.Result = false;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = false;
return(response);
}
}
public async Task <Response <bool> > UpdateDocuments(DocumentsUpdVM doc)
{
Response <bool> response = new Response <bool>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spUpdDocument(doc.IdDocument, doc.IdOwner, doc.IdAdmin, doc.Name, doc.FileDocument, doc.StringFile, ".pdf");
if (query == -1)
{
response.Count = 1;
response.Message = null;
response.Result = true;
}
else
{
response.Count = 0;
response.Message = "No se pudo actualizar el documento";
response.Result = false;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = false;
return(response);
}
}
public async Task <Response <bool> > UpdateOwner(OwnerUpdVM o)
{
Response <bool> response = new Response <bool>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spUpdOwner(o.IdOwner, o.Name, o.Address, o.Phone, o.User, o.Icon, o.IconString, o.Password, o.Status);
if (query == -1)
{
response.Count = 1;
response.Message = null;
response.Result = true;
}
else
{
response.Count = 0;
response.Message = "No se pudo actualizar el propietario";
response.Result = false;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = false;
return(response);
}
}
public async Task <Response <bool> > DeleteOwner(Guid?idOwner, Guid?idAdmin, string NameOwner)
{
Response <bool> response = new Response <bool>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spDelOwner(idOwner);
if (query == -1)
{
response.Count = 1;
response.Message = null;
response.Result = true;
}
else
{
response.Count = 0;
response.Message = "No se pudo eliminar el propietario";
response.Result = false;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = false;
return(response);
}
}
public async Task <Response <bool> > DeleteDocuments(Guid?IdDocuments)
{
Response <bool> response = new Response <bool>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spDelDocument(IdDocuments);
if (query == -1)
{
response.Count = 1;
response.Message = null;
response.Result = true;
}
else
{
response.Count = 0;
response.Message = "No se pudo eliminar el documento";
response.Result = false;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = false;
return(response);
}
}
public async Task <Response <List <UserVM> > > GetUser(Guid?idOwner, bool?status)
{
Response <List <UserVM> > response = new Response <List <UserVM> >();
List <UserVM> list = new List <UserVM>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spSelUser(idOwner).ToList();
if (query.Count > 0)
{
if (status != null)
{
var queryFilter = query.Where(c => c.StatusUser == status).ToList();
query = queryFilter;
}
foreach (var item in query)
{
var usr = new UserVM();
usr.Address = item.AddressUser;
usr.DateCreated = item.DateCreatedUser;
usr.DateModified = item.DateModifiedUser;
usr.IconString = item.IconStringUser;
usr.Icon = item.IconUser;
usr.IdAdmin = item.IdAdmin;
usr.IdOwner = item.IdOwner;
usr.Name = item.NameUser;
usr.Password = item.PasswordUser;
usr.Phone = item.PhoneUser;
usr.Status = item.StatusUser;
usr.UserId = item.UserId;
usr.User = item.UserUser;
list.Add(usr);
}
response.Count = list.Count;
response.Message = null;
response.Result = list;
}
else
{
response.Count = 0;
response.Message = "No hay datos";
response.Result = null;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = null;
return(response);
}
}
public async Task <Response <List <OwnerVM> > > SelectOwnerAll(bool?status)
{
Response <List <OwnerVM> > response = new Response <List <OwnerVM> >();
List <OwnerVM> list = new List <OwnerVM>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spSelOwner().ToList();
if (status != null)
{
var queryFilter = dc.spSelOwner().Where(c => c.StatusOwner == true).ToList();
query = queryFilter;
}
if (query.Count > 0)
{
foreach (var item in query)
{
var o = new OwnerVM();
o.Address = item.AddressOwner;
o.DateCreated = item.DateCreatedOwner;
o.DateModified = item.DateModifiedOwner;
o.Icon = item.IconOwner;
o.IconString = item.IconStringOwner;
o.IdAdmin = item.IdAdmin;
o.IdOwner = item.IdOwner;
o.Name = item.NameOwner;
o.Password = item.PasswordOwner;
o.Phone = item.PhoneOwner;
o.Status = item.StatusOwner;
o.User = item.UserOwner;
list.Add(o);
}
response.Count = list.Count;
response.Message = null;
response.Result = list;
}
else
{
response.Count = 0;
response.Message = "No hay datos";
response.Result = null;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = null;
return(response);
}
}
public async Task <Response <List <DocumentsGetVM> > > SelectDocuments(Guid?IdOwner)
{
Response <List <DocumentsGetVM> > response = new Response <List <DocumentsGetVM> >();
List <DocumentsGetVM> list = new List <DocumentsGetVM>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spSelDocuments(null).ToList();
if (IdOwner != null || IdOwner != Guid.Empty)
{
var queryFilter = query.Where(c => c.IdOwner == IdOwner).ToList();
query = queryFilter;
//todos los usuarios
}
if (query.Count > 0)
{
foreach (var item in query)
{
var d = new DocumentsGetVM();
d.DateCreated = item.DateCreatedDocument;
d.DateModified = item.DateModifiedDocument;
d.Extensions = item.Extensions;
d.File = item.FileDocument;
d.IdAdmin = item.IdAdmin;
d.IdDocument = item.IdDocuments;
d.IdOwner = item.IdOwner;
d.Name = item.NameDocument;
d.Status = item.StatusDocument;
d.StringFile = item.StringFile;
list.Add(d);
}
response.Count = list.Count;
response.Message = null;
response.Result = list;
}
else
{
response.Count = 0;
response.Message = "No hay documentos";
response.Result = null;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = null;
return(response);
}
}
public static async Task InsertNotification(Guid?Id, string playerId, string pushToken, int typeUser)
{
Response <bool> response = new Response <bool>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spInsNotifications(Id, playerId, pushToken, typeUser);
}
}
catch (Exception ex)
{
}
}
public async Task <Response <UserVM> > DoLogin(string user, string password, string PlayerId, string PushToken)
{
Response <UserVM> response = new Response <UserVM>();
try
{
using (var dc = new RentAppEntities())
{
var queryFilter = dc.spSelUserDoLogin(user, password).ToList();
var query = queryFilter.Where(c => c.StatusUser == true).FirstOrDefault();
if (query != null)
{
var usr = new UserVM();
usr.Address = query.AddressUser;
usr.DateCreated = query.DateCreatedUser;
usr.DateModified = query.DateModifiedUser;
usr.IconString = query.IconStringUser;
usr.Icon = query.IconUser;
usr.IdAdmin = query.IdAdmin;
usr.IdOwner = query.IdOwner;
usr.Name = query.NameUser;
usr.Password = query.PasswordUser;
usr.Phone = query.PhoneUser;
usr.Status = query.StatusUser;
usr.UserId = query.UserId;
usr.User = query.UserUser;
response.Count = 1;
response.Message = null;
response.Result = usr;
await BLNotifications.InsertNotification(usr.UserId, PlayerId, PushToken, 0);
}
else
{
response.Count = 0;
response.Message = "No hay datos";
response.Result = null;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = null;
return(response);
}
}
//0=usuario, 1= propietario, 2=administrador
public void NotificationsMessage(Guid?Id, int typeUser, string Message)
{
try
{
using (var dc = new RentAppEntities())
{
var queryFilter = dc.spSelNotifications(Id, typeUser).FirstOrDefault();
if (queryFilter != null)
{
NotifyUser(queryFilter.PlayerId, Message);
}
}
}
catch (Exception ex)
{
}
}
public async Task <Response <OwnerVM> > DoLogin(string user, string password, string PlayerId, string PushToken)
{
Response <OwnerVM> response = new Response <OwnerVM>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spSelOwnerDoLogin(user, password).Where(c => c.StatusOwner == true).FirstOrDefault();
if (query != null)
{
var o = new OwnerVM();
o.Address = query.AddressOwner;
o.DateCreated = query.DateCreatedOwner;
o.DateModified = query.DateModifiedOwner;
o.Icon = query.IconOwner;
o.IconString = query.IconStringOwner;
o.IdAdmin = query.IdAdmin;
o.IdOwner = query.IdOwner;
o.Name = query.NameOwner;
o.Password = query.PasswordOwner;
o.Phone = query.PhoneOwner;
o.Status = query.StatusOwner;
o.User = query.UserOwner;
response.Count = 1;
response.Message = null;
response.Result = o;
await BLNotifications.InsertNotification(o.IdOwner, PlayerId, PushToken, 1);
}
else
{
response.Count = 0;
response.Message = "No hay datos";
response.Result = null;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = null;
return(response);
}
}
public async Task <Response <AdministratorVM> > DoLogin(string user, string password, string PlayerId, string PushToken)
{
Response <AdministratorVM> response = new Response <AdministratorVM>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spSelAdministratorDoLogin(user, password).Where(c => c.StatusAdmin == true).FirstOrDefault();
if (query != null)
{
var ad = new AdministratorVM();
ad.Address = query.AdddresAdmin;
ad.DateCreated = query.DateCreatedAdmin;
ad.DateModified = query.DateModifiedAdmin;
ad.Icon = query.IconAdmin;
ad.IconString = query.IconStringAdmin;
ad.IdAdmin = query.IdAdmin;
ad.Name = query.NameAdmin;
ad.Password = query.PasswordAdmin;
ad.Phone = query.PhoneAdmin;
ad.Status = query.StatusAdmin;
ad.User = query.UserAdmin;
response.Count = 1;
response.Message = null;
response.Result = ad;
await BLNotifications.InsertNotification(ad.IdAdmin, PlayerId, PushToken, 2);
}
else
{
response.Count = 0;
response.Message = "No hay datos";
response.Result = null;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = null;
return(response);
}
}
public async Task <Response <bool> > InsertOwner(OwnerInsVM owner)
{
Response <bool> response = new Response <bool>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spInsOwner(
owner.IdAdmin,
owner.Name,
owner.Address,
owner.Phone,
owner.User,
owner.Icon,
owner.IconString,
owner.Password);
if (query == -1)
{
response.Count = 1;
response.Message = null;
response.Result = true;
}
else
{
response.Count = 0;
response.Message = "No se pudo guardar el propietario";
response.Result = false;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = false;
return(response);
}
}
public async Task <Response <bool> > InsertDocuments(DocumentsVM doc)
{
Response <bool> response = new Response <bool>();
try
{
using (var dc = new RentAppEntities())
{
var query = dc.spInsDocument(doc.IdOwner, doc.IdAdmin, doc.Name, doc.FileDocument, doc.StringFile, ".pdf");
if (query == -1)
{
if (doc.IdOwner == null || doc.IdOwner == Guid.Empty)
{
//es para todos los usurios
var owner = await o.SelectOwnerAll(true);
foreach (var itemO in owner.Result)
{
Helpers.Notifications.Instance.NotificationsMessage(itemO.IdOwner, 1, "El administrador subio un nuevo documento");
var user = await u.GetUser(itemO.IdOwner, true);
foreach (var itemU in user.Result)
{
Helpers.Notifications.Instance.NotificationsMessage(itemU.UserId, 0, "El administrador subio un nuevo documento");
}
}
//var user = await u.
}
else
{
//es para el propietario y los usuarios
var ownerFilter = await o.SelectOwnerAll(true);
var owner = ownerFilter.Result.Where(c => c.Status == true && c.IdOwner == doc.IdOwner).ToList();
foreach (var itemO in owner)
{
Helpers.Notifications.Instance.NotificationsMessage(itemO.IdOwner, 1, "El administrador subio un nuevo documento");
var user = await u.GetUser(itemO.IdOwner, true);
foreach (var itemU in user.Result)
{
Helpers.Notifications.Instance.NotificationsMessage(itemU.UserId, 0, "El administrador subio un nuevo documento");
}
}
}
response.Count = 1;
response.Message = null;
response.Result = true;
}
else
{
response.Count = 0;
response.Message = "No se pudo insertar el documento";
response.Result = false;
}
}
return(response);
}
catch (Exception ex)
{
response.Count = 0;
response.Message = ex.Message;
response.Result = false;
return(response);
}
}
