Beispiel #1
0
 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;
     }
 }
Beispiel #2
0
 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;
     }
 }
Beispiel #3
0
 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;
     }
 }
Beispiel #4
0
 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;
     }
 }
Beispiel #5
0
 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;
     }
 }
Beispiel #6
0
 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;
     }
 }
Beispiel #7
0
 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;
     }
 }