public static bool UpdatePassword(int id, string password) { try { var db = new Data.Access.Context(); var value = db.TBL_USER.SingleOrDefault(a => a.CDG_ID == id); if (value == null) { return(false); } value.CAR_PASSWORD = password; db.SaveChanges(); return(true); } catch (Exception ex) { TBL_ERROR.Create(ex, Utilities.Basic.GetCurrentMethod(), "Inventory.Data.Management.TBL_USER"); return(false); } }
public static bool Update(Domain.TBL_USER user) { try { var db = new Data.Access.Context(); var value = db.TBL_USER.SingleOrDefault(a => a.CDG_ID == user.CDG_ID); if (value == null) { return(false); } value.CAR_EMAIL = user.CAR_EMAIL; value.CAR_NAME = user.CAR_NAME; value.COD_PROFILE = user.COD_PROFILE; db.SaveChanges(); return(true); } catch (Exception ex) { TBL_ERROR.Create(ex, Utilities.Basic.GetCurrentMethod(), "Inventory.Data.Management.TBL_USER"); return(false); } }
public static bool UpdateLastEntry(int id) { try { var db = new Data.Access.Context(); var value = db.TBL_USER.SingleOrDefault(a => a.CDG_ID == id); if (value == null) { return(false); } value.DAT_LAST_ENTRY = DateTime.Now; db.SaveChanges(); return(true); } catch (Exception ex) { TBL_ERROR.Create(ex, Utilities.Basic.GetCurrentMethod(), "Inventory.Data.Management.TBL_USER"); return(false); } }
public static int Save(Domain.TBL_LOG log) { try { var db = new Data.Access.Context(); log.DAT_TIMESTAMP = DateTime.Now; db.TBL_LOG.Add(log); db.SaveChanges(); var id = db.TBL_LOG.OrderByDescending(d => d.CDG_ID).First().CDG_ID; return id; } catch (Exception ex) { TBL_ERROR.Create(ex, Utilities.Basic.GetCurrentMethod(), "Inventory.Data.Management.TBL_LOG"); return 0; } }
public static bool UpdateLast(int id) { try { var db = new Data.Access.Context(); var data = db.TBL_DATA_ARTICLES.SingleOrDefault(d => d.CDG_ID == id); if (data != null) { data.LAST = (byte)Domain.Enums.LAST_REGISTER.DISABLED; db.SaveChanges(); } return(true); } catch (Exception ex) { TBL_ERROR.Create(ex, Utilities.Basic.GetCurrentMethod(), "Inventory.Data.Management.TBL_DATA_ARTICLES"); return(false); } }
public static int Save(Domain.TBL_DATA_ARTICLES detail) { try { var db = new Data.Access.Context(); detail.LAST = (byte)Domain.Enums.LAST_REGISTER.ENABLED; detail.TIMESTAMP = DateTime.Now; db.TBL_DATA_ARTICLES.Add(detail); db.SaveChanges(); var id = db.TBL_DATA_ARTICLES.OrderByDescending(d => d.CDG_ID).First().CDG_ID; return(id); } catch (Exception ex) { TBL_ERROR.Create(ex, Utilities.Basic.GetCurrentMethod(), "Inventory.Data.Management.TBL_DATA_ARTICLES"); return(0); } }
public static bool DeleteAll() { try { var db = new Data.Access.Context(); var data = db.TBL_DATA_ARTICLES.ToList(); //db.TBL_DATA_ARTICLES. foreach (var d in data) { db.TBL_DATA_ARTICLES.Remove(d); } db.SaveChanges(); return(true); } catch (Exception ex) { TBL_ERROR.Create(ex, Utilities.Basic.GetCurrentMethod(), "Inventory.Data.Management.TBL_DATA_ARTICLES"); return(false); } }
public static int Save(Domain.TBL_USER user) { try { var db = new Data.Access.Context(); user.DAT_TIMESTAMP = DateTime.Now; //este estado variar en un futuro si varia la forma de activacion user.COD_STATUS = (byte)Domain.Status.TBL_USER.ENABLED; db.TBL_USER.Add(user); db.SaveChanges(); var id = db.TBL_USER.OrderByDescending(d => d.CDG_ID).First().CDG_ID; return(id); } catch (Exception ex) { TBL_ERROR.Create(ex, Utilities.Basic.GetCurrentMethod(), "Inventory.Data.Management.TBL_USER"); return(0); } }