public int AddRecord(EventNewsBLL SPNB) { int row; SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); string str = DateTime.Now.Date.ToString("yyyy-MM-dd"); try { //string str = DateTime.Now.Date.ToString("yyyy-MM-dd"); SqlParameter[] par = new SqlParameter[] { new SqlParameter("@NewsHead ", SPNB.NewsHead1), new SqlParameter("@NewsDetails", SPNB.NewsDetails1), new SqlParameter("@NPaper", SPNB.NPaper1), new SqlParameter("@Role", SPNB.Role1), new SqlParameter("@Date", SPNB.Date1), new SqlParameter("@Time", SPNB.Time1), new SqlParameter("@TypeOfNews", SPNB.TypeOfNews1), new SqlParameter("@Location", SPNB.Location1), new SqlParameter("@Feedback", SPNB.Feedback1), new SqlParameter("@UserId", SPNB.UserId1), //new SqlParameter("@Status1",SPNB.Status3), //new SqlParameter("@Status2",SPNB.Status4), new SqlParameter("@CurrentDate", str), }; SqlCommand cmd1 = new SqlCommand("EventNewsInsert", con); cmd1.Parameters.AddRange(par); cmd1.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd1); con.Open(); row = cmd1.ExecuteNonQuery(); return(row); } catch (Exception ex) { throw ex; } finally { con.Close(); } }
public DataSet LoadGrid(EventNewsBLL SPNB) { try { DataSet ds = new DataSet(); SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); SqlParameter[] par = new SqlParameter[1]; par[0] = new SqlParameter("@UserId", SPNB.UserId1); SqlCommand cmd = new SqlCommand("EventLoadGridNews", 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 void SelectRecord(EventNewsBLL SPNB) { SqlDataReader dr; try { conn.Open(); using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { SqlParameter[] par = new SqlParameter[] { new SqlParameter("@NID", SPNB.NID1) }; dr = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "EventSelectNews", par); if (dr.HasRows) { dr.Read(); SPNB.NewsHead1 = Convert.ToString(dr["NewsHead"]); SPNB.NewsDetails1 = Convert.ToString(dr["NewsDetails"]); SPNB.NPaper1 = Convert.ToString(dr["NPaper"]); SPNB.Role1 = Convert.ToString(dr["Role"]); SPNB.Date1 = Convert.ToString(dr["Date"]); SPNB.Time1 = Convert.ToString(dr["Time"]); SPNB.TypeOfNews1 = Convert.ToString(dr["TypeOfNews"]); SPNB.Location1 = Convert.ToString(dr["Location"]); SPNB.Feedback1 = Convert.ToString(dr["Feedback"]); } } } catch (Exception ex) { throw ex; } finally { conn.Close(); } }
public int UpdateRecord(EventNewsBLL SPNB) { int row; try { conn.Open(); using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { SqlParameter[] par = new SqlParameter[] { new SqlParameter("@NID", SPNB.NID1), new SqlParameter("@NewsHead", SPNB.NewsHead1), new SqlParameter("@NewsDetails", SPNB.NewsDetails1), new SqlParameter("@NPaper", SPNB.NPaper1), new SqlParameter("@Role", SPNB.Role1), new SqlParameter("@Date", SPNB.Date1), new SqlParameter("@Time", SPNB.Time1), new SqlParameter("@TypeOfNews", SPNB.TypeOfNews1), new SqlParameter("@Location", SPNB.Location1), new SqlParameter("@Feedback", SPNB.Feedback1), new SqlParameter("@UserId", SPNB.UserId1), }; row = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "sp_UENewsMyCt", par); } return(row); } catch (Exception ex) { throw ex; } finally { conn.Close(); } }
public int UpdateBLL(EventNewsBLL objEventNewsBLL) { int i = objEventNewsDAL.UpdateRecord(objEventNewsBLL); return(i); }
public void SelectRecordBLL(EventNewsBLL objEventNewsBLL) { objEventNewsDAL.SelectRecord(objEventNewsBLL); }
public int AddRecordBLL(EventNewsBLL objEventNewsBLL) { int i = objEventNewsDAL.AddRecord(objEventNewsBLL); return(i); }
public DataSet LoadGridBLL1(EventNewsBLL objEventNewsBLL) { return(objEventNewsDAL.LoadGrid(objEventNewsBLL)); }