public void Update(QoalaEntities db)
{
var info = findByKey(db, this.KEY);
info.VALUE = this.VALUE;
db.SaveChanges();
}
public static AccessControl find(QoalaEntities context, String token)
{
var now = DateTime.Now;
return(context.ACCESSCONTROLs
.FirstOrDefault(a => a.TOKEN == token && now <= a.EXPIRED_AT));
}
public static int totalNumberPageByAuthorId(QoalaEntities context, Decimal authorId)
{
var query = context.COMMENTS.
Join(context.POSTS,
comment => comment.ID_POST,
post => post.ID_POST,
(comment, post) => new { Comment = comment, Post = post }
);
User user = User.findById(context, authorId);
if (user.PERMISSION == 3)
{
query = query.Where(
commentAndPost =>
!commentAndPost.Comment.DELETED_AT.HasValue &&
!commentAndPost.Post.DELETED_AT.HasValue
);
}
else
{
query = query.Where(commentAndPost => commentAndPost.Post.ID_USER == authorId &&
!commentAndPost.Comment.DELETED_AT.HasValue &&
!commentAndPost.Post.DELETED_AT.HasValue);
}
decimal count = query.Count();
return((int)Math.Ceiling(count / LIMIT));
}
public static bool belongsToPost(QoalaEntities context, decimal id_comment, decimal id_post)
{
return(context.COMMENTS.Where(
c => c.ID_COMMENT == id_comment && !c.DELETED_AT.HasValue &&
!c.POST.DELETED_AT.HasValue
).Count() > 0);
}
public decimal?Add(QoalaEntities context)
{
if (emailAlreadyExist(context, EMAIL))
{
throw new UserEmailExistsException();
}
var outParameter = new ObjectParameter("OUT_ID_USER", typeof(decimal));
if (!(PERMISSION > 0 && PERMISSION <= 4))
{
PERMISSION = 1;
}
int ret = context.SP_INSERT_USER(NAME, PASSWORD, EMAIL, PERMISSION, ADDRESS, DISTRICT, CITY, STATE, ZIPCODE, outParameter);
if (outParameter.Value == DBNull.Value)
{
ID_USER = 0m;
}
else
{
ID_USER = (Decimal)outParameter.Value;
}
context.Entry(this).State = EntityState.Unchanged;
return(ID_USER);
}
public decimal?Add(QoalaEntities context)
{
var outParameter = new ObjectParameter("OUT_ID_GEO", typeof(decimal));
context.SP_INSERT_DEVICE_GEO_LOCATION(
ID_DEVICE,
LATITUDE,
LONGITUDE,
outParameter
);
if (outParameter.Value == DBNull.Value)
{
throw new CreateRecordException();
}
ID_DEVICE_GEO_LOCATION = (Decimal)outParameter.Value;
context.Entry(this).State = EntityState.Unchanged;
Device device = DAO.Device.findById(context, ID_DEVICE);
device.LAST_LATITUDE = LATITUDE;
device.LAST_LONGITUDE = LONGITUDE;
device.UpdateLastLocation(context);
return(ID_DEVICE_GEO_LOCATION);
}
public decimal?UpdateLastLocation(QoalaEntities context)
{
var outParameter = new ObjectParameter("ROWCOUNT", typeof(decimal));
context.SP_UPDATE_LAST_LOCATION(ID_DEVICE, LAST_LONGITUDE, LAST_LATITUDE, outParameter);
return(1);
}
public decimal?TurnAlarm(QoalaEntities context)
{
var outParameter = new ObjectParameter("ROWCOUNT", typeof(decimal));
context.SP_TURN_ALARM(ID_DEVICE, ((bool)ALARM ? 1 : 0), outParameter);
return(1);
}
// this may should be on ACCESSCONTROL class
public AccessControl doLogin(QoalaEntities context)
{
User user = findByEmail(context, EMAIL);
if (user != null && user.PASSWORD.Equals(PASSWORD))
{
AccessControl access = null;
//ja teve sessões, busca uma ativa
if (user.ACCESSCONTROLs.Count() > 0)
{
// melhoria: Adicionar Client ID. e cada tipo de aplicação deverá passar um ClientID para o login, e filtrar aqui.
access = user.ACCESSCONTROLs.FirstOrDefault(ac => ac.EXPIRED_AT >= DateTime.Now);
}
if (access == null)
{
access = new AccessControl {
USER = user
};
access.Add(context);
context.SaveChanges();
}
return(access);
}
return(null);
}
public static bool belongsToUser(QoalaEntities context, decimal id_device, decimal id_user)
{
return(context.DEVICES.Where(
d => d.ID_USER == id_user && !d.DELETED_AT.HasValue &&
!d.USER.DELETED_AT.HasValue
).Count() > 0);
}
public User GetUser()
{
using (QoalaEntities db = new QoalaEntities())
{
return(db.USERS.FirstOrDefault(u => u.ID_USER == ID_USER));
}
}
public static Plan Find(Decimal id_plan)
{
using (QoalaEntities qe = new QoalaEntities())
{
return(qe.PLANS.FirstOrDefault(u => u.ID_PLAN == id_plan));
}
}
public void UserSelect1()
{
using (var qe = new QoalaEntities())
{
qe.USERS.Where(a => a.DELETED_AT <= DateTime.Now).FirstOrDefault();
}
}
public decimal?Update(QoalaEntities context)
{
var outParameter = new ObjectParameter("ROWCOUNT", typeof(decimal));
context.SP_UPDATE_POST(ID_POST, TITLE, CONTENT, ID_USER, outParameter);
return(1);
}
public decimal?Approve(QoalaEntities context)
{
var outParameter = new ObjectParameter("ROWCOUNT", typeof(decimal));
context.SP_APPROVE_COMMENT(ID_COMMENT, outParameter);
context.Entry(this).State = EntityState.Unchanged;
return(1);
}
public static int totalNumberPageByUser(QoalaEntities context, decimal idUser)
{
decimal count = context.DEVICES.
Where(p => !p.DELETED_AT.HasValue && p.ID_USER == idUser).
Count();
return((int)Math.Ceiling(count / LIMIT));
}
public static int totalNumberPage(QoalaEntities context)
{
decimal count = context.DEVICES.
Where(p => !p.DELETED_AT.HasValue).
Count();
return((int)Math.Ceiling(count / LIMIT));
}
public decimal?Publish(QoalaEntities context)
{
var outParameter = new ObjectParameter("ROWCOUNT", typeof(decimal));
context.SP_PUBLISH_POST(ID_POST, outParameter);
context.Entry(this).State = EntityState.Unchanged;
return(1);
}
public static int TotalNumberPageFromIdUser(QoalaEntities context, int IdUser)
{
decimal count = context.POSTS.
Where(p => p.ID_USER == IdUser && !p.DELETED_AT.HasValue).
Count();
return((int)Math.Ceiling(count / LIMIT));
}
public decimal?Delete(QoalaEntities context)
{
var outParameter = new ObjectParameter("ROWCOUNT", typeof(decimal));
context.SP_DELETE_DEVICE(ID_DEVICE, outParameter);
context.Entry(this).State = EntityState.Unchanged;
return(1);
}
public static int totalNumberPage(QoalaEntities context)
{
decimal count = context.USERS.
Where(u => u.DELETED_AT == null).
Count();
return((int)Math.Ceiling(count / LIMIT));
}
public Decimal Update(QoalaEntities context)
{
var outParameter = new ObjectParameter("PROWCOUNT", typeof(decimal));
context.SP_UPDATE_USER(ID_USER, NAME, PASSWORD, EMAIL, PERMISSION, ADDRESS, DISTRICT, CITY, STATE, ZIPCODE, outParameter);
//context.Entry(this).State = EntityState.Unchanged;
return(1);
}
public Decimal Delete(QoalaEntities context)
{
var outParameter = new ObjectParameter("ROWCOUNT", typeof(decimal));
int ret = context.SP_DELETE_USER(ID_USER, outParameter);
context.Entry(this).State = EntityState.Unchanged;
return((Decimal)outParameter.Value);
}
public AccessControl createAccessControl(QoalaEntities context)
{
AccessControl ac = new AccessControl {
USER = this
};
return(ac.Add(context));
}
public void Update()
{
using (QoalaEntities qe = new QoalaEntities())
{
qe.Entry(this).State = System.Data.Entity.EntityState.Modified;
qe.SaveChanges();
}
}
public bool Delete(QoalaEntities context)
{
this.Logger().Debug("delete ACCESSCONTROL(" + TOKEN + ") for user: " + this.USER.ToString());
// Do not remove this entity, just update with expired now
//context.ACCESSCONTROLs.Remove(this);
this.EXPIRED_AT = DateTime.Now;
context.Entry(this).State = EntityState.Modified;
context.SaveChanges();
return(find(context, TOKEN) == null);
}
public void Add()
{
using (QoalaEntities qe = new QoalaEntities())
{
this.CREATED_AT = DateTime.Now;
this.TOTAL = LEFT;
qe.PLANS.Add(this);
qe.SaveChanges();
}
}
public AccessControl Add(QoalaEntities context)
{
this.Logger().Debug("add ACCESSCONTROL for user: "******"-" + USER.ID_USER.ToString();
// TODO: make the number to addDays configured by USER configuration ou SYSTEM configuration
EXPIRED_AT = DateTime.Now.AddDays(7);
CREATED_AT = DateTime.Now;
context.ACCESSCONTROLs.Add(this);
context.SaveChanges();
return(this);
}
public void UserHasBeenTaken()
{
using (var qe = new QoalaEntities())
{
var email = "abc@abc2";
User u = new User {
NAME = "teste", EMAIL = email, PASSWORD = "******"
};
u.Add(qe);
qe.SaveChanges();
Assert.IsTrue(User.emailAlreadyExist(qe, email));
}
}
public void AddPlan(int QntPlans)
{
QoalaEntities qe = new QoalaEntities();
qe.Entry(this).State = EntityState.Modified;
qe.SaveChanges();
Plan p = qe.PLANS.Find(ID_PLAN);
p.LEFT = p.LEFT - QntPlans;
qe.Entry(p).State = EntityState.Modified;
qe.SaveChanges();
}
