Esempio n. 1
0
        public DataSet GetEmailDetails(EmailSchema ObjEmailSchema)
        {
            SqlConnection objConn = SQLHelper.OpenConnection();

            try
            {
                SqlParameter[] param = new SqlParameter[1];

                param[0]       = new SqlParameter("@ApplicationID", SqlDbType.VarChar);
                param[0].Value = ObjEmailSchema.ApplicationID;

                using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Usp_GetEmailIDDetails", param))
                {
                    return(ds);
                }
            }
            catch (Exception ex)
            {
                return(null);
            }
            finally
            {
                SQLHelper.CloseConnection(objConn);
            }
        }
Esempio n. 2
0
 public DataSet GetEmailDetails(EmailSchema ObjEmailSchema)
 {
     try
     {
         ds = ObjEmailDAL.GetEmailDetails(ObjEmailSchema);
         return(ds);
     }
     catch (Exception e)
     {
         return(null);
     }
     finally
     {
         ds = null;
     }
 }