////-------------------------------------Select Record Usermaster------------------------------------------------------ public void SelectUserMaster(EventMyctBLL EBLL) { SqlDataReader dr; try { conn.Open(); using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { SqlParameter[] par = new SqlParameter[4]; par[0] = new SqlParameter("@usrUserId", EBLL.UsrUserId); par[1] = new SqlParameter("@Status", 11); par[1].Direction = ParameterDirection.Output; dr = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "EventFaithfully", par); if (dr.HasRows) { dr.Read(); EBLL.UsrFirstName = Convert.ToString(dr["usrFirstName"]); EBLL.UsrLastName = Convert.ToString(dr["usrLastName"]); } } } catch (SqlException ex) { throw ex; } finally { conn.Close(); } }
//public int Deleterecord(EventMyctBLL EBLL) //{ // int row; // try // { // conn.Open(); // using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) // { // SqlParameter[] par = new SqlParameter[20]; // par[0] = new SqlParameter("@Id", EBLL.Id1); // par[1] = new SqlParameter("@BrideName", EBLL.BrideName1); // par[2] = new SqlParameter("@GroomName", EBLL.GroomName1); // par[3] = new SqlParameter("@InvitionFrom", EBLL.InvitionFrom1); // par[4] = new SqlParameter("@DateOfMgs", EBLL.DateOfMgs1); // par[5] = new SqlParameter("@TimeOfMgs", EBLL.TimeOfMgs1); // par[6] = new SqlParameter("@Location", EBLL.Location1); // par[7] = new SqlParameter("@SpecialDescription", EBLL.SpecialDescription1); // par[8] = new SqlParameter("@FristName", EBLL.FristName1); // par[9] = new SqlParameter("@LastName", EBLL.LastName1); // par[10] = new SqlParameter("@MobileNo", EBLL.MobileNo1); // par[11] = new SqlParameter("@Address", EBLL.Address1); // par[12] = new SqlParameter("@Priority", EBLL.Priority1); // // par[13] = new SqlParameter("@MyCt_UserId", EBLL.MyCt_UserId1); // par[13] = new SqlParameter("@status", 11); // par[13].Direction = ParameterDirection.Output; // row = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "EventDeleteMyCT", par); // } // return row; // } // catch (Exception ex) // { // throw ex; // } // finally // { // conn.Close(); // } //} public DataSet loadgrid(EventMyctBLL EBLL) { DataSet ds = new DataSet(); try { conn.Open(); using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { SqlParameter[] par = new SqlParameter[10]; par[0] = new SqlParameter("@MyCt_UserId", EBLL.MyCt_UserId1); //par[1] = new SqlParameter("@status", 11); //par[1].Direction = ParameterDirection.Output; ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "EventGridLoad", par); } return(ds); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } }
public int Updaterecord(EventMyctBLL EBLL) { int row; try { conn.Open(); using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { SqlParameter[] par = new SqlParameter[] { new SqlParameter("@Id", EBLL.Id1), new SqlParameter("@BrideName", EBLL.BrideName1), new SqlParameter("@GroomName", EBLL.GroomName1), new SqlParameter("@InvitionFrom", EBLL.InvitionFrom1), new SqlParameter("@Date", EBLL.Date1), new SqlParameter("@Time", EBLL.Time1), new SqlParameter("@RemDate", EBLL.RemDate1), new SqlParameter("@RemTime", EBLL.RemTime1), new SqlParameter("@Location", EBLL.Location1), new SqlParameter("@PersonName", EBLL.PersonName1), new SqlParameter("@MobileNumber", EBLL.MobileNumber1), new SqlParameter("@PVisit", EBLL.PVisit1), new SqlParameter("@MyCt_UserId", EBLL.MyCt_UserId1), new SqlParameter("@MDescp", EBLL.MDescp1), new SqlParameter("@CurrentDate", cc.DateFormatStatus()), //new SqlParameter("@Status1",EBLL.Status3), //new SqlParameter("@Status2",EBLL.Status4), }; // par[13] = new SqlParameter("@MyCt_UserId", EBLL.MyCt_UserId1); //par[13] = new SqlParameter("@SendMgs", EBLL.SendMgs1); row = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "sp_UEMyCt", par); } return(row); } catch (Exception ex) { throw ex; } finally { conn.Close(); } }
public void SelectRecord(EventMyctBLL EBLL) { SqlDataReader dr; try { conn.Open(); using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { SqlParameter[] par = new SqlParameter[] { new SqlParameter("@Id", EBLL.Id1), //new SqlParameter("@BrideName",EBLL.BrideName1), //new SqlParameter("@GroomName",EBLL.GroomName1), //new SqlParameter("@Date",EBLL.Date1), }; dr = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "EventMyCtSelect", par); if (dr.HasRows) { dr.Read(); EBLL.BrideName1 = Convert.ToString(dr["BrideName"]); EBLL.GroomName1 = Convert.ToString(dr["GroomName"]); EBLL.InvitionFrom1 = Convert.ToString(dr["InvitionFrom"]); EBLL.Date1 = Convert.ToString(dr["Date"]); EBLL.Time1 = Convert.ToString(dr["Time"]); EBLL.Location1 = Convert.ToString(dr["Location"]); EBLL.RemDate1 = Convert.ToString(dr["RemDate"]); EBLL.RemTime1 = Convert.ToString(dr["RemTime"]); EBLL.MobileNumber1 = Convert.ToString(dr["MobileNumber"]); EBLL.PersonName1 = Convert.ToString(dr["PersonName"]); EBLL.PVisit1 = Convert.ToString(dr["PVisit"]); //EBLL.MyCt_UserId1 = Convert.ToString(dr[Session["User"].ToString()]); EBLL.MDescp1 = Convert.ToString(dr["MDescp"]); } } } catch (SqlException ex) { throw ex; } finally { conn.Close(); } }
public int Addrecord(EventMyctBLL EBLL) { int row; try { conn.Open(); using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { string str = DateTime.Now.Date.ToString("yyyy-MM-dd"); SqlParameter[] par = new SqlParameter[] { new SqlParameter("@BrideName", EBLL.BrideName1), new SqlParameter("@GroomName", EBLL.GroomName1), new SqlParameter("@InvitionFrom", EBLL.InvitionFrom1), new SqlParameter("@Date", EBLL.Date1), new SqlParameter("@Time", EBLL.Time1), new SqlParameter("@RemDate", EBLL.RemDate1), new SqlParameter("@RemTime", EBLL.RemTime1), new SqlParameter("@Location", EBLL.Location1), new SqlParameter("@PersonName", EBLL.PersonName1), new SqlParameter("@MobileNumber", EBLL.MobileNumber1), new SqlParameter("@PVisit", EBLL.PVisit1), new SqlParameter("@MyCt_UserId", EBLL.MyCt_UserId1), new SqlParameter("@MDescp", EBLL.MDescp1), new SqlParameter("@CurrentDate", str), new SqlParameter("@Status1", EBLL.Status3), new SqlParameter("@Status2", EBLL.Status4), }; row = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "EventMyCtInsert", par); } return(row); } catch (Exception ex) { throw ex; } finally { conn.Close(); } }
public void SelectUserRecord(EventMyctBLL objEventMyctBLL) { objEventMyctDAL.SelectUserMaster(objEventMyctBLL); }
//public int DeleterecordBll(EventMyctBLL objEventMyctBLL) //{ // int i = objEventMyctDAL.Deleterecord(objEventMyctBLL); // return i; //} public void Selectrecord(EventMyctBLL objEventMyctBLL) { objEventMyctDAL.SelectRecord(objEventMyctBLL); }
public int UpdaterecordBll(EventMyctBLL objEventMyctBLL) { int i = objEventMyctDAL.Updaterecord(objEventMyctBLL); return(i); }
public DataSet LoadgridBLL(EventMyctBLL objEventMyctBLL) { return(objEventMyctDAL.loadgrid(objEventMyctBLL)); }
public int AddrecordBll(EventMyctBLL objEventMyctBLL) { int i = objEventMyctDAL.Addrecord(objEventMyctBLL); return(i); }