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));
}
