//private AppDbContext db;// = new AppDbContext(); #endregion #region AccountOfficer /// <summary> /// Inserts a new row in the MdmDQQue table. /// </summary> /// <param name="mdmque">A MdmDQQue object.</param> /// <returns>An updated MdmDQQue object.</returns> public AccountOfficer InsertAccountOfficer(AccountOfficer mdmdque) { using (var db = new AppDbContext()) { db.Set <AccountOfficer>().Add(mdmdque); db.SaveChanges(); return(mdmdque); } }
/// <summary> /// Updates the queitem /// </summary> /// <param name="queitem">queitem</param> public virtual void UpdateAccountOfficer(AccountOfficer queitem) { if (queitem == null) { throw new ArgumentNullException("queitem"); } _aoDAC.UpdateAccountOfficer(queitem); //event notification //_eventPublisher.EntityUpdated(vendor); }
/// <summary> /// Delete an item /// </summary> /// <param name="queitem">QueItem</param> public virtual void DeleteQueItem(AccountOfficer queitem) { if (queitem == null) { throw new ArgumentNullException("queitem"); } UpdateAccountOfficers(queitem); //event notification //_eventPublisher.EntityDeleted(vendor); }
/// <summary> /// Updates an existing row in the mdmdque table. /// </summary> /// <param name="mdmdque">A mdmdque entity object.</param> public void UpdateAccountOfficer(AccountOfficer mdmdque) { using (var db = new AppDbContext()) { var entry = db.Entry <AccountOfficer>(mdmdque); // Re-attach the entity. entry.State = EntityState.Modified; db.SaveChanges(); } }
public IActionResult Upsert(AccountOfficer accountOfficer) { if (ModelState.IsValid) { if (accountOfficer.Id == 0) { _unitOfWork.AccountOfficers.Add(accountOfficer); } else { _unitOfWork.AccountOfficers.Update(accountOfficer); } _unitOfWork.Save(); return(RedirectToAction(nameof(Index))); } return(View(accountOfficer)); }
public IActionResult Upsert(int?id) { AccountOfficer accountOfficer = new AccountOfficer(); if (id == null) { return(View(accountOfficer)); } accountOfficer = _unitOfWork.AccountOfficers.Get(id.GetValueOrDefault()); if (accountOfficer == null) { return(NotFound()); } return(View(accountOfficer)); }
} //========== end of the mtd public IEnumerable <Models.AccountOfficer> GetTeamstructureByAcct(string code, string search) { List <AccountOfficer> acctOfficerList = new List <AccountOfficer>(); using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("spp_getteambankacctofficer", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 0; //cmd.Parameters.Add("@result", System.Data.SqlDbType.TinyInt).Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(new SqlParameter { ParameterName = "Search", Value = search, }); con.Open(); //cmd.ExecuteNonQuery(); //cmd2.ExecuteNonQuery(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var tb = new AccountOfficer(); if (code == "ACCT") { tb.AccountOfficer_Code = reader["AccountOfficer_Code"] != DBNull.Value ? reader["AccountOfficer_Code"].ToString() : "default"; tb.AccountOfficer_Name = reader["AccountOfficer_Name"] != DBNull.Value ? reader["AccountOfficer_Name"].ToString() : "default"; } acctOfficerList.Add(tb); } con.Close(); } return(acctOfficerList); } //========== end of the mtd