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