// GET: Trasach/Edit/5 public ActionResult Edit(int id) { using (ModelDbContext modelDbContext = new ModelDbContext()) { return(View(modelDbContext.TRASACHes.Where(x => x.MATRASACH == id).FirstOrDefault())); } }
public override void Delete(ModelDbContext context) { context.Warlocks.Remove(context.Warlocks.SingleOrDefault(c => c.ID == this.ID)); var soloAbils = (context.WarlockAbillities.Where(c => c.WarlockId == ID)); foreach (var abil in soloAbils) { context.WarlockAbillities.Remove(abil); } var soloSpells = (context.WarlockSpells.Where(c => c.WarlockId == ID)); foreach (var spell in soloSpells) { context.WarlockSpells.Remove(spell); } var soloWeaps = (context.WarlockWeapons.Where(c => c.WarlockId == ID)); foreach (var weap in soloWeaps) { context.WarlockWeapons.Remove(weap); } context.SaveChanges(); }
public IEnumerable <Employee> Get() { using (ModelDbContext db = new ModelDbContext()) { return(db.Employees.ToList()); } }
public bool IsUserName(string userName) { using (ModelDbContext db = new ModelDbContext()) { return(db.tblUsers.Any(p => p.UserName.Equals(userName) || p.UserName.ToUpper().Equals(userName.ToUpper()))); } }
public tblUser GetByEmail(string email) { using (var db = new ModelDbContext()) { return(db.tblUsers.SingleOrDefault(p => p.Email.ToLower().Equals(email.ToLower().Trim()))); } }
public ICollection <tblUser> GetByPaging(int pageNumber, int pageSize) { using (var db = new ModelDbContext()) { return(db.tblUsers.Where(p => p.Status != (short)Commons.Status.Deleted).OrderByDescending(p => p.Id).Skip(pageNumber * pageSize).Take(pageNumber).ToList()); } }
public IPagedList <tblUser> GetByPageList(int pageNumber, int pageSize) { using (var db = new ModelDbContext()) { return(db.tblUsers.Where(p => p.Status != (short)Commons.Status.Deleted).OrderByDescending(p => p.Id).ToPagedList(pageNumber, pageSize)); } }
//添加字段 public static void AddField(this ModelDbContext context, RuntimeModelMeta model, RuntimeModelMeta.ModelPropertyMeta property) { using (DbConnection conn = context.Database.GetDbConnection()) { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } DbCommand addFieldCmd = conn.CreateCommand(); addFieldCmd.CommandText = $"alert table {model.ClassName} add {property.PropertyName} "; switch (property.ValueType) { case "int": addFieldCmd.CommandText += "int"; break; case "datetime": addFieldCmd.CommandText += "datetime"; break; case "bool": addFieldCmd.CommandText += "bit"; break; default: addFieldCmd.CommandText += "nvarchar(max)"; break; } addFieldCmd.ExecuteNonQuery(); } }
public ICollection <tblComment> GetByNews(int id) { using (var db = new ModelDbContext()) { return(db.tblComments.Where(p => p.News == id && p.Status != (short)Commons.Status.Deleted).OrderByDescending(p => p.Id).ToList()); } }
public ActionResult account() { int userID = int.Parse(Request.Cookies["uID"]); List <User_Table> userData = new List <User_Table>(); using (var db = new ModelDbContext()) { userData = db.Users .Where(x => x.User_Id == userID) .ToList(); } var user = new UserModel() { firstName = userData[0].First_Name, lastName = userData[0].Last_Name, email = userData[0].Email, password = userData[0].Password, phone = userData[0].phone, address = userData[0].Address, address2 = userData[0].Adress2, city = userData[0].City, state = userData[0].State, zipCode = userData[0].Zip, specialty = userData[0].Specialty, designation = userData[0].Degree, UserId = userID }; return(View(user)); }
public void GetByPersnrTest() { var options = CreateNewContextOptions(); // Run the test against one instance of the context using (var context = new ModelDbContext(options)) { List <Person> list = createData(); foreach (var p in list) { context.Person.Add(p); } context.SaveChanges(); PersonCreateUpdateDeleteFake crudFake = new PersonCreateUpdateDeleteFake(); PersonController controller = new PersonController(context, crudFake); var response = controller.GetByPersnr("min", "pse", 12345); Assert.True(response.success == "true"); Assert.True(response.result.First().ForNamn == "Per"); } }
public ICollection <tblGroup> GetAll() { using (var db = new ModelDbContext()) { return(db.tblGroups.Where(p => p.Status != (short)Commons.Status.Deleted).OrderByDescending(p => p.Id).ToList()); } }
public ICollection <tblGroup> GetByParent(short parent) { using (var db = new ModelDbContext()) { return(db.tblGroups.Where(p => p.Status != (short)Commons.Status.Deleted && p.ParentId == parent).OrderByDescending(p => p.Id).Include(p => p.Childrens).ToList()); } }
private async Task SoftUpdateMpanFields(ModelDbContext dbContext, Site newSite, Mpan existing, MpanDto updatedDto) { SetPropertyIfNotNull(existing, e => e.IsEnergized, updatedDto.IsEnergized); SetPropertyIfNotNull(existing, e => e.IsNewConnection, updatedDto.IsNewConnection); SetPropertyIfNotNull(existing, e => e.EAC, updatedDto.EAC); SetPropertyIfNotNull(existing, e => e.REC, updatedDto.REC); SetPropertyIfNotNull(existing, e => e.Capacity, updatedDto.Capacity); SetPropertyIfNotNull(existing, e => e.CCLEligible, updatedDto.CCLEligible); SetPropertyIfNotNull(existing, e => e.VATPercentage, updatedDto.VATPercentage); SetPropertyIfNotNull(existing, e => e.IsAMR, updatedDto.IsAMR); SetStringPropertyIfNotNullOrEmpty(existing, e => e.MeterType, updatedDto.MeterType); SetStringPropertyIfNotNullOrEmpty(existing, e => e.MeterTimeSwitchCode, updatedDto.MeterTimeSwitchCode); SetStringPropertyIfNotNullOrEmpty(existing, e => e.LLF, updatedDto.LLF); SetStringPropertyIfNotNullOrEmpty(existing, e => e.ProfileClass, updatedDto.ProfileClass); SetStringPropertyIfNotNullOrEmpty(existing, e => e.RetrievalMethod, updatedDto.RetrievalMethod); SetStringPropertyIfNotNullOrEmpty(existing, e => e.GSPGroup, updatedDto.GSPGroup); SetStringPropertyIfNotNullOrEmpty(existing, e => e.MeasurementClass, updatedDto.MeasurementClass); SetStringPropertyIfNotNullOrEmpty(existing, e => e.MOAgent, updatedDto.MOAgent); SetStringPropertyIfNotNullOrEmpty(existing, e => e.DAAgent, updatedDto.DAAgent); SetStringPropertyIfNotNullOrEmpty(existing, e => e.DCAgent, updatedDto.DCAgent); SetStringPropertyIfNotNullOrEmpty(existing, e => e.SerialNumber, updatedDto.SerialNumber); SetStringPropertyIfNotNullOrEmpty(existing, e => e.Voltage, updatedDto.Voltage); SetStringPropertyIfNotNullOrEmpty(existing, e => e.Postcode, updatedDto.Postcode); SetStringPropertyIfNotNullOrEmpty(existing, e => e.Connection, updatedDto.Connection); existing.TariffId = updatedDto.TariffId; existing.Site = newSite; await dbContext.Update(existing); }
public ActionResult Update(string staffid, string percentage, string project, string memo) { if (!User.Identity.IsAuthenticated) { return(null); } if (staffid == null || staffid.IsEmpty() || percentage == null || percentage.IsEmpty() || project == null || project.IsEmpty() || memo == null || memo.IsEmpty() ) { return(null); } ModelDbContext mdb = new ModelDbContext(); IQueryable <Domain> workPercetages = mdb.Domains; int staff = int.Parse(staffid); Domain aim = (from workPercetage in workPercetages where workPercetage.StaffId == staff select workPercetage).First(); aim.Percentage = 100 > int.Parse(percentage) ? int.Parse(percentage) : 100; aim.Project = project; aim.Memo = memo; mdb.SaveChanges(); return(null); }
/// <summary> /// Get Product elements from Database /// </summary> /// <returns>List of Products</returns> private List <ProductModel> GetProductByDataBase() { using (ModelDbContext DbContext = new ModelDbContext()) { return(DbContext.Product.ToList()); } }
public tblUser GetById(int id) { using (var db = new ModelDbContext()) { return(db.tblUsers.Find(id)); } }
public ActionResult CEData(string id) { int myId = 422; if (id != null) { myId = int.Parse(id.ToString()); } List <asimCEData> myCEData = new List <asimCEData>(); using (var db = new ModelDbContext()) { myCEData = db.Cases .Where(x => x.Case_Id == myId) .Select(x => new asimCEData { case_id = x.Case_Id, ce_data = x.CE_Data }) .ToList(); } asimViewModel objViewModel = new asimViewModel() { myCEData = myCEData }; return(View(objViewModel)); }
public ICollection <tblUser> GetByStatusPaging(short status, int pageNumber, int pageSize) { using (var db = new ModelDbContext()) { return(db.tblUsers.Where(p => p.Status == status).OrderByDescending(p => p.Id).Skip(pageNumber * pageSize).Take(pageNumber).ToList()); } }
// GET: LibCards/Details/5 public ActionResult Details(int id) { using (ModelDbContext db = new ModelDbContext()) { return(View(db.THETHUVIENs.Where(x => x.MATHETV == id).FirstOrDefault())); } }
public IPagedList <tblUser> GetByStatusPageList(short status, int pageNumber, int pageSize) { using (var db = new ModelDbContext()) { return(db.tblUsers.Where(p => p.Status == status).OrderByDescending(p => p.Id).ToPagedList(pageNumber, pageSize)); } }
// GET: Muonsach public ActionResult Index() { using (ModelDbContext Dbmodel = new ModelDbContext()) { return(View(Dbmodel.MUONSACKs.ToList())); } }
public tblUser GetByUserName(string userName) { using (var db = new ModelDbContext()) { return(db.tblUsers.SingleOrDefault(p => p.UserName.ToLower().Equals(userName.ToLower().Trim()))); } }
// GET: Muonsach/Delete/5 public ActionResult Delete(int id) { using (ModelDbContext modelDbContext = new ModelDbContext()) { return(View(modelDbContext.MUONSACKs.Where(x => x.MAMUONSACH == id).FirstOrDefault())); } }
public bool InsertAndUpdate(tblUser user) { using (var db = new ModelDbContext()) { var item = new tblUser() { Id = user.Id }; if (db.tblUsers.Any(p => p.Id == user.Id)) { db.tblUsers.Attach(item); item.FullName = user.FullName; item.ModifyDate = DateTime.Now; item.UserName = user.UserName; item.Password = Commons.Encode.MD5(user.Password); item.Img = user.Img; item.ImgResizer = user.ImgResizer; item.Email = user.Email; } else { db.tblUsers.Add(user); } return(db.SaveChanges() > 0); } }
public ICollection <tblSupport> GetAll() { using (var db = new ModelDbContext()) { return(db.tblSupports.OrderByDescending(p => p.CreateDate).ToList()); } }
public IActionResult Delete(int id) { try { using (ModelDbContext db = new ModelDbContext()) { var x = db.Employees.FirstOrDefault(x => x.ID == id); if (x == null) { return(NotFound()); } else { db.Employees.Remove(x); db.SaveChanges(); return(Ok()); } } } catch (Exception ex) { throw ex; } }
public tblSupport GetById(int id) { using (var db = new ModelDbContext()) { return(db.tblSupports.Find(id)); } }
public IActionResult Put(int id, [FromBody] Employee emp) { try { using (ModelDbContext db = new ModelDbContext()) { var x = db.Employees.FirstOrDefault(x => x.ID == id); if (x == null) { return(NotFound()); } else { x.FirstName = emp.FirstName; x.LastName = emp.LastName; x.Gender = emp.Gender; x.Salary = emp.Salary; db.SaveChanges(); return(Ok()); } } } catch (Exception e) { throw e; } }
public UnitOfWork(ModelDbContext context) { Context = context; Repositories = new Dictionary <Type, object>(); LoadRepos("GamesPardinho.Web.Models.Repository.Repositories"); }