public DataSet Search_Data(tbl_FeedbackMasterProp Objtbl_FeedbackMasterProp) { try { tbl_FeedbackMasterDAL Objtbl_FeedbackMasterDAL = new tbl_FeedbackMasterDAL(); return(Objtbl_FeedbackMasterDAL.Search_Data(Objtbl_FeedbackMasterProp)); } catch (Exception ex) { throw ex; } }
public int Delete_Data(tbl_FeedbackMasterProp Objtbl_FeedbackMasterProp) { try { tbl_FeedbackMasterDAL Objtbl_FeedbackMasterDAL = new tbl_FeedbackMasterDAL(); return(Objtbl_FeedbackMasterDAL.Delete_Data(Objtbl_FeedbackMasterProp)); } catch (Exception ex) { throw ex; } }
public int Delete_Data(tbl_FeedbackMasterProp Objtbl_FeedbackMasterProp) { try { Database DB = DatabaseFactory.CreateDatabase("AppConNagar"); DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_FeedbackMaster"); DB.AddInParameter(DBCmd, "@MessageCode", DbType.Int32, Objtbl_FeedbackMasterProp.MessageCode); return(DB.ExecuteNonQuery(DBCmd)); } catch (Exception ex) { throw ex; } }
public DataSet Search_Data(tbl_FeedbackMasterProp Objtbl_FeedbackMasterProp) { try { Database DB = DatabaseFactory.CreateDatabase("AppConNagar"); DbCommand DBCmd = DB.GetStoredProcCommand("Search_tbl_FeedbackMaster"); DB.AddInParameter(DBCmd, "@SearchBy", DbType.String, Objtbl_FeedbackMasterProp.SearchBy); DB.AddInParameter(DBCmd, "@SearchVal", DbType.String, Objtbl_FeedbackMasterProp.SearchVal); return(DB.ExecuteDataSet(DBCmd)); } catch (Exception ex) { throw ex; } }
public DataSet Select_Data(tbl_FeedbackMasterProp Objtbl_FeedbackMasterProp, ref int TotalCount) { try { Database DB = DatabaseFactory.CreateDatabase("AppConNagar"); DbCommand DBCmd = DB.GetStoredProcCommand("Select_tbl_FeedbackMaster"); DB.AddInParameter(DBCmd, "@MessageCode", DbType.Int32, Objtbl_FeedbackMasterProp.MessageCode); DB.AddInParameter(DBCmd, "@PageNo", DbType.Int32, Objtbl_FeedbackMasterProp.PageNo); DB.AddInParameter(DBCmd, "@RecordCount", DbType.Int32, Objtbl_FeedbackMasterProp.RecordCount); DB.AddOutParameter(DBCmd, "@TotalCount", DbType.Int32, 18); DataSet dsData = DB.ExecuteDataSet(DBCmd); TotalCount = Convert.ToInt32(DBCmd.Parameters["@TotalCount"].Value); return(dsData); } catch (Exception ex) { throw ex; } }
public int InsertUpdate_Data(tbl_FeedbackMasterProp Objtbl_FeedbackMasterProp) { try { Database DB = DatabaseFactory.CreateDatabase("AppConNagar"); DbCommand DBCmd = DB.GetStoredProcCommand("InsertUpdate_tbl_FeedbackMaster"); DB.AddInParameter(DBCmd, "@MessageCode", DbType.Int32, Objtbl_FeedbackMasterProp.MessageCode); DB.AddInParameter(DBCmd, "@MessageDescription", DbType.String, Objtbl_FeedbackMasterProp.MessageDescription); DB.AddInParameter(DBCmd, "@MessageCreatedDate", DbType.DateTime, Objtbl_FeedbackMasterProp.MessageCreatedDate); DB.AddInParameter(DBCmd, "@MemberCode", DbType.Int32, Objtbl_FeedbackMasterProp.MemberCode); DB.AddOutParameter(DBCmd, "@RetVal", DbType.Int32, 18); DB.ExecuteNonQuery(DBCmd); return(Convert.ToInt32(DBCmd.Parameters["@RetVal"].Value)); } catch (Exception ex) { throw ex; } }
public DataSet Select_Data(tbl_FeedbackMasterProp Objtbl_FeedbackMasterProp, ref int PageCount) { try { if (Objtbl_FeedbackMasterProp.MessageCode != 0) { Objtbl_FeedbackMasterProp.PageNo = 1; Objtbl_FeedbackMasterProp.RecordCount = 1; } int RecordCount = 0; tbl_FeedbackMasterDAL Objtbl_FeedbackMasterDAL = new tbl_FeedbackMasterDAL(); DataSet dsData = Objtbl_FeedbackMasterDAL.Select_Data(Objtbl_FeedbackMasterProp, ref RecordCount); double Page = Convert.ToDouble(RecordCount) / Convert.ToDouble(Objtbl_FeedbackMasterProp.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; } }