//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
