public ActionResult Edit(int id) { BranchBE branch = branchRep.GetAllBranch(0).Find(x => x.Id == id); ViewBag.Bank = bankRep.GetAllBank().ToList(); return(View(branch)); }
public List <BranchBE> GetAllBranch(Int32 BankId) { List <BranchBE> branchList = new List <BranchBE>(); using (SqlConnection conn = new SqlConnection(ConnectionData.dbCn)) { conn.Open(); SqlCommand cmd = new SqlCommand("usp_branchList", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@bank_id", SqlDbType.Int).Value = BankId; using (SqlDataReader dr = cmd.ExecuteReader()) { BranchBE br; while (dr.Read()) { br = new BranchBE(); br.Id = Convert.ToInt32(dr["id"].ToString()); br.BankId = Convert.ToInt32(dr["bank_id"].ToString()); br.Name = dr["name"].ToString(); br.Address = dr["address"].ToString(); br.RegistrationDate = Convert.ToDateTime(dr["registration_date"]); br.BankName = dr["bank_name"].ToString(); branchList.Add(br); } } } return(branchList); }
public ActionResult Create() { BranchBE branch = new BranchBE(); // ViewBag.Bank = bankRep.GetAllBank().ToList(); return(View(branch)); }
public ActionResult Edit(BranchBE branch, FormCollection collection) { try { if (!ModelState.IsValid) { return(View(branch)); } branchRep.UpdateBranch(branch); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(BranchBE branch, FormCollection collection) { try { if (!ModelState.IsValid) { return(View(branch)); } branch.BankId = Convert.ToInt32(collection["Bank"].ToString()); branchRep.AddBranch(branch); return(RedirectToAction("Index")); } catch { return(View()); } }
public void UpdateBranch(BranchBE br) { Int32 r = 0; using (SqlConnection conn = new SqlConnection(ConnectionData.dbCn)) { conn.Open(); SqlCommand cmd = new SqlCommand("usp_updateBranch", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@id", SqlDbType.Int).Value = br.Id; cmd.Parameters.Add("@bank_id", SqlDbType.Int).Value = br.BankId; cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = br.Name; cmd.Parameters.Add("@address", SqlDbType.VarChar).Value = br.Address; r = cmd.ExecuteNonQuery(); } }
public ActionResult Delete(BranchBE branch) { try { if (!ModelState.IsValid) { return(View(branch)); } branchRep.DeleteBranch(branch.Id); return(RedirectToAction("Index")); } catch (Exception ex) { ViewBag.Error = ex.Message; branch = branchRep.GetAllBranch(0).Find(x => x.Id == branch.Id); return(View(branch)); } }
public ActionResult Delete(int id) { BranchBE branch = branchRep.GetAllBranch(0).Find(x => x.Id == id); return(View(branch)); }