public ActionResult GetBranchDetails(int branchid )
{
CommonDAL cd = new CommonDAL();
BranchDetailsViewModel objbranch = new BranchDetailsViewModel();
// MessageBox.Show(branchid);
objbranch = cd.GetBranchDetails(BranchCode[branchid-1]);
return Json(objbranch);
}
public BranchDetailsViewModel GetSelfBranchDetails(string BankerID)
{
BranchDetailsViewModel bd = new BranchDetailsViewModel();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Database1ConnectionString"].ToString()))
{
SqlCommand command = new SqlCommand(String.Format("SELECT BranchName,CityName,Address,ContactNumber, Email FROM Branch WHERE BranchLogInID = '{0}'",BankerID), connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
// Call Read before accessing data.
if (reader.HasRows)
{
reader.Read();
bd.BranchName = reader[0].ToString();
bd.CityName = reader[1].ToString();
bd.Address = reader[2].ToString();
bd.ContactNumber = reader[3].ToString();
bd.Email = reader[4].ToString();
}
else
System.Windows.Forms.MessageBox.Show("Error in accessing Branch Table");
reader.Close();
}
return bd;
}
public BranchDetailsViewModel GetBranchDetails(long BranchCode)
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Database1ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("SELECT BranchName,CityName,Address,ContactNumber, Email FROM Branch WHERE BranchCode = " + BranchCode, cn);
cn.Open();
SqlDataReader rd = cmd.ExecuteReader();
BranchDetailsViewModel bd = new BranchDetailsViewModel();
if (rd.Read())
{
bd.BranchName = rd[0].ToString();
bd.CityName = rd[1].ToString();
bd.Address = rd[2].ToString();
bd.ContactNumber = rd[3].ToString();
bd.Email = rd[4].ToString();
}
else
System.Windows.Forms.MessageBox.Show("No Data in Branch Table !");
cn.Close();
return bd;
}