public int AddRecord(BReceiveDepBLL BRDB) { SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); DataSet ds = new DataSet(); try { SqlParameter[] par = new SqlParameter[] { new SqlParameter("@MID", BRDB.MID1), new SqlParameter("@DepositeAmt", BRDB.DepositeAmt1), new SqlParameter("@PaymentType", BRDB.PaymentType1), new SqlParameter("@Date", BRDB.Date1), new SqlParameter("@DepositPeriod", BRDB.DepositPeriod1), new SqlParameter("@UserId", BRDB.UserId1), new SqlParameter("@EntryDate", BRDB.EntryDate1) }; SqlCommand cmd = new SqlCommand("uspBReceiveDepositeInsertMyct", con); cmd.Parameters.AddRange(par); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); con.Open(); int result = cmd.ExecuteNonQuery(); return(result); } catch (Exception ex) { throw ex; } }
public void SelectRecord(BReceiveDepBLL BRDB) { SqlDataReader dr; SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); con.Open(); try { SqlParameter[] par = new SqlParameter[] { new SqlParameter("@ID", BRDB.ID1), }; dr = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "uspBSelectReceiveDep", par); if (dr.HasRows) { dr.Read(); //BRDB.ID1 = Convert.ToString(dr["ID"]); BRDB.MID1 = Convert.ToString(dr["MID"]); BRDB.DepositeAmt1 = Convert.ToString(dr["DepositeAmt"]); BRDB.PaymentType1 = Convert.ToString(dr["PaymentType"]); BRDB.DepositPeriod1 = Convert.ToString(dr["DepositPeriod"]); BRDB.Date1 = Convert.ToString(dr["Date"]); } } catch (Exception ex) { } finally { con.Close(); } }
public DataSet LoadGrid(BReceiveDepBLL BRDB) { SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); DataSet ds = new DataSet(); try { SqlParameter[] par = new SqlParameter[1]; par[0] = new SqlParameter("@UserId", BRDB.UserId1); SqlCommand cmd = new SqlCommand("uspBLoadReceiveDeposite", con); cmd.Parameters.AddRange(par); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); return(ds); } catch (Exception ex) { throw ex; } }
public int UpdateRecord(BReceiveDepBLL BRDB) { 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("@ID", BRDB.ID1), new SqlParameter("@MID", BRDB.MID1), new SqlParameter("@DepositeAmt", BRDB.DepositeAmt1), new SqlParameter("@PaymentType", BRDB.PaymentType1), new SqlParameter("@Date", BRDB.Date1), new SqlParameter("@DepositPeriod", BRDB.DepositPeriod1), new SqlParameter("@EntryDate", BRDB.EntryDate1) }; SqlCommand cmd = new SqlCommand("uspUpdateBReceiveDep", 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 int UpdateBLL(BReceiveDepBLL objBReceiveDepBLL) { int i = objBReceiveDepDAL.UpdateRecord(objBReceiveDepBLL); return(i); }
public int AddRecordBLL(BReceiveDepBLL objBReceiveDepBLL) { int k = objBReceiveDepDAL.AddRecord(objBReceiveDepBLL); return(k); }
public DataSet LoadgridBLL(BReceiveDepBLL objBReceiveDepBLL) { return(objBReceiveDepDAL.LoadGrid(objBReceiveDepBLL)); }
public void SelectBLL(BReceiveDepBLL objBReceiveDepBLL) { objBReceiveDepDAL.SelectRecord(objBReceiveDepBLL); }