public int Delete_Data(tbl_QueryProp Objtbl_QueryProp) { int _RetVal = 0; SqlCommand cmdToExecute = new SqlCommand(); cmdToExecute.CommandText = "Delete_tbl_Query"; cmdToExecute.CommandType = CommandType.StoredProcedure; // Use base class' connection object cmdToExecute.Connection = objdb.objConnection; try { objdb.GetConnStr(); //Database DB = DatabaseFactory.CreateDatabase("AppConAnant"); //DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_Query"); cmdToExecute.Parameters.Add(new SqlParameter("@MessageCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.MessageCode)); return(cmdToExecute.ExecuteNonQuery()); } catch (Exception ex) { throw ex; } finally { objdb.CloseConnection();; } }
public DataSet CountUnreadMessage(tbl_QueryProp Objtbl_QueryProp) { SqlCommand cmdToExecute = new SqlCommand(); cmdToExecute.CommandText = "CountUnreadMessage"; cmdToExecute.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); SqlDataAdapter da = null; // Use base class' connection object cmdToExecute.Connection = objdb.objConnection; try { //Database DB = DatabaseFactory.CreateDatabase("AppConAnant"); //DbCommand DBCmd = DB.GetStoredProcCommand("CountUnreadMessage"); objdb.GetConnStr(); da = new SqlDataAdapter(cmdToExecute); da.Fill(ds); return(ds); } catch (Exception ex) { throw ex; } finally { objdb.CloseConnection();; } }
public DataSet Search_Data(tbl_QueryProp Objtbl_QueryProp) { SqlCommand cmdToExecute = new SqlCommand(); cmdToExecute.CommandText = "Search_tbl_Query"; cmdToExecute.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); SqlDataAdapter da = null; // Use base class' connection object cmdToExecute.Connection = objdb.objConnection; try { objdb.GetConnStr(); //Database DB = DatabaseFactory.CreateDatabase("AppConAnant"); //DbCommand DBCmd = DB.GetStoredProcCommand("Search_tbl_Query"); cmdToExecute.Parameters.Add(new SqlParameter("@SearchBy", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.SearchBy)); cmdToExecute.Parameters.Add(new SqlParameter("@SearchVal", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.SearchVal)); da = new SqlDataAdapter(cmdToExecute); da.Fill(ds); return(ds); } catch (Exception ex) { throw ex; } finally { objdb.CloseConnection();; } }
public DataSet CountUnreadMessage(tbl_QueryProp Objtbl_QueryProp) { try { tbl_QueryDAL Objtbl_QueryDAL = new tbl_QueryDAL(); return(Objtbl_QueryDAL.CountUnreadMessage(Objtbl_QueryProp)); } catch (Exception ex) { throw ex; } }
public DataSet Search_Data(tbl_QueryProp Objtbl_QueryProp) { try { tbl_QueryDAL Objtbl_QueryDAL = new tbl_QueryDAL(); return(Objtbl_QueryDAL.Search_Data(Objtbl_QueryProp)); } catch (Exception ex) { throw ex; } }
public int Delete_Data(tbl_QueryProp Objtbl_QueryProp) { try { tbl_QueryDAL Objtbl_QueryDAL = new tbl_QueryDAL(); return(Objtbl_QueryDAL.Delete_Data(Objtbl_QueryProp)); } catch (Exception ex) { throw ex; } }
public DataSet Select_Data(tbl_QueryProp Objtbl_QueryProp, ref int TotalCount) { int TotalCnt = 0; SqlCommand cmdToExecute = new SqlCommand(); cmdToExecute.CommandText = "Select_tbl_Query"; cmdToExecute.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); SqlDataAdapter da = null; // Use base class' connection object cmdToExecute.Connection = objdb.objConnection; try { objdb.GetConnStr(); //Database DB = DatabaseFactory.CreateDatabase("AppConAnant"); //DbCommand DBCmd = DB.GetStoredProcCommand("Select_tbl_Query"); cmdToExecute.Parameters.Add(new SqlParameter("@MessageCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.MessageCode)); //cmdToExecute.Parameters.Add(new SqlParameter("@MsgFrom", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.SearchVal)); //cmdToExecute.Parameters.Add(new SqlParameter("@Status", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.Status)); cmdToExecute.Parameters.Add(new SqlParameter("@PageNo", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.PageNo)); cmdToExecute.Parameters.Add(new SqlParameter("@RecordCount", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.RecordCount)); cmdToExecute.Parameters.Add(new SqlParameter("@TotalCount", SqlDbType.Int, 20, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, TotalCount)); //DB.AddOutParameter(DBCmd, "@TotalCount", DbType.Int32, 18); //DataSet dsData = DB.ExecuteDataSet(DBCmd); //TotalCount = Convert.ToInt32(DBCmd.Parameters["@TotalCount"].Value); da = new SqlDataAdapter(cmdToExecute); da.Fill(ds); TotalCount = Convert.ToInt32(cmdToExecute.Parameters["@TotalCount"].Value); return(ds); } catch (Exception ex) { throw ex; } finally { objdb.CloseConnection();; } }
public int InsertUpdate_Data(tbl_QueryProp Objtbl_QueryProp) { int _RetVal = 0; SqlCommand cmdToExecute = new SqlCommand(); cmdToExecute.CommandText = "InsertUpdate_tbl_Query"; cmdToExecute.CommandType = CommandType.StoredProcedure; // Use base class' connection object cmdToExecute.Connection = objdb.objConnection; try { objdb.GetConnStr(); //Database DB = DatabaseFactory.CreateDatabase("AppConAnant"); //DbCommand DBCmd = DB.GetStoredProcCommand("InsertUpdate_tbl_Query"); cmdToExecute.Parameters.Add(new SqlParameter("@MessageCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.MessageCode)); cmdToExecute.Parameters.Add(new SqlParameter("@Surname", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.Surname)); cmdToExecute.Parameters.Add(new SqlParameter("@SenderName", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.SenderName)); cmdToExecute.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.Address)); cmdToExecute.Parameters.Add(new SqlParameter("@ContactNo", SqlDbType.NVarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.ContactNo)); cmdToExecute.Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar, 30, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.Email)); cmdToExecute.Parameters.Add(new SqlParameter("@Subject", SqlDbType.NVarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.Subject)); cmdToExecute.Parameters.Add(new SqlParameter("@SenderMessage", SqlDbType.NVarChar, 5000, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.SenderMessage)); cmdToExecute.Parameters.Add(new SqlParameter("@Status", SqlDbType.Bit, 3, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.Status)); cmdToExecute.Parameters.Add(new SqlParameter("@Date", SqlDbType.Date, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_QueryProp.Date)); return(cmdToExecute.ExecuteNonQuery()); } catch (Exception ex) { throw ex; } finally { objdb.CloseConnection();; } }
public DataSet Select_Data(tbl_QueryProp Objtbl_QueryProp, ref int PageCount) { try { if (Objtbl_QueryProp.MessageCode != 0) { Objtbl_QueryProp.PageNo = 1; Objtbl_QueryProp.RecordCount = 1; } int RecordCount = 0; tbl_QueryDAL Objtbl_QueryDAL = new tbl_QueryDAL(); DataSet dsData = Objtbl_QueryDAL.Select_Data(Objtbl_QueryProp, ref RecordCount); double Page = Convert.ToDouble(RecordCount) / Convert.ToDouble(Objtbl_QueryProp.RecordCount); if (dsData.Tables[0].Rows.Count > 0) { string[] PageDecimal = Page.ToString().Split('.'); if (PageDecimal.Length > 1 && Convert.ToInt32(PageDecimal[1]) > 0) { PageCount = Convert.ToInt32(Page.ToString().Split('.')[0]) + 1; } else { PageCount = Convert.ToInt32(Page); } } else { PageCount = 0; } return(dsData); } catch (Exception ex) { throw ex; } }