public void SelectRecord(BMemRegBLL MRBLL) { SqlDataReader dr; SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); con.Open(); try { SqlParameter[] par = new SqlParameter[] { new SqlParameter("@MID", MRBLL.MID1), }; dr = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "uspSelectMReg", par); if (dr.HasRows) { dr.Read(); MRBLL.GID1 = Convert.ToString(dr["GID"]); MRBLL.FName1 = Convert.ToString(dr["FName"]); MRBLL.LName1 = Convert.ToString(dr["LName"]); MRBLL.MobileNo1 = Convert.ToString(dr["MobileNo"]); MRBLL.Post1 = Convert.ToString(dr["Post"]); MRBLL.DOJ1 = Convert.ToString(dr["DOJ"]); MRBLL.Subscription1 = Convert.ToString(dr["Subscription"]); MRBLL.Deposite1 = Convert.ToString(dr["Deposite"]); MRBLL.Loan1 = Convert.ToString(dr["Loan"]); } } catch (Exception ex) { } finally { con.Close(); } }
public int UpdateRecord(BMemRegBLL MRBLL) { SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); DataSet ds = new DataSet(); string str = DateTime.Now.Date.ToString("yyyy-MM-dd"); try { SqlParameter[] par = new SqlParameter[] { new SqlParameter("@MID", MRBLL.MID1), new SqlParameter("@GID", MRBLL.GID1), new SqlParameter("@FName", MRBLL.FName1), new SqlParameter("@LName", MRBLL.LName1), new SqlParameter("@MobileNo", MRBLL.MobileNo1), new SqlParameter("@Post", MRBLL.Post1), new SqlParameter("@DOJ", MRBLL.DOJ1), new SqlParameter("@Subscription", MRBLL.Subscription1), new SqlParameter("@Deposite", MRBLL.Deposite1), new SqlParameter("@Loan", MRBLL.Loan1), new SqlParameter("@UserId", MRBLL.UserId1), new SqlParameter("@EntryDate", str), }; SqlCommand cmd = new SqlCommand("uspUBMReg", con); cmd.Parameters.AddRange(par); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); con.Open(); int re = cmd.ExecuteNonQuery(); return(re); } catch (Exception ex) { throw ex; } finally { con.Close(); } }
public DataSet LoadGrid(BMemRegBLL MRBLL) { SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); DataSet ds = new DataSet(); try { SqlParameter[] par = new SqlParameter[1]; par[0] = new SqlParameter("@UserId", MRBLL.UserId1); SqlCommand cmd = new SqlCommand("uspBLoadMemRegistration", conn); cmd.Parameters.AddRange(par); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); return(ds); } catch (Exception ex) { throw ex; } }
public void SelectBLL(BMemRegBLL objBMemRegBLL) { objBMRegDAL.SelectRecord(objBMemRegBLL); }
public int UpdateBLL(BMemRegBLL objBMemRegBLL) { int i = objBMRegDAL.UpdateRecord(objBMemRegBLL); return(i); }
public int AddRecordBLL(BMemRegBLL objBMemRegBLL) { int k = objBMRegDAL.AddRecord(objBMemRegBLL); return(k); }
public DataSet LoadgridBLL(BMemRegBLL objBMemRegBLL) { return(objBMRegDAL.LoadGrid(objBMemRegBLL)); }