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