public void DeleteAgentBankInfo(int id) { AgentBanks datatodelete = db.AgentBanks.First(m => m.AgentBankId == id); // AgentBanks datatodelete = new AgentBanks(); // datatodelete.AgentBankId = modeldata.AgentBankId db.DeleteObject(datatodelete); db.SaveChanges(); }
/// <summary> /// /////// /// </summary> /// <param name="model"></param> public void UpdateAgentBankInfo(AgentBankModel model) { AgentBanks ab = db.AgentBanks.Where(u => u.AgentBankId == model.AgentBankId).FirstOrDefault(); ab.AgentBankId = model.AgentBankId; ab.BankId = model.BankId; ab.BankBranchId = model.BankBranchId; ab.BankAccountTypeId = model.BankAccountTypeId; ab.AccountName = model.AccountName; ab.AccountNumber = model.AccountNumber; db.ApplyCurrentValues(ab.EntityKey.EntitySetName, ab); db.SaveChanges(); }
public int SaveAgentBankInfo(AgentBankModel modelTosave, int agentid) { AgentBanks datamodel = new AgentBanks { AgentId = agentid, BankId = modelTosave.BankId, BankBranchId = modelTosave.BankBranchId, BankAccountTypeId = modelTosave.BankAccountTypeId, AccountName = modelTosave.AccountName, AccountNumber = modelTosave.AccountNumber, isDefault = false, }; db.AddToAgentBanks(datamodel); db.SaveChanges(); int lastid = GetLastAgentBankId().ToList().Last().AgentBankId; return(lastid); }