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);
}
}
public DataSet GetEmailDetails(EmailSchema ObjEmailSchema)
{
try
{
ds = ObjEmailDAL.GetEmailDetails(ObjEmailSchema);
return(ds);
}
catch (Exception e)
{
return(null);
}
finally
{
ds = null;
}
}